Oracle 10G and JBPM 3.1.1 Issues
kazam Jul 12, 2006 10:02 PMHi there,
Following the documentation, I generate the scripts for oracle and they execute nicely both oracle.create.sql and oracle.drop.sql.
However, the tests are failing.
Library : classes12.jar from Oracle10g database.
Hibernate Dialect: Oracle9Dialect
I have made the following change as mentioned in the jbpm-starters-kit-3.1.1/jbpm-db/readme.html
modify jbpm.3/src/resources/hibernate.cfg.xml: add line <property name="hibernate.query.substitutions">true 1, false 0</property>
However, the testresults have a success rate of 1.5% with no failures but 262 errors out of 266 tests.
Below I am providing some part of the output of the ant oracle.test target.
Where can I post or upload the entire ant target log file.
[junit] 19:38:42,625 [main] INFO C3P0ConnectionProvider : C3P0 using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin@192.168.0.110:1521:devdb [junit] 19:38:42,625 [main] INFO C3P0ConnectionProvider : Connection properties: {user=jbpmtest, password=****} [junit] 19:38:43,093 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/exe/ProcessInstance.hbm.xml [junit] 19:38:43,093 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.ProcessInstance -> JBPM_PROCESSINSTANCE [junit] 19:38:43,109 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/exe/Token.hbm.xml ................... ................... (continues ...) [junit] 19:38:43,734 [main] INFO Configuration : processing association property references [junit] 19:38:43,734 [main] INFO Configuration : processing foreign key constraints [junit] 19:38:43,750 [main] INFO Configuration : processing extends queue [junit] 19:38:43,750 [main] INFO Configuration : processing collection mappings [junit] 19:38:43,750 [main] INFO Configuration : processing association property references [junit] 19:38:43,750 [main] INFO Configuration : processing foreign key constraints [junit] 19:38:43,750 [main] INFO SchemaExport : Running hbm2ddl schema export [junit] 19:38:43,765 [main] INFO SchemaExport : exporting generated schema to database [junit] 19:38:43,765 [main] INFO C3P0ConnectionProvider : C3P0 using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin@192.168.0.110:1521:devdb [junit] 19:38:43,765 [main] INFO C3P0ConnectionProvider : Connection properties: {user=jbpmtest, password=****} [junit] 19:38:43,765 [main] INFO C3P0ConnectionProvider : autocommit mode: false [junit] 19:38:43,765 [main] DEBUG JbpmContext : closing JbpmContext [junit] Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 0.062 sec [junit] TEST org.jbpm.context.exe.CustomVariableStringIdDbTest FAILED
I would really appreciate if someone who has successfully done this can help me out.
Thanks,Kazam.