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

[warfster]

After following the docs, I can generate the scripts for oracle10g, and the scripts run fine in oracle.

Currently, ant oracle.test achieves 98%, w/only 4 errors. 

My question is as why does it  the test keep running the SchemaExport, etc. on hsqldb? Here are to snippets of the output indicating loading the oracle information from hibernate.properties and then using C3P0 using the hsqldb driver?

 
    [junit] 14:40:34,723 [main] DEBUG JbpmContext : creating JbpmContext
    [junit] 14:40:34,723 [main] DEBUG DbPersistenceServiceFactory : creating schema export
    [junit] 14:40:34,763 [main] INFO  Environment : Hibernate 3.1
    [junit] 14:40:34,763 [main] INFO  Environment : loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.c3p0.max_size=5, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.c3p0.min_size=1, hibernate.query.substitutions=true 1, false 0, hibernate.connection.username=jbpmtest, hibernate.connection.url=jdbc:oracle:thin:@//127.0.0.1:1521/XE, hibernate.show_sql=true, hibernate.connection.password=****}
    [junit] 14:40:34,763 [main] INFO  Environment : using CGLIB reflection optimizer
    [junit] 14:40:34,773 [main] INFO  Environment : using JDK 1.4 java.sql.Timestamp handling
    [junit] 14:40:34,823 [main] DEBUG HibernateHelper : creating hibernate configuration resource 'hibernate.cfg.xml'
 .
 .
 .
    [junit] 14:40:38,048 [main] INFO  Configuration : processing foreign key constraints
    [junit] 14:40:38,078 [main] INFO  SchemaExport : Running hbm2ddl schema export
    [junit] 14:40:38,078 [main] INFO  SchemaExport : exporting generated schema to database
   [junit] 14:40:38,078 [main] INFO  C3P0ConnectionProvider : C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:mem:.;sql.enforce_strict_size=true
    [junit] 14:40:38,078 [main] INFO  C3P0ConnectionProvider : Connection properties: {user=sa, password=****}
    [junit] 14:40:38,078 [main] INFO  C3P0ConnectionProvider : autocommit mode: false
    [junit] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource at c3c315 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource at 1d88db7 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource at 1202d69 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:hsqldb:mem:.;sql.enforce_strict_size=true, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> c3c315 ] 
    [junit] alter table JBPM_ACTION drop constraint FK_ACTION_EVENT
    [junit] alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL
 

Any suggestion or pointers would be greatly appreciated.

I noticed in kazam's post the C3P0 connection used the oracle driver. Any thoughts?

Thanks,

warfster 



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

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