java.sql.SQLException: No suitable driver 的详细解决办法_java.sql.sqlexception: no suitable driver at java.

作者：IT小白 | 2024-05-19 15:09:27

踩

java.sql.sqlexception: no suitable driver at java.sql.drivermanager.getdriv

java.sql.SQLException: No suitable driver 的详细解决办法


com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3627613e -- 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:134)
	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.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)

遇到这个问题，解决办法：

1.看是否导入了JDBC的驱动程序，如下面的mysql的JDBC的驱动程序

2.看驱动程序是否添加到BuildPath中，右击驱动程序，选择BuildPath，点击Add BuildPath选择项,如果没有那个选择项，就说明已经添加BuildPath

3.看是否是c3p0-config.xml配置出错，要小心不要写错，比如下面的红色的可能出错，不能够写成“driver”或者是“driverclass”,这样就应该不会有问题了


<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
	<default-config>
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://localhost:3306/company</property>
		<property name="user">root</property>
		<property name="password">123456</property>
	 
	 	<property name="initialPoolSize">10</property>
	 	<property name="maxIdleTime">30</property>
	 	<property name="maxPoolSize">100</property>
	 	<property name="minPoolSize">10</property>
	 	
	</default-config>
</c3p0-config>

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/IT小白/article/detail/593481