11 Replies Latest reply on Apr 2, 2007 4:37 PM by hipchic

    jbpm 3.2 - sample - websale cannot run - table or view doesn

    hipchic Newbie

      environment:
      - tomcat 5.5
      - oracle xe 10g
      - jbpm 3.2 GA

      I try to run the websale demo, but when i launch the websale process with the jbpm-console, i have a database error, it seems a table or view doesn't exist.

      here my stackstrace:


      javax.faces.FacesException: javax.el.ELException: /main/task/view.xhtml @150,78 value="#{bean.identityUserSelectionItems}": org.hibernate.exception.SQLGrammarException: could not execute query
      at javax.faces.component.UISelectItems.getValue(UISelectItems.java:133)
      at com.sun.faces.renderkit.RenderKitUtils.getSelectItems(RenderKitUtils.java:323)
      at com.sun.faces.renderkit.html_basic.MenuRenderer.getOptionNumber(MenuRenderer.java:644)
      at com.sun.faces.renderkit.html_basic.MenuRenderer.renderSelect(MenuRenderer.java:762)
      at com.sun.faces.renderkit.html_basic.MenuRenderer.encodeEnd(MenuRenderer.java:304)
      at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:829)
      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:894)
      at javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
      at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:810)
      at org.jbpm.webapp.tag.jbpm.ui.ComponentBase.doEncode(ComponentBase.java:33)
      at org.jbpm.webapp.tag.jbpm.ui.ComponentBase.doEncode(ComponentBase.java:45)
      at org.jbpm.webapp.tag.jbpm.ui.DataForm.renderCells(DataForm.java:117)
      at org.jbpm.webapp.tag.jbpm.ui.DataForm.encodeChildren(DataForm.java:95)
      at org.jbpm.webapp.tag.jbpm.ui.ComponentBase.doEncode(ComponentBase.java:33)
      at org.jbpm.webapp.tag.jbpm.ui.ComponentBase.doEncode(ComponentBase.java:58)
      at org.jbpm.webapp.tag.jbpm.ui.Tab.encodeChildren(Tab.java:112)
      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:884)
      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:890)
      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:890)
      at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:578)
      at org.jbpm.webapp.application.JbpmViewHandler.renderView(JbpmViewHandler.java:58)
      at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
      at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:248)
      at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:59)
      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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
      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.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: javax.el.ELException: /main/task/view.xhtml @150,78 value="#{bean.identityUserSelectionItems}": org.hibernate.exception.SQLGrammarException: could not execute query
      at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
      at javax.faces.component.UISelectItems.getValue(UISelectItems.java:130)
      ... 42 more
      Caused by: 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:2214)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
      at org.hibernate.loader.Loader.list(Loader.java:2090)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
      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.identity.hibernate.IdentitySession.getUsers(IdentitySession.java:194)
      at org.jbpm.webapp.bean.TaskInstanceBean.getIdentityUserSelectionItems(TaskInstanceBean.java:101)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at javax.el.BeanELResolver.getValue(BeanELResolver.java:218)
      at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:135)
      at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
      at com.sun.el.parser.AstValue.getValue(AstValue.java:96)
      at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:183)
      at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
      ... 43 more
      Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:911)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1121)
      at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:962)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1243)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3459)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
      at org.hibernate.loader.Loader.doQuery(Loader.java:662)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      at org.hibernate.loader.Loader.doList(Loader.java:2211)
      ... 62 more


      I check on the forum, and it seems, there is a sql script generated but i sawn nothing in samples.


      thanks for your reply


      PS: i succeed to deploy/run a test process, which you can create by default with eclipse with the jbpm plugin (jbpm designer). But it doesn't use the database.