集成C3P0连接池后控制台狂抛com.mchange.v2.c3p0.SQLWarnings错误解决方案

来源:互联网 发布:卷皮7.0源码 编辑:程序博客网 时间:2024/06/05 11:24

      在sqlserver2008集成C3P0连接池时,很多朋友添加网上下载的sqlserver驱动jar包后,会报如下的SQLWarning,原因是因为jar包的原因,网上很多下载下来的都是四个jar文件的,但是如果你都添加上去,C3P0默认会去找低版本支持的jar包,但是sqlserver2008官方驱动jar包其实就一个,微软在sqlserver2008之后就对其进行了优化,并且链接url、驱动名称也做了相应的改动,如果你的运行环境是jdk版本是5或者以上,你只需要添加一个jar包即可,控制台便不会出现如下的SQLWarning信息,jar名称为sqljdbc4.jar,附上驱动名称:com.microsoft.sqlserver.jdbc.SQLServerDriver, JDBC_URL:jdbc:sqlserver://192.168.50.88:1433;DatabaseName=xxxx,方便注册驱动不成的朋友对号入座


 2014-11-27 16:15:33,531 INFO [com.mchange.v2.c3p0.SQLWarnings] - [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to oa11
 java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to oa11
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.get(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getWarnings(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewProxyConnection.java:907)
at com.mchange.v2.c3p0.SQLWarnings.logAndClearWarnings(SQLWarnings.java:42)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:187)
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)
 2014-11-27 16:15:33,531 INFO [com.mchange.v2.c3p0.SQLWarnings] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将数据库上下文改为 'oa11'。
 java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将数据库上下文改为 'oa11'。
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.get(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getWarnings(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewProxyConnection.java:907)
at com.mchange.v2.c3p0.SQLWarnings.logAndClearWarnings(SQLWarnings.java:42)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:187)
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)
2014-11-27 16:15:33,546 INFO [com.mchange.v2.c3p0.SQLWarnings] - [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to 简体中文
 java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to 简体中文
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.get(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getWarnings(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewProxyConnection.java:907)
at com.mchange.v2.c3p0.SQLWarnings.logAndClearWarnings(SQLWarnings.java:42)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:187)
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)

0 0
原创粉丝点击