[jboss-user] [JBoss jBPM] - Tomcat 5.5 - Jbpm 3.2 - Starting failed <<couldn't get acqui

[hipchic]

Hi, i try to deploy on my tomcat 5.5.20 jbpm 3.2, and i used oracle 10g express edition, my problem it is a configuration database, but i didn't find some scripts for resolve my problem.

SO here the steps i have followed :

- download the jbpm-jpdl-suite-3.2.GA.zip (extract)

- copy the war file C:\jbpm-jpdl-3.2.GA\deploy\jbpm-console.war in your $CATALINA_HOME\webapps\ 

- modify the hibernate.cfg.xml in the jbpm-console.war file (you can also find the file in the config directory)

These the part of file i have modified

  |  <!-- JDBC connection properties (begin) -->
  |     <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
  |     <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
  |     <property name="hibernate.connection.username">jbpm</property>
  |     <property name="hibernate.connection.password">jbpm</property>
  |     <!-- JDBC connection properties (end) -->
  |  <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
  | 

- i copy all the librairies in C:\jbpm-jpdl-3.2.GA\lib\*.jar in my $CATALINA_HOME\webapps\jbpm-console\WEB-INF\lib
i have copy the ojdb14.jar (oracle driver) in my $CATALINA_HOME\webapps\jbpm-console\WEB-INF\lib


- and i run the oracle script jbpm-jpdl-3-suite.2.GA\db\jbpm.jpdl.oracle.sql in my sqlplus console, and all the tables have been created successfully.

- And add the jBPM specific users and roles to $CATALINA_HOME/conf/tomcat-users.xml


  |   <role rolename="manager"/>
  |   <role rolename="admin"/>
  |   <role rolename="participant"/>
  | 
  |   <user username="ernie" password="ernie" roles="participant,manager,administrator"/>
  |   <user username="bert" password="bert" roles="participant"/>
  | 

So now when i launch my tomcat, i have this error :

anonymous wrote : 
  | 15:38:41,921 [JbpmJobExector:216.94.110.165:1] WARN  JDBCExceptionReporter : SQL Error: 923, SQLState: 42000
  | 15:38:41,931 [JbpmJobExector:216.94.110.165:1] ERROR JDBCExceptionReporter : ORA-00923: FROM keyword not found where expected
  | 
  | 15:38:41,931 [JbpmJobExector:216.94.110.165:1] ERROR JobSession : org.hibernate.exception.SQLGrammarException: could not execute query
  | 15:38:41,951 [JbpmJobExector:216.94.110.165:1] ERROR JobExecutorThread : exception in job executor thread. waiting 80000 milliseconds
  | org.jbpm.JbpmException: couldn't get acquirable jobs
  |         at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
  |         at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:111)
  |         at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
  | 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.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:804)
  |         at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
  |         ... 2 more
  | Caused by: java.sql.SQLException: ORA-00923: FROM keyword not found where expected
  | 
  |         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)
  |         ... 11 more
  | 
  | 

As you can the database is empty, so i didn't find some script for populate the database I check all the sql script available but there is nothing =>
http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnOracle

Thks for you reply...
regis

PS: i try to deploy the customized version for tomcat in launching the ant build process :
in jbpm-jpdl-3.2.GA/deploy

  | ant customize.console.for.tomcat	
  | 
but when i deploy i have a severe error (Severe - listener cannot start)

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

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