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: anonymous wrote : | 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. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4033343#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...