idea springboot 报错java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver

最新推荐文章于 2023-11-27 17:12:33 发布
最新推荐文章于 2023-11-27 17:12:33 发布
阅读量1.9k 收藏 1
点赞数 1
分类专栏： java bug
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/manonggui/article/details/88209123
版权 
java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:315) ~[na:1.8.0_191]
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) [mchange-commons-java-0.2.11.jar:0.2.11]

2019-03-05 22:23:33.580  WARN 34488 --- [HelperThread-#1] c.m.v2.resourcepool.BasicResourcePool    : com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2aa255ed -- 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) ~[na:1.8.0_191]
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) [mchange-commons-java-0.2.11.jar:0.2.11]

2019-03-05 22:23:33.580  WARN 34488 --- [HelperThread-#0] c.m.v2.resourcepool.BasicResourcePool    : com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@e7cf1f2 -- 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) ~[na:1.8.0_191]
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) ~[c3p0-0.9.5.2.jar:0.9.5.2]
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) [mchange-commons-java-0.2.11.jar:0.2.11]

原因是在

@Configuration
@MapperScan("com.imooc.demo.dao")//mapper 扫描路径
public class DataSourceConfiguration 开始的扫描类里面插入的url少了个}
@Value("${jdbc.url")//这少了个括号}
private String jdbcurl;
manonggui
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql5.6连接驱动jaf，可处理报错java.sql.SQLException: No suitable driver
02-02
当你遇到"java.sql.SQLException: No suitable driver"这样的错误时，通常意味着你的Java环境无法找到匹配的数据库驱动。这个问题的解决方法是确保已经正确地引入了MySQL JDBC驱动（也称为Connector/J）。 MySQL ...
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:31
qq_41070555的博客
03-23 2743
java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:315) at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:240) ...
java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:3
Mr_GYF的博客
10-31 2021
java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:315) 本人在运行动态web项目时，出现该报错。 在网上搜集原因，整理如下： 1.c3p0-config.xml中的配置文件出现问题,仔细查找配置文件。 2.c3p0配置文件放置地方错误,放在src根目录下（本人出现错误原因） 3.mysql-connector-java-****-bin.jar未导入到环境
java.sql.SQLException: No suitable driver【问题解决】
luckyriver的博客
10-09 301
java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(Unknown Source) at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
关于java.sql.SQLException: No suitable driver问题的解决
张小洛的BOLG
12-01 9592
最近写一个小程序时遇到的问题：我是用c3p0连接池进行数据库连接、myeclipse2014环境中导入的eclipse的项目、在c3p0配置文件（c3p0-config.xml）中配置如下： com.mysql.jdbc.Driver jdbc\:mysql\://172.1.1.1\:3306/ssms root Admin_123 在Tomc
java.sql.SQLException: No suitable driver 的解决办法
热门推荐
qq_42551099的博客
08-17 2万+
java.sql.SQLException: No suitable driver 的解决办法
服务器出现java.sql.SQLException No suitable driver found for 的.pdf
12-05
服务器出现java.sql.SQLException No suitable driver found for 的
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql ...
java.sql.SQLException: 结果集已耗尽
08-02
在Java编程中，`java.sql.SQLException: 结果集已耗尽` 是一个常见的错误提示，通常出现在处理数据库查询结果集时。这个异常表明程序试图访问已经没有数据的结果集中下一行，即所有行已经被遍历完，尝试访问超出范围...
no suitable driver at java.sql.DriverManager
30岁见闻、心得
12-11 1809
出现这样的情况，一般有四种原因：  一：连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX")  [qzhao]:我的配置如下：    com.mysql.jdbc.Driver  jdbc:mysql://10.111.3.244
Exception in thread "main" java.sql.SQLException: No suitable driver
gucapg的专栏
05-30 1万+
spark写入结果集至MySQL时报以下错误信息，记录下，供各位同行快速解决问题 spark dataframe结果数据保存至MySQL时报以下错误信息，而读取时没有问题 错误1：驱动找不到 Exception in thread "main" java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDrive...
java.sql.SQLException: No suitable driver 问题解决
最新发布
Sakurapaid的博客
11-27 3410
这个问题，困扰了我整整一上午
ssh项目中对抛出java.sql.SQLException: No suitable driver异常的处理
04-10 4725
弄了一下午的ssh项目（当然，是初学者，嘿嘿），发现了一个很棘手的问题，那就是在登录这一快总报java.sql.SQLException: No suitable drive异常。不过华了几个小时终于看出了其中的端倪，也是醉了。原来是因为在用myeclipse自动生成spring配置文件applicationContext.xml时，myeclipse没有把driverClassName这个属性给
java.sql.SQLException: No suitable drive解决方法
a2321123的博客
03-08 2787
java.sql.SQLException: No suitable driver at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298) at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223) at com.mchange.v2.c3p0.DriverManagerDataSour...
java.sql.SQLException: No suitable driver问题的解决
ja_II_ck的专栏
05-28 1313
 连接数据库时出现java.sql.SQLException: No suitable driver 仔细检查后发现是因为private String url = "jdbc:mysql://localhost:3306/" + dbName;中有拼写错误的现象，而且最后忘了加‘/’ 
java.sql.SQLException: No suitable driver 的详细解决办法
XURUNFA950827的博客
09-25 2万+
java.sql.SQLException: No suitable driver 的详细解决办法 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run 警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3627613e -- Acquisiti
详解springboot通过spi机制加载mysql驱动过程
johnhuster的专栏
02-21 2930
DataSourceProperties这个类是springboot用来配置数据库的一个基础配置类，该类定义如下： @ConfigurationProperties(prefix = "spring.datasource") public class DataSourceProperties implements BeanClassLoaderAware, InitializingBean {...
java no resultset_jdbc执行多行带@set并用分号隔开的sql语句报错:ResultSet is from UPDATE. No Data....
weixin_33905037的博客
02-16 554
sql语句：`set @original_price=(select group_price from group_data where group_id=4 limit 1);set @favorable_price=(select vip_favorable_price from group_data where group_id=4 and vip_favorable_price_star...
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:mysql:///small?useSSL=false at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:708) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:230) at org.example.Main3.main(Main3.java:20)
07-09
这个异常通常发生在使用Java连接MySQL数据库时，没有找到适合的驱动程序。您需要确保已正确配置MySQL驱动程序，并且驱动程序的位置正确。 解决此问题的一种方法是将MySQL驱动程序添加到您的项目中。您可以从MySQL官方网站下载JDBC驱动程序JAR文件，并将其添加到项目的依赖项中。确保将驱动程序JAR文件放在您的项目的类路径下。一旦驱动程序正确配置，您就可以使用正确的URL连接到MySQL数据库。 这是一个示例代码片段，显示如何加载MySQL驱动程序并连接到数据库： ```java import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/small?useSSL=false"; String username = "your_username"; String password = "your_password"; try { // 加载MySQL驱动程序 Class.forName("com.mysql.jdbc.Driver"); // 建立数据库连接 Connection connection = DriverManager.getConnection(url, username, password); // 进行数据库操作... } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } } ``` 请注意，上述代码中的URL、用户名和密码应根据您的实际设置进行替换。 希望这可以帮助您解决问题！如果您有任何其他问题，请随时提问。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值