I am using java 1.5 on an AS400 with a DB2 database. I use the native JDBC driver (com.ibm.db2.jdbc.app.DB2Driver) to connect to the database. I want to enable the "lazy close" property to improve performance, but when I do this, I get a warning and don’t see that this property has been affected at all. My connection string is: jdbc: db2: B10D8A81 / B3V0530DB2; lazy close = true; This connection string works fine if lazy closure is not enabled. The false private property was accepted: ibm , maybe it is not supported by the native driver?
Warning message I get: 1i1f3d08dmpspwc16lpm31 | 596a596a, idleConnectionTestPeriod → 0, initialPoolSize → 3, jdbcUrl → jdbc: db2: B10D8A81 / B3V0530DB2; lazy close = true .; preferredTestQuery → SELECT 1 FROM RIDUMMY, properties → {user = * , password = *}, property Cycle → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → true, unverturnedConnectionTimeout → 0, useTraditionalReflectiveProxies → false] Jan 4. 2011 18: 32: 53,648 INFO SQLWarnings: 43 - The optional join property is ignored. com.ibm.db2.jdbc.app.DB2JDBCWarning: The additional connection property is ignored. at com.ibm.db2.jdbc.app.DB2Driver.handleURLProcessing (DB2Driver.java:1502) at com.ibm.db2.jdbc.app.DB2Driver.connect (DB2Driver.java:1026) at com.mchange.v2.c3p0 .DriverManagerDataSource.getConnection (DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection (WrapperConnectionPoolDataSource.java:182) atCom.mchange.v2.c3p0ConPoPraPoWraPoPraPoWraPoWraPoPraPoWraPoPraWoPraPoWraPoPraPoWraPoPraWoPraWPoWraPoWnporaPoWnporaPoWnporaPoWenWrapper com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool $ 1PooledConnectionResourcePoolManager.acquireResource (C3P0PooledConnectionPool.java:137) on com.mchange.v2.resourcepool.BasicResourcePool.doAcquire (BasicResourcePool.java:1014) $ 800 com.mchange.v2.resourcepool.BasicResourcePool.access (BasicResourcePool.java:32 ) on com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask.run (BasicResourcePool.java:1810) on com.mchange.v2.async.ThreadPoolAsynchronousRunner $ PoolThread.run (ThreadPoolAsynchronousRunner.java∗47) Jan 04. 2011 18: 32: 53,759 INFO SQLWarnings: 43 - The optional join property is ignored. com.ibm.db2.jdbc.app.DB2JDBCWarning: The additional connection property is ignored. at com.ibm.db2.jdbc.app.DB2Driver.handleURLProcessing (DB2Driver.java:1502) at com.ibm.db2.jdbc.app.DB2Driver.connect (DB2Driver.java:1026) at com.mchange.v2.c3p0 .DriverManagerDataSource.getConnection (DriverManagerDataSource.java:135) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection (WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnPoConnPopperPonnPopperPonnConn .mchange.v2.c3p0.impl.C3P0PooledConnectionPool $ 1PooledConnectionResourcePoolManager.acquireResource (C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcqupool.vores.esourcePool.doAcquire.avaResourcePool.doAcquire.avaResourcePool.doAcquire.avaResourcePool.doAcquire.vore.ool.esourcePool.doAcquire.vore.ResourcePool.doAcquire. .access $ 800 (BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask.run (BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner $ PoolThread.run (ThreadPoolAsynchronousRunner 547) Jan 04 2011 18:32: 53,893 INFO SQLWarnings: 43 - The optional join property is ignored.
.