java.sql.SQLException: No suitable driver found

最新推荐文章于 2024-03-13 23:30:00 发布
最新推荐文章于 2024-03-13 23:30:00 发布
阅读量391 收藏
点赞数
分类专栏： Bug处理专栏
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/nishiwodebocai21/article/details/103007974
版权

报错信息

警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@23572610 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:315)
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
	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)

十一月 11, 2019 11:56:44 上午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5312e9c8 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:315)
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
	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)

十一月 11, 2019 11:56:44 上午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1581a59f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:315)
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
	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)

java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:156)
	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:303)
	at com.daohewang.dao.impl.StudentDaoImpl.findAll(StudentDaoImpl.java:25)
	at com.daohewang.service.impl.StudentServiceImpl.findAll(StudentServiceImpl.java:20)
	at com.daohewang.servlet.ServletStudentList.doGet(ServletStudentList.java:33)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 27 more
java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:156)
	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:303)
	at com.daohewang.dao.impl.StudentDaoImpl.findAll(StudentDaoImpl.java:25)
	at com.daohewang.service.impl.StudentServiceImpl.findAll(StudentServiceImpl.java:20)
	at com.daohewang.servlet.ServletStudentList.doGet(ServletStudentList.java:33)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 27 more

解决方案

这个异常可能有两个原因造成

  1. JDBC的驱动根本就没有加载出来
  2. URL和加载的JDBC驱动不匹配

由于驱动程序看起来是加载的(尽管以一种不正确的方式)，但是你的URL却写错了。确保url变量的值与以下格式匹配

jdbc:mysql://localhost/数据库名

如果用的C3p0处理连接的话, 一定要将 c3p0-config.xml 配置文件放在 src目录底下, 并且名字不能写错 c3p0-config.xml, 否则会找不到配置文件

可以看看这个

spark连接mysql报错 java.sql.SQLException: No suitable driver
yy的博客
03-26 3957
报错内容 spark读取mysql数据到df报错: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:315) at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions$$anonfun$6.apply(JDBCOptions.scala:105) at org.apache.s
连接数据库出错：java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/
热门推荐
菜鸟的后花园
06-28 12万+
连接数据库出错 java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/ 今天在做Java web项目，在进行数据库连接的时候运行后报错如下： java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3...
数据库连接时一个异常的处理：java.sql.SQLException: No suitable driver found for
wangts的专栏
09-11 2万+
java.sql.SQLException: No suitable driver found for这个异常的发生，原因有二：一，在可寻的路径下没有合适的数据库驱动。二，数据库连接时提供的url不正确。 通常，一的情况不常发生，因为我们连接数据库不会不安装驱动，而且驱动的路径也基本不是问题。多数是数据库连接的url不正确。而这种情况最常发生在从配置文件里读取url、用户名、密
java.sql.SQLException: No suitable driver
weixin_34293911的博客
02-17 155
java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(Unknown Source) at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:144) at com.mch...
关于java.sql.SQLException: No suitable driver错误
felore的专栏
06-17 8095
在连数据库中,如果数据驱动程序也都存在，并且也都放在了classpath中，请检查数据库联接URL是否正确，若数据库连接字符串不正确也会导致此错误的发生
Datax报错java.sql.SQLException: No suitable driver found for
weixin_36693442的博客
08-09 4341
Datax 踩坑记
服务器出现java.sql.SQLException No suitable driver found for 的.pdf
12-05
### 服务器出现java.sql.SQLException No suitable driver found for 的解析与解决方案 #### 问题背景 在进行Servlet开发过程中，尤其是在尝试连接数据库时，遇到了一个常见的异常：“java.sql.SQLException: No ...
idea连接mysql数据库（报错java.sql.SQLException: No suitable driver found for jdbc）
YueQiong的博客
02-03 2670
不是maven版 1.把你电脑安装的数据库对应的jar包复制粘贴到项目名那里。 2.右击，add as library,确定 3.新建class，代码如下 import java.sql.*; public class jdbcdeno1 { public static void main(String[] args){ //DriverManager数据库链接 // try(Connection connection= DriverManager.getConnect
【Java Web问题解决】Tomcat报错：java.sql.SQLException: No suitable driver found for jdbc:mysql://***
菜鸟的后花园
09-26 2899
Tomcat报错：java.sql.SQLException: No suitable driver found for jdbc:mysql://*** 出现java.sql.SQLException: No suitable driver found for jdbc:mysql://*** 一般是数据库连接部分的程序出错了 比如我今天遇到的Tomcat报错为： java.sql.SQLExc...
kylin使用出现的坑(三)——java.sql.SQLException：No suitable driver found for jdbc:mysql://localhost:3306/hive?
夏天小厨的博客
01-03 3075
异常信息描述： kylin的cube在build时，#2 Step Name: Extract Fact Table Distinct Columns出现java.sql.SQLException的错误。如下所示： java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/hive？creat...
服务器出现java.sql.SQLException No suitable driver found for 的问题，Test可正常运行，servlet无法启动
爱学习的大雄的博客
11-25 2126
问题发现 我在创建这个Servlet连接数据库时出现了几个问题（我开始搞不明白，因为在Test测试中的时候是可以正常运行的），后来查阅了许多资料，发现了可能是因为以下问题所导致：（解决我的问题的是4种方法+第二种方法） 连接数据库语法错误 可能mysql的jar包没有导入 jdk的版本和数据库驱动版本不匹配 没有配置数据库驱动器 问题解决 1.连接数据库语法错误,检查url、name、或pwd是否错误 String url="jdbc:mysql://localhost:3306/lzj?serverT
java.sql.sqlexception no suitable driver fo_出现java.sql.SQLException: No suitable driver的几种解决办法...
weixin_35708531的博客
02-28 539
今天在用C3p0连接MySql数据库 这个时候出现了上面的错误，一般来说这种错误有3个方向解决 一般都是db的配置的问题 ，一定要小心DB 的配置八月 19, 2017 8:30:46 下午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run警告: com.mchange.v2.resourcepool.BasicResour...
解决 Java 错误 Java.Sql.SQLException: No Suitable Driver
最新发布
迹忆客
03-13 8637
本篇文章介绍了 Java 中的错误。
DBCP连接池配置参数说明
..7a.
05-14 6万+
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值