集成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,方便注册驱动不成的朋友对号入座
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
- 集成C3P0连接池后控制台狂抛com.mchange.v2.c3p0.SQLWarnings错误解决方案
- spring c3p0连接池配置 com.mchange.v2.c3p0.combopooleddatasource
- 连接池配置(com.mchange.v2.c3p0.ComboPooledDataSource)
- com.mchange.v2.c3p0.ComboPooledDataSource
- com.mchange.v2.c3p0.ComboPooledDataSource
- spring 连接池配置C3P0的详细配置说明(com.mchange.v2.c3p0.ComboPooledDataSource)
- ssh 中使用c3p0 的连接池配置出错 Invalid property 'xxx' of bean class [com.mchange.v2.c3p0.ComboPoo
- Hibernate连接池问题java.lang.NoClassDefFoundError: com/mchange/v2/c3p0/DataSources
- com.mchange.v2.c3p0.ComboPooledDataSource参数详细
- WARN [com.mchange.v2.c3p0.management.ActiveManagementCoordinator]
- 找不到com.mchange.v2.c3p0.ComboPooledDataSource
- com.mchange.v2.c3p0.ComboPooledDataSource参数详细
- c3p0学习之工厂类 com.mchange.v2.c3p0.DataSources
- INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource
- Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource
- Hibernate连接池三种配置实例 以及解决C3P0错误:com.mchange.v2.c3p0.stmt.GooGooStatementCache - Problem with checked-in Statement, discarding.
- 关于在使用c3p0 连接池配置数据库连接时出现 com.mchange.v2.resourcepool.CannotAcquireResourceExceptiond问题的解答
- 【c3p0】报错:Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement...
- 通过OnTouchEvent(Motionevent event)判断手指滑动方向
- jedis分布式之 ShardedJedisPool (一致性Hash分片算法)
- matlab左除与右除的区别
- MyBatis 3 自动生成 主键 针对不同的数据库(oracle/sqlserver/mysql)
- 批处理删除文件/复制文件
- 集成C3P0连接池后控制台狂抛com.mchange.v2.c3p0.SQLWarnings错误解决方案
- UBIFS文件系统分析六之wear-leveling
- android自定义控件(一)
- 用 python绘图及网络分析(win64下matplotlib,networkx安装方法)
- DiskFileItemFactory类
- python 绑定进程在某个cpu上执行 affinity
- 趣味编程,有谁研究过这方面吗?
- Linux内核发布模式与开发组织模式(1)
- 1008. 数组元素循环右移问题