How to deploy Jbpm 3.1 alpha1 on tomcat using oracle9i/10g?

[zhongboqing]

hello,everyone

I am studying the Jbpm3.1, I want to deploy it on tomcat using oracle9i/10g? I have been tries ,but I failed?Anyone can help me out? Thanks in advance!

[kukeltje]

Please provide us with more info.

What errors do you get? What version of Tomcat..etc...etc..etc..

[zhongboqing]

ok, thank you very much.

I am using oracle10g , tomcat 5.0.28 and j2sdk1.4.2_05, Windows XP.

I download jbpm-starters-kit-3.1-alpha1.zip from the jboss site.


here, How I did it:

step1: under 'jbpm\lib', create 'oracle' directory

step2: copy oracle10 driver (ojdbc14.jar) to 'oracle' directory


step3: under 'jbpm\src\resources', create 'oracle' directory

step4: copy (create.db.hibernate.properties, identity.db.xml) from 'hsqldb' directory to 'oracle' directory

step5: Edit 'create.db.hibernate.properties' file:
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
# for Oracle 8 compatibility use
#hibernate.dialect=org.hibernate.dialect.OracleDialect

hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@172.16.1.18:1521:JBPM
hibernate.connection.username=jbpm
hibernate.connection.password=jbpm

hibernate.show_sql=true
hibernate.c3p0.min_size=1
hibernate.c3p0.max_size=3


step6: under 'jbpm' directory, edit ANT script 'build.deploy.xml' ,and find target name="create.db", delete" db.start, db.stop"

in this block replace 'hsqldb' to 'oracle'

step7: run ANT, ant -buildfile build.deploy.xml create.db, this task is success, the JBPM has 33 tables.

step7: edit ANT script 'build.deploy.xml' as the following:






















----

ant -buildfile build.deploy.xml build.webapp

step8:
copy jbpm.war to "tomcat-5.0.28"/webapps/


step9:
execute "tomcat-5.0.28"/bin/startup

tomcat errors are:

--------
ava.lang.RuntimeException: couldn't fetch the hibernate SessionFactory from jnd
i 'java:/jbpm/SessionFactory'
at org.jbpm.tc.hibernate.HibernateSessionFactoryInterceptor.begin(Hibern
ateSessionFactoryInterceptor.java:37)
at org.jbpm.tc.ContextBuilder.begin(ContextBuilder.java:132)
at org.jbpm.msg.command.CommandExecutor.executeCommand(CommandExecutor.j
ava:62)
at org.jbpm.msg.command.CommandExecutor.run(CommandExecutor.java:34)
java.lang.RuntimeException: couldn't fetch the hibernate SessionFactory from jnd
i 'java:/jbpm/SessionFactory'
at org.jbpm.tc.hibernate.HibernateSessionFactoryInterceptor.begin(Hibern
ateSessionFactoryInterceptor.java:37)
at org.jbpm.tc.ContextBuilder.begin(ContextBuilder.java:132)
at org.jbpm.msg.command.CommandExecutor.executeCommand(CommandExecutor.j
ava:62)
at org.jbpm.msg.command.CommandExecutor.run(CommandExecutor.java:34)
java.lang.RuntimeException: couldn't fetch the hibernate SessionFactory from jnd
i 'java:/jbpm/SessionFactory'
at org.jbpm.tc.hibernate.HibernateSessionFactoryInterceptor.begin(Hibern
ateSessionFactoryInterceptor.java:37)
at org.jbpm.tc.ContextBuilder.begin(ContextBuilder.java:132)
at org.jbpm.msg.command.CommandExecutor.executeCommand(CommandExecutor.j
ava:62)
at org.jbpm.msg.command.CommandExecutor.run(CommandExecutor.java:34)
java.lang.RuntimeException: couldn't fetch the hibernate SessionFactory from jnd
i 'java:/jbpm/SessionFactory'
at org.jbpm.tc.hibernate.HibernateSessionFactoryInterceptor.begin(Hibern
ateSessionFactoryInterceptor.java:37)
at org.jbpm.tc.ContextBuilder.begin(ContextBuilder.java:132)
at org.jbpm.msg.command.CommandExecutor.executeCommand(CommandExecutor.j
ava:62)
at org.jbpm.msg.command.CommandExecutor.run(CommandExecutor.java:34)

---------

[tyg_owen]

Could you understand what I said in Chinese.the following is that the log of Configuration is for
mysql5+tomcat5+jbmp3.1


??????jbpm3.1+mysql5+tomcat5 ?????? jbpm3.02??????????????????????
1. src\resources\mysql ??mysql?? ????mysql?? ?? create.db.hibernate.properties identity.db.xml ????????
?????create.db.hibernate.properties????:

hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost/jbpmdb?useUnicode=true&characterEncoding=GBK
hibernate.connection.username=root
hibernate.connection.password=root
hibernate.show_sql=true

2.?jbpm/lib ?????mysql?????jdbc??????
3.??jbpm/build.deploy.xml ?????????target ????mysql?????????


















?? ant create.db.mysql -buildfile build.deploy.xml ????????? ??

//cd $JBPM_HOME
//ant -f build.deploy.xml create.db.mysql



4.??src\config.files\hibernate.cfg.xml ?? ??????????? ????Hibernate???????

5. ?build.deploy.xml?? build.webapp ????????





















cd $JBPM_HOME
ant build
ant -f build.deploy.xml build.webapp


??????????? [e-mail]