[jboss-user] [JBoss jBPM] - Oracle 10G and JBPM 3.1.1 Issues

[kazam]

Hi 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 at 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 at 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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3957599#3957599

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3957599