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... [EMAIL PROTECTED] [
connectionPoolDataSource -> [EMAIL PROTECTED] [ 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 -> [EMAIL
PROTECTED] [ description -> null, driverClass -> null, factoryClassLocation ->
null, jdbcUrl -> jdbc:hsqldb:mem:.;sql.enforce_strict_size=true, properties ->
{user=******, password=******} ] , preferredTestQuery -> null, propertyCycle ->
300, tes!
tConnectionOnCheckin -> 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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
