[hibernate-issues] [Hibernate-JIRA] Deleted: (HHH-3658) using c3p0 connection Informix7.2
Gail Badner (JIRA)
noreply at atlassian.com
Tue Dec 16 17:15:38 EST 2008
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gail Badner deleted HHH-3658:
-----------------------------
> 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 at df452eda [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource at 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 at 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>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list