[jboss-user] [JBoss jBPM] - Problem: hibernate and webapp sample

[ricardomarques]

Hi guys

I'm getting this error when running the web app sample, with the jbpm 3.2 hibernate configurations:


  | 18:09:21,996 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could not execute query
  |         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
  |         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  |         at org.hibernate.loader.Loader.doList(Loader.java:2147)
  |         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
  |         at org.hibernate.loader.Loader.list(Loader.java:2023)
  |         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
  |         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
  |         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
  |         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
  |         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
  |         at org.jbpm.db.GraphSession.findLatestProcessDefinitions(GraphSession.java:184)
  |         at HomeServlet.getProcessDefinitions(HomeServlet.java:76)
  |         at HomeServlet.writeProcessDefinitionOptions(HomeServlet.java:62)
  |         at HomeServlet.service(HomeServlet.java:49)
  |         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
  |         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
  |         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |         at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  |         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  |         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
  |         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
  |         at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
  |         at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
  |         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
  |         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
  |         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
  |         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
  |         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
  |         at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
  |         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
  |         at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
  |         at java.lang.Thread.run(Thread.java:595)
  | Caused by: java.sql.SQLException: Table not found in statement [select processdef0_.ID_ as ID1_30_, processdef0_.NAME_ as NAME3_30_, processdef0_.DESCRIPTION_ as DESCRIPT4_30_, processdef0_.VERSION_ as VERSION5_30_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_30_, processdef0_.STARTSTATE_ as STARTSTATE7_30_ from JBPM_PROCESSDEFINITION processdef0_ order by processdef0_.NAME_, processdef0_.VERSION_ desc]
  |         at org.hsqldb.jdbc.Util.throwError(Unknown Source)
  |         at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
  |         at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
  |         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497)
  |         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415)
  |         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
  |         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1560)
  |         at org.hibernate.loader.Loader.doQuery(Loader.java:661)
  |         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
  |         at org.hibernate.loader.Loader.doList(Loader.java:2144)
  |         ... 30 more
  | 18:09:22,293 ERROR [GraphSession] org.hibernate.exception.SQLGrammarException: could not execute query
  | 18:09:22,293 ERROR [[HomeServlet]] Servlet.service() for servlet HomeServlet threw exception
  | org.jbpm.JbpmException: couldn't find latest versions of process definitions
  | 
  | 

Ideas?

PS: first time using hibernate.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039932#4039932

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4039932