【求助】C3P0使用时，报java.sql.SQLWarning: Database selected错误

[一叶知秋118]

java.sql.SQLWarning: Database has transactions
at java.lang.Throwable.<init>(Throwable.java:67)
at java.sql.SQLException.<init>(SQLException.java:101)
at java.sql.SQLException.<init>(SQLException.java:85)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2269)
at com.informix.jdbc.IfxSqliConnect.t(IfxSqliConnect.java:4536)
at com.informix.jdbc.IfxSqliConnect.b(IfxSqliConnect.java:3094)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2967)
at com.informix.jdbc.IfxSqli.c(IfxSqli.java:2839)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:2030)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1621)
at sun.reflect.GeneratedConstructorAccessor2.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:229)
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)
<2013-01-06 09:57:54,853> Database selected
java.sql.SQLWarning: Database selected
at java.lang.Throwable.<init>(Throwable.java:67)
at java.sql.SQLException.<init>(SQLException.java:101)
at java.sql.SQLException.<init>(SQLException.java:85)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2269)
at com.informix.jdbc.IfxSqliConnect.t(IfxSqliConnect.java:4542)
at com.informix.jdbc.IfxSqliConnect.b(IfxSqliConnect.java:3094)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2967)
at com.informix.jdbc.IfxSqli.c(IfxSqli.java:2839)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:2030)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1621)
at sun.reflect.GeneratedConstructorAccessor2.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:229)
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)

这个是什么问题能求助各位大大

[Lyle_W]

想问楼主，这个问题最后解决了么？ 我今天也碰上这个问题了，只有在C3P0和Informix共用时才有，Log是Info级别，算不上Error Google一下，貌似普遍认为不是什么大问题 之前用的2007年的C3P0，启动服务的时候就报错，每次执行sql也报错 换了上周刚出的C3P0 0.9.2，启动server不报错，第一次执行sql报错，然后再后面也不报错了 Sigh⋯⋯资料太少，有人说改Log配置，让这个Log不出来就ok了

[dsm1205]

你好，能详细说说怎么优化连接池的配置吗？我的错误和你一样，报错可能是因为设置了空闲连接，然后又被收回吧，我的配置如下： <property name="c3p0.min_size">50</property> <property name="c3p0.max_size">300</property> <property name="c3p0.max_statements">50</property> <property name="c3p0.idle_test_period">120</property> <property name="c3p0.acquire_increment">10</property> <property name="c3p0.timeout">500</property> <property name="c3p0.maxIdleTime">60</property> <property name="c3p0.checkoutTimeout">300</property> <property name="hibernate.show_sql">false</property> <property name="jdbc.fetch_size">50</property> <property name="jdbc.batch_size">25</property> 我调试时将min_size和max_size分别设置为2和10，在初始化两个连接不够用增加后，空闲时可以自动释放，如果连接数等于最小连接数时，每个连接间隔一会会变化，说明不是保证最少连接数不变，但是每次变化时，后台就保警告信息！

[一叶知秋118]

已经解决了，问题在于配置，还有就是检查代码，别忘记关闭连接 我的程序框架比较老，不是用开源的框架，连接的获取、释放都要自己代码里写明 还有一个就是连接池的配置，优化最大空闲时间，让程序能及时回收连接

[fanfan0815]

楼主，怎么解决的。。。 偶也遇到这样的问题。。。springMVC框架连接informix数据库，进行操作，启动服务是出现这样的问题。。。 不知道怎么解决啊？

[lgb860316]

分享下怎么解决的呀倒是

[廊子]

这种楼主最装B了。。。

[乱石阵雨]

这个问题还没人知道怎么解决么？

[我爱逗她]

我也遇到这个问题，求解！