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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
