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@c3c315 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@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@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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...