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 driverat 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>