异常错误-Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver异常

最新推荐文章于 2024-08-22 18:23:05 发布
最新推荐文章于 2024-08-22 18:23:05 发布
阅读量5.8k 收藏
点赞数
分类专栏： 异常错误
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_19331985/article/details/103719430
版权

条件

数据库：sqlserver2017；

IDE：IDEA2017；

连接池：c3p0；

现象：

在启动tomcat时顺利进入启动页面，当开始进行登录或者有需要通过jdbc操作数据库时将报如下异常，并循环出现（说明页面请求不断的向jdbc发送但是就是找不到对应的入口）。

26-Dec-2019 17:21:30.868 [http-nio-8080-exec-10] com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge9i0a7i6d4k21j2g57r|2875ba57, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.microsoft.sqlserver.jdbc.SQLServerDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge9i0a7i6d4k21j2g57r|2875ba57, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:sqlserver://localhost:1433; DatabaseName=ProspectHillMES1.0, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
26-Dec-2019 17:21:30.870 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver
	java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365)
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188)
		at java.lang.Class.forName0(Native Method)
		at java.lang.Class.forName(Class.java:264)
		at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
		at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
		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)
26-Dec-2019 17:21:30.872  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver
	java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365)
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188)
		at java.lang.Class.forName0(Native Method)
		at java.lang.Class.forName(Class.java:264)
		at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
		at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
		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)
26-Dec-2019 17:21:30.871 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver
	java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365)
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188)
		at java.lang.Class.forName0(Native Method)
		at java.lang.Class.forName(Class.java:264)
		at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
		at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
		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)
26-Dec-2019 17:21:31.876 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver
	java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365)
		at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188)
		at java.lang.Class.forName0(Native Method)
		at java.lang.Class.forName(Class.java:264)
		at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
		at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
		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)

分析：

刚刚开始也不知道什么原因，通过异常的字面意思明白就是链接到数据库出现问题，这个现象其实也是非常常见的。

1.排查自己的jdbc配置看是否出现问题

<bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver">            
        </property>
        <property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433;DatabaseName=TEST"></property>
        <property name="user" value="test"></property>
        <property name="password" value="test"></property>
</bean>

2.在网上查询到说是“dbconfig.properties”文件中的空格导致，这对这个回答自己将文件中的内容重新审核一遍没有发现，并且将格式替换成 “步骤1”中的格式进行测试

jdbc.jdbcUrl=jdbc\:sqlserver\://127.0.0.1\:1433;DatabaseName\=TEST
jdbc.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.user=test
jdbc.password=test

3.后续又想到是不是版本的问题，因为之前的项目是sqlserver2012，现在替换成为2017，可能JDBC驱动有升级于是将“pom.xml”文件的中jdbc驱动注释掉，重新从官网下载了一个全新的驱动，直接放置在web项目的"WEB-INF/lib"目录下通过“Project Structure/libraries”添加到lib库中，重新运行项目，成功进行数据库数据操作。

 

关于sqlserver2017jdbc驱动的更新方式可以参考该链接地址的博客：

https://blog.csdn.net/yogima/article/details/80614575

 

Eggsy.Li
关注
专栏目录
连接本地sqlServer数据库时报错 java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
weixin_43867046的博客
12-08 329
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver 连接本地sqlServer数据库时报错 解决方法： 在pom.xml文件里添加驱动jar <dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>sqljdbc4</art
java: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
陶匠一路跑
10-12 6723
驱动程序已拷贝到类路径目录下，还出现找不到指定类,后来将“jakarta-tomcat-5.0.28”换为“jboss-4.0.2”即可org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.d
Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
05-27
NULL 博文链接：https://corrinejtt.iteye.com/blog/608248
解决com.microsoft.sqlserver.jdbc.SQLServerException: 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。
最新发布
zhujun300的博客
08-22 568
打开文件后，修改jdk.tls.disabledAlgorithms这一项，去掉TLSv1, 和 3DES_EDE_CBC,字符。然后重新启动项目，调用数据库执行SQL就没问题了。文件：/lib/jvm/jdk-1.8-oracle-x64/jre/lib/security/java.security。在Java的安装目录的\jre\lib\security下，打开并编辑java.security文件。删除：TLSv1, 3DES_EDE_CBC,
关于Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver‘报错解决
weixin_44336299的博客
08-06 3557
Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’ 因为时间问题，没有给大家截图此错误 直接说解决办法： 注意：你本地没有引进sqljdbc.jar导致 可以放到项目源路径的lib路径下，然后刷新项目F5，从新打包运行即可 关注小刘不迷路~~~ ...
sqljdbc.jar包,java链接sqlServer数据库驱动jar包
11-22
String url = "jdbc:sqlserver://localhost:1433;databaseName=myDatabase"; String username = "myUsername"; String password = "myPassword"; try { Connection conn = DriverManager.getConnection(url, ...
ODI代理找不到驱动
03-08
oracle.odi.core.exception.OdiRuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.microsoft.jdbc.sqlserver.SQLServerDriver] at oracle.odi.core.datasource....
com.microsoft.sqlserver.jdbc.SQLServerDriver
12-04
针对驱动com.microsoft.sqlserver.jdbc.SQLServerDriver所需的三个jar包。
Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver
DreamingJ的博客
10-17 1331
将sqljdbc4.jar放到tomcat 的lib下
Could not load JDBC driver class [com.microsoft.sqlserver.jdbc.SQLServerDriv
456
03-21 1574
  Spring的JDBCTemplate，产生了Exception in thread "main" org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedExce...
Sqoop:Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
weixin_34237596的博客
10-24 231
Sqoop version：1.4.6-cdh Hadoop version:2.6.0-cdh5.8.2 场景：使用Sqoop从MSSqlserver导数据 虽然1.4.6的官网说 Even if Sqoop supports a database internally, you may still need to install the database vendor’s JDBC...
DBeaver连接sqlserver报错“Reason: can‘t load driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver‘”
weixin_42061824的博客
02-10 3228
can't load driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
热门推荐
autofei的专栏
04-11 1万+
SQL Server 2000 JDBC driver使用："com.microsoft.jdbc.sqlserver.SQLServerDriver"SQL Server 2005 and 2008 JDBC drive使用："com.microsoft.sqlserver.jdbc.SQLServerDriver"而且URL prefix也从"jdbc:microsoft:sqlser
jmeter报错：Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
weixin_30881367的博客
09-16 2500
如图，我用的jmeter5.1，报错的请求是一条sql语句，需要查询db： 原因：没有放置驱动包到lib下，可以下载sqljdbc4.jar；放到C:\tools\apache-jmeter-5.1\lib下，重启jmeter。 可在官网下载：https://www.microsoft.com/zh-cn/download/details.aspx?id=54670 注...
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver 报红
05-31
如果你在使用 `driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver` 时出现报红的情况，可以尝试在 pom.xml 中添加 Microsoft JDBC 驱动程序依赖项，如下所示： ```xml <groupId>...
评论 5
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值