mybatis或hibernate框架连接数据库报错:java.sql.SQLException: No suitable driver或No suitable driver found for http://maven.apache.org

报错:

java.sql.SQLException: No suitable driver或No suitable driver found for http://maven.apache.org 

 

报错详情:

 

十二月 09, 2020 5:30:32 下午 com.mchange.v2.resourcepool.BasicResourcePool 
警告: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@a91ff6 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
十二月 09, 2020 5:30:32 下午 com.mchange.v2.resourcepool.BasicResourcePool 
警告: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@692194a7 -- 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:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

 

初学mybatis遇到的一个问题将mybatis-config.xml里的连接数据库的4个基本信息
抽出了单独放在一个properties里时,再测试方法,爆出该错误

 

解决办法:

将db.properties的url改为urlName(只要是非url均可),mybatis的设置xml的url对于的value也别忘记了改名!

 

原因:

之前db.properties里的url=xxx和
pom.xml里的url:http://maven.apache.org撞车了,数据库配置文件的url被替换了!
下图:pom.xml的url

 

解决:

把配置文件key改下名字就可以,比如加前缀jdbc.xxx

 

 

转 : https://blog.csdn.net/qq_44831907/article/details/107319521

参考: https://blog.csdn.net/qq_36534731/article/details/102628578

 

posted @ 2020-12-09 17:43  与f  阅读(353)  评论(0编辑  收藏  举报