-
1. Re: Is there anyone success build JBPM3.0 with Oracle as DB
tom.baeyens Sep 12, 2005 4:46 PM (in response to johnson6768)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
johnson6768 Sep 12, 2005 7:01 PM (in response to johnson6768)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 Sep 13, 2005 3:35 AM (in response to johnson6768)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
cheath Oct 31, 2005 1:02 PM (in response to johnson6768)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
kukeltje Oct 31, 2005 2:19 PM (in response to johnson6768)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
cheath Oct 31, 2005 5:12 PM (in response to johnson6768)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
kukeltje Oct 31, 2005 7:13 PM (in response to johnson6768)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.