3 Replies Latest reply on Apr 4, 2006 12:08 AM by owen tyg

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

    zhongboqing Newbie

      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!

        • 1. Re: How to deploy Jbpm 3.1 alpha1 on  tomcat using oracle9i/
          Ronald van Kuijk Master

          Please provide us with more info.

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

          • 2. Re: How to deploy Jbpm 3.1 alpha1 on  tomcat using oracle9i/
            zhongboqing Newbie

            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)

            ---------

            • 3. Re: How to deploy Jbpm 3.1 alpha1 on  tomcat using oracle9i/
              owen tyg Newbie

              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


              ??????????? tyg_owen@hotmail.com