using c3p0 connection Informix7.2 --------------------------------- Key: HHH-3658 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3658 Project: Hibernate Core Issue Type: Bug Environment: Informix7.2, jdk1.5, Informix Dialect Version 2.21JC5, Hibernate3.3 ,c3p0-0.9.12 Reporter: jean jj Hi I am using Hibernate 3 with JDK1.5 and Informix 7.2 and driver version 2.21JC5 and c3p0-0.9.12 INFO - Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider INFO - C3P0 using driver: com.informix.jdbc.IfxDriver at URL: jdbc:informix-sqli://xxxxxx:xxxx/xx:INFORMIXSERVER=xxx INFO - Connection properties: {user=isuadmus, password=****} INFO - autocommit mode: false INFO - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@df452eda [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@2cdc0f6d [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hd3ogc7yh0nhwh9oik8b|871e65, idleConnectionTestPeriod -> 0, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@e45de01f [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hd3ogc7yh0nhwh9oik8b|ae1393, jdbcUrl -> jdbc:informix-sqli://140.127.191.1:8347/isuadmin:INFORMIXSERVER=sol8_tcp, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hd3ogc7yh0nhwh9oik8b|dcb6b4, numHelperThreads -> 3 ] INFO - Database has transactions INFO - Database has transactions java.sql.SQLWarning: Database has transactions at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125) at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149) at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817) at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3935) at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591) at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465) at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496) at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.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.java:547) INFO - Database selected java.sql.SQLWarning: Database selected at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125) at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149) at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817) at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3941) at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591) at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465) at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496) at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.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.java:547) INFO - Database server running in secondary mode. java.sql.SQLWarning: Database server running in secondary mode. at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125) at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149) at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817) at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3951) at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591) at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465) at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496) at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.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.java:547) INFO - Database has transactions java.sql.SQLWarning: Database has transactions at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125) at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149) at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817) at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3935) at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591) at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465) at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496) at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.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.java:547) hibernate.cfg.xml <hibernate-configuration> <session-factory> <property name="dialect"> org.hibernate.dialect.InformixDialect </property> <property name="connection.driver_class"> com.informix.jdbc.IfxDriver </property> <property name="connection.url"> jdbc:informix-sqli://xxxx:xxxx/xxxx:INFORMIXSERVER=xxxx </property> <property name="connection.username">xxxx</property> <property name="connection.password">xxxx</property> <property name="show_sql">true</property> <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> <property name="hibernate.c3p0.min_size">5</property> <property name="hibernate.c3p0.max_size">20</property> <property name="hibernate.c3p0.acquire_increment">0</property> <property name="hibernate.c3p0.timeout">300</property> <property name="hibernate.c3p0.max_statements">0</property> <property name="hibernate.c3p0.idle_test_period">100</property> <mapping resource="xxxx.hbm.xml" /> </session-factory> </hibernate-configuration>