[JBoss jBPM] - Tomcat 5.5 - Jbpm 3.2 - Starting failed <<couldn't get acqui
by 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
19Â years
[JBoss jBPM] - About swimlanes
by pedror
Hello.
I am trying to attribute task-nodes to users/groups in my jpdl.
The idea is to have a group (bank/acquirer) which is able to do each task.
The main difficulty is that each virtual group (e.g. bank) is, depending on the current user, bank A or bank B, each with its own set of users.
I was inspired by the source code examples of jBPM, and thought of doing something like:
....
<task-node xxx>
etc..
However, I can't find information on what the swimlane assignment expression can contain, nor can I find relevant information on separating the tasks between the users of bank A and the users of bank B, which belong to the same swimlane.
Any info/opinions/ideas would be greatly appreciated.
TIA
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032526#4032526
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032526
19Â years