11 Replies Latest reply on Jul 31, 2007 8:08 AM by David Roberts

    Tomcat 5.5 - Jbpm 3.2 - Starting failed <<couldn't get acqui

    hipchic Newbie

      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 :


      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)