7 Replies Latest reply on Oct 31, 2005 7:13 PM by Ronald van Kuijk

    Is there anyone success build JBPM3.0 with Oracle as DB ??

    Johsnon K Newbie

      Hi, All:
      I have seen through most documents about how to build JBPM 3 with Oracle as Database, but it seems no single one describe more clear and give step by step procedures in HOW TO BUILD.
      Can anyone post the BASIC procedures about how to build JBPM 3 with Oracle ?
      Thanks in advance!

        • 1. Re: Is there anyone success build JBPM3.0 with Oracle as DB
          Tom Baeyens Master

          you shouldn't build jbpm for oracle. but configure jbpm to use oracle. please check the jbpm.db project on how to create the database schema for oracle. (note that there is a known limitation in oracle script generation. we're working on it). i don't know yet which versions are affected and which work proper...

          regards, tom.

          • 2. Re: Is there anyone success build JBPM3.0 with Oracle as DB
            Johsnon K Newbie

            Thanks, tom, All what I want to do is just to build JBPM3 server and store all the data on Oracle. and I have read jbpm.db documents, and when I try to generate Oracle sql script ( using command, ant oracle.scripts ), it's work, and generate some sql scripts, BUT these scripts seems have not tested pass YET. Is that RIGHT ? (if it is right, pls let me knwo, and I'll not try continue until the next right version)

            • 3. Re: Is there anyone success build JBPM3.0 with Oracle as DB
              Tom Baeyens Master

              you can try the current version as well. just verify that the generated script is for and not for hsqldb. if your oracle can't read the ddl script, then you're experiencing the problem that is recently reported. in that case you could wait till next release.

              regards, tom.

              • 4. Re: Is there anyone success build JBPM3.0 with Oracle as DB
                Corey Heath Newbie

                So is there any workaround for the oracle script generation issue yet? Or am I prevented from using oracle for the time being?

                • 5. Re: Is there anyone success build JBPM3.0 with Oracle as DB
                  Ronald van Kuijk Master

                  Try using the head version from cvs. Many people use it on oracle. Do you get an error somewhere?

                  • 6. Re: Is there anyone success build JBPM3.0 with Oracle as DB
                    Corey Heath Newbie

                    No errors, scripts looked like they generated fine, but the syntax was all wrong for oracle.

                    Since I am just trying to test, was going to move forward for time being using hsqldb. But I can't run the tests in the jbpm.db module.

                    running ant hsqldb.test I get the following exception:

                    [junit] 15:03:17,102 FATAL DatasourceConnectionProvider : Could not find dat
                    asource: java:/DefaultDS
                     [junit] javax.naming.NoInitialContextException: Need to specify class name i
                    n environment or system property, or as an applet parameter, or in an applicatio
                    n resource file: java.naming.factory.initial
                     [junit] at javax.naming.spi.NamingManager.getInitialContext(NamingManage
                    r.java:640)
                     [junit] at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.
                    java:243)
                     [junit] at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialCon
                    text.java:280)
                     [junit] at javax.naming.InitialContext.lookup(InitialContext.java:347)
                     [junit] at org.hibernate.connection.DatasourceConnectionProvider.configu
                    re(DatasourceConnectionProvider.java:44)
                     [junit] at org.hibernate.connection.ConnectionProviderFactory.newConnect
                    ionProvider(ConnectionProviderFactory.java:80)
                     [junit] at org.jbpm.db.JbpmSchema.createConnection(JbpmSchema.java:258)
                     [junit] at org.jbpm.db.JbpmSchema.execute(JbpmSchema.java:223)
                     [junit] at org.jbpm.db.JbpmSchema.createSchema(JbpmSchema.java:149)
                     [junit] at org.jbpm.db.AbstractDbTestCase.getJbpmSessionFactory(Abstract
                    DbTestCase.java:28)
                     [junit] at org.jbpm.db.AbstractDbTestCase.beginSessionTransaction(Abstra
                    ctDbTestCase.java:81)
                     [junit] at org.jbpm.db.AbstractDbTestCase.setUp(AbstractDbTestCase.java:
                    71)
                     [junit] at junit.framework.TestCase.runBare(TestCase.java:125)
                     [junit] at junit.framework.TestResult$1.protect(TestResult.java:106)
                     [junit] at junit.framework.TestResult.runProtected(TestResult.java:124)
                     [junit] at junit.framework.TestResult.run(TestResult.java:109)
                     [junit] at junit.framework.TestCase.run(TestCase.java:118)
                     [junit] at junit.framework.TestSuite.runTest(TestSuite.java:208)
                     [junit] at junit.framework.TestSuite.run(TestSuite.java:203)
                     [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.
                    run(JUnitTestRunner.java:297)
                     [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.
                    launch(JUnitTestRunner.java:672)
                     [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.
                    main(JUnitTestRunner.java:567)


                    I try to run the test in eclipse so i could debug better, but then I get:
                    java.sql.SQLException: Connection is broken: Transfer corrupted
                     at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
                     at org.hsqldb.jdbc.jdbcConnection.getAutoCommit(Unknown Source)
                     at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112)
                     at org.jbpm.db.JbpmSchema.createConnection(JbpmSchema.java:264)
                     at org.jbpm.db.JbpmSchema.execute(JbpmSchema.java:228)
                     at org.jbpm.db.JbpmSchema.createSchema(JbpmSchema.java:154)
                     at org.jbpm.db.AbstractDbTestCase.getJbpmSessionFactory(AbstractDbTestCase.java:28)
                     at org.jbpm.db.AbstractDbTestCase.beginSessionTransaction(AbstractDbTestCase.java:81)
                     at org.jbpm.db.AbstractDbTestCase.setUp(AbstractDbTestCase.java:71)
                     at junit.framework.TestCase.runBare(TestCase.java:125)
                     at junit.framework.TestResult$1.protect(TestResult.java:106)
                     at junit.framework.TestResult.runProtected(TestResult.java:124)
                     at junit.framework.TestResult.run(TestResult.java:109)
                     at junit.framework.TestCase.run(TestCase.java:118)
                     at junit.framework.TestSuite.runTest(TestSuite.java:208)
                     at junit.framework.TestSuite.run(TestSuite.java:203)
                     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421)
                     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
                     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)


                    my db appears to be running, so I am not sure yet what the issue is.

                    • 7. Re: Is there anyone success build JBPM3.0 with Oracle as DB
                      Ronald van Kuijk Master

                      you can't use the jndi based config of hibernate when not running on an appserver.

                      The second error pops up on the forum ocasionally but never with a solution. It sometimes is db related, sometimes network etc.