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 Mar 30, 2007 3:32 PM

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.

1. Re: jbpm 3.2 - sample - websale cannot run - table or view d

hipchic Mar 30, 2007 3:35 PM (in response to hipchic)

I have another question when i try to run the JUnit Tests "WebsaleTest"

public void loadIdentities() {
JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
try {
Entity[] entities = IdentityXmlParser.parseEntitiesResource("hsqldb/identity.db.xml");
IdentitySession identitySession = new IdentitySession(jbpmContext.getSession());
for (int i=0; i<entities.length; i++) {
identitySession.saveEntity(entities);
}
} finally {
jbpmContext.close();
}
}

I don't find where these file hsqldb/identity.db.xml ????
Where i can found it ?
Actions
2. Re: jbpm 3.2 - sample - websale cannot run - table or view d

hipchic Apr 2, 2007 10:39 AM (in response to hipchic)

Nobody have these errors for the sample websale :

- Table or View doesn't exist ?

- Where i can find the file hsqldb/identity.db.xml ?
Actions
3. Re: jbpm 3.2 - sample - websale cannot run - table or view d

froschfinger Apr 2, 2007 10:50 AM (in response to hipchic)

Your_Path\jbpm-starters-kit-3.1.2\jbpm\src\resources\hsqldb

there you find the identity.db

Did you already checked your database concerning the necessary table? It looks like that there is no table in this database with this name. Maybe there were problems during creating it. You should check this.
Actions
4. Re: jbpm 3.2 - sample - websale cannot run - table or view d

froschfinger Apr 2, 2007 10:51 AM (in response to hipchic)

i have to say, that i used the JBPM 3.1.2. I hope the folder structure is the same.
Actions
5. Re: jbpm 3.2 - sample - websale cannot run - table or view d

estaub Apr 2, 2007 11:13 AM (in response to hipchic)

The folder structure is quite different in 3.2.
There was another thread regarding getting the identities loaded up during the last few days - see
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=105009&postdays=0&postorder=asc&start=10 and
http://wiki.jboss.org/wiki/Wiki.jsp?page=UseHibernateToCreateJbpmDB

-Ed Staub
Actions
6. Re: jbpm 3.2 - sample - websale cannot run - table or view d

hipchic Apr 2, 2007 11:25 AM (in response to hipchic)

Thanks for your replies,

It don't think so , it's a user database configuration, i use the tomcat context for doing these and it's works well...

But the websale doesn't use the tomcat user authentication by default ? you have to setup the database for running the sample ?

thks...
Actions
7. Re: jbpm 3.2 - sample - websale cannot run - table or view d

hipchic Apr 2, 2007 11:27 AM (in response to hipchic)

More informations

How my environment is setup => http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnTomcatOracle
Actions
8. Re: jbpm 3.2 - sample - websale cannot run - table or view d

wjm Apr 2, 2007 11:47 AM (in response to hipchic)

"hipchic" wrote:
Thanks for your replies,
It don't think so , it's a user database configuration, i use the tomcat context for doing these and it's works well...

The websale process archive as uploaded from the designer does seem to have dependencies upon the jbpm-style UserRealm. You need to emulate the membership functionality, I think, within an ordinary tomcat realm. That is to say, an association between user and group must be established and findable by the JDBCUserRealm. I dont think the default tomcat user realm provides that.

----
Bill
Actions
9. Re: jbpm 3.2 - sample - websale cannot run - table or view d

hipchic Apr 2, 2007 2:39 PM (in response to hipchic)

thanks it s work great now !
Actions
10. Re: jbpm 3.2 - sample - websale cannot run - table or view d

estaub Apr 2, 2007 3:14 PM (in response to hipchic)

>> thanks it s work great now !

hipchic,

What did you need to do to get it working?
(Help the next person!)

-Ed Staub
Actions
11. Re: jbpm 3.2 - sample - websale cannot run - table or view d

hipchic Apr 2, 2007 4:37 PM (in response to hipchic)

All the setup i did is explain here
oracle => http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnTomcatOracle

You have also the version with mysql =>
http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnTomcat

And in the starter kit you have the sample
for deploy on your server
- install jboss plugin for eclipse
- and create a jboss process project and import all the data in the correct directory
- and just deploy the application

This viewlet has been very useful for understand the deploy process => http://docs.jboss.com/jbpm/v3/demos/movies/jbpm-overview.htm

I hope it will be heplful.

PS: jboss plugin ask for a runtime directory specify the "jbpm-jpdl-3.2.GA", even you use the tomcat application server !

Bye
Regis[/url]
Actions

Go to original post