ClassNotFoundException: org.hibernate.hql.ast.HqlToken

[Giant]

Hi all, I'm tryng to use the class HibernateTemplate to read data from database. My web application run on a wls8.1 and i'm using Spring 2.03 framework.

the follow code work fine:

public List getProductList() {
return this.getHibernateTemplate().loadAll(Product.class);
}

instead this one doesn't work:

public List getProductList() {
return this.getHibernateTemplate().find("from bus.beans.Product");
}

The error messagge is:

org.springframework.orm.hibernate3.HibernateQueryException: ClassNotFoundException: org.hibernate.hql.ast.HqlToken [from bus.beans.Product]; nested exception is org.hibernate.QueryException: ClassNotFoundException: org.hibernate.hql.ast.HqlToken [from bus.beans.Product]
Caused by: org.hibernate.QueryException: ClassNotFoundException: org.hibernate.hql.ast.HqlToken [from bus.beans.Product]
	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:44)
	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:242)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
	at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:837)
	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:835)
	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:827)
	at db.ProductManagerDaoHB.getProductList(ProductManagerDaoHB.java:14)
	at bus.ProductManager.getProducts(ProductManager.java:25)
	at web.controllers.SpringappController.handleRequest(SpringappController.java:33)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:819)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:754)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:399)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:354)
	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:971)
	at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402)
	at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6350)
	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:3635)
	at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585)
	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)

Anyone can help me?

[Andrei Stefan]

See this post, maybe it helps:
http://forum.springframework.org/sho...l.ast.HqlToken

[Giant]

I've saw it but it seems that there isn't another antln.jar library in my weblogic server.

[Giant]

Solved by adding antlr.jar to PRE_CLASSPATH in application server startup command.
But I think isn't a good way to solve the problem.

[toto]

J'ai eu le m pb, tu peux essayer ajouter un "property" dans ton "hibernate.cfg.xml"


<!-- this is required for weblogic-->
<property name="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFa ctory
</property>

[fbeli]

What are you say with ' PRE_CLASSPATH "

I have de same problem and I using antlr-2.7.6

[kay]

There is another way to fix this issue with WLS 10.x - create a weblogic-application.xml with the following contents:

<?xml version="1.0" encoding="ISO-8859-1"?>
<weblogic-application>
    <prefer-application-packages>
        <package-name>antlr.*</package-name>
    </prefer-application-packages>
</weblogic-application>

[manjunathmnm]

Hi Kay,

Where should we put the weblogic-application.xml under a web app. We tried using weblogic.xml setting <prefer-web-inf-classes> to true, but we ran into JSP compilation issues. Here is a sample stack trace:

): javax.servlet.ServletException: [HTTP:101249][weblogic.servlet.internal.WebAppServletContex
at weblogic.servlet.jsp.JspStub.prepareServlet(JspStu b.java:262)

Any ideas what's the error.

Thanks,
Manjunath

[kay]

The file weblogic-application.xml works only in an EAR - bundled alongside the J2EE standard application.xml. The prefer-web-inf-classes option is all or nothing, as far as I know, if you only need to override specific packages then you have to create an EAR.

The reason your JSP compilation is not working is probably because you're bundling some Servlet API classes with your WAR, and that's breaking the WebLogic JSP compiler.

[manjunathmnm]

Kay,

Can you point me in right direction to resolve this issue.

-Manju