[jboss-user] [JBoss jBPM] - Re: Oracle 10G and JBPM 3.1.1 Issues
warfster
do-not-reply at jboss.com
Fri Jan 12 08:54:46 EST 2007
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
More information about the jboss-user
mailing list