I have a simple java client that does the following
Query query = session.createQuery("....hql stmt...");
query.setString("userid", userid);
List list = query.list(); /* PROBLEM OCCUR in weblogic8.1! */


Above codes works smoothly as a standalone program. But when it is deployed into weblogic 8.1 as a web module.....

With hibernate 3.0
----------------------
statement "query.list()" crashs the server. I need to restart weblogic server.

With hibernate 3.1
---------------------
statement "query.list" cause the following exception
[ERROR]org.hibernate.QueryException: ClassNotFoundException: org.hibernate.hql.ast.HqlToken [select x1.mgmtCompanyCode from com.fundserv.aia.persistent.IFPSLoginXRef x1, com.fundserv.aia.persistent.Company m1 where x1.mgmtCompanyCode = m1.companyCode and m1.statusCD = 'A' and x1.userid = :userid]
at org.hibernate.hql.ast.HqlLexer.panic(HqlLexer.java:57)
at antlr.CharScanner.setTokenObjectClass(CharScanner.java:340)
at org.hibernate.hql.ast.HqlLexer.setTokenObjectClass(HqlLexer.java:31)
at antlr.CharScanner.<init>(CharScanner.java:51)
at antlr.CharScanner.<init>(CharScanner.java:60)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:56)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:53)
at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:50)
at org.hibernate.hql.ast.HqlLexer.<init>(HqlLexer.java:26)
at org.hibernate.hql.ast.HqlParser.getInstance(HqlParser.java:45)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:228)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:151)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:101)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:468)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1025)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:975)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at com.fundserv.aia.dao.UserDAO.load(Unknown Source)
at com.fundserv.aia.busobj.IFPSBusinessLogic.findUserBySessionID(Unknown Source)
at com.fundserv.aia.actions.IFPSAuthBaseAction.process(Unknown Source)
at com.fundserv.aia.actions.IFPSBaseAction.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6310)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)

Any Idea?
I am a first time user of hibernate. Any information would be grateful.

You apparently have some missing JAR files.


Maybe you just copied over your Hibernate3.jar and forgot the others
(ast, cglib, ehcache etc.)

The Missing symbol "org.hibernate.hql.ast.HqlToken" is actually in hibernate3.jar file. This jar file is already in WEB-INF/lib directory.

Ok.

Is this code executing in the webapp side, or is it executing from and EJB Bean?

This code is executing in the webapp side. A BusinessLogic class invoked by a struts action class.

Is this business logic class itself located in a jar under WEB-INF/lib?

This BusinessLogic class is located under WEB-INF/classes

Well well...

Are you sure that there are none of your business classes that would get loaded by accident through weblogic server's classpath? Can you be 100% sure that the class that executes gets loaded from within your web application and not from some other jar that have been left in the server's classpath?

This really does not look like a hibernate problem but more like a web application structure or weblogic classpath problem.

My classpath is unset. The complain missing symbol "org.hibernate.hql.ast.HqlToken" is already in hibernate3.jar.

Try using the classic parser. The new ANTLER parser does not play well with weblogic 8 (because it also uses an older version of the same parser).

Also take a look at the Hibernate2 -> Hibernate3 migration guide. It goes into more details on the issues.

that is the worst (but ok) workaround.

the best workaround is to place the antlr-*.jar we provide in the classpath of weblogic lib path (per the migration guide)

Our production people don't allow the changing of the weblogic classpath (which is a bummer). So if you can change the classpath, I'd use max's suggestion (per the migration guide).