c3p0数据源配置抛出Could not load driverClass com.mysql.jdbc.Driver的解决方案
来源:互联网 发布:nginx部署java web 编辑:程序博客网 时间:2024/05/21 08:38
1.0 配置c3p0数据源,一直提示 无法加载数据库驱动。
但是明明有驱动,非常疑惑。。。。。
com.mchange.v2.c3p0.DriverManagerDataSource ---- Could not load driverClass com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverat org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1311)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1145)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:112)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:144)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
com.mchange.v2.c3p0.DriverManagerDataSource ---- Could not load driverClass com.mysql.jdbc.Driver
查看applicationcontext.xml
仔细观察,木有任何问题
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="${jdbc.driverClassName}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<!-- 初始化建立的连接数 -->
<property name="initialPoolSize" value="10"/>
<!-- 最大空闲时间,120秒内未被使用的连接将被丢弃 -->
<property name="maxIdleTime" value="120"/>
<!-- 当连接池耗尽,且未达到最大连接数时,一次获取的连接数 -->
<property name="acquireIncrement" value="2"/>
<!-- 空闲检查时间间隔, 每隔120秒检查连接池里的空闲连接 ,单位是秒 -->
<property name="idleConnectionTestPeriod" value="60"/>
</bean>
查看jdbc.properties
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/dftsms?useUnicode\=true&characterEncoding\=UTF8
jdbc.username=root
jdbc.password=1234
jdbc.initialPoolSize=10
jdbc.maxIdleTime=120
jdbc.acquireIncrement=2
jdbc.idleConnectionTestPeriod=60
仔仔细细看完,木有任何问题啊 ,这他么怎么回事儿。。。。。。
最后,经过多方查证,原来是jdbc.properties 文件中jdbc.driverClassName=com.mysql.jdbc.Driver,这一句配置后面有个空格。。。。。。。
- c3p0数据源配置抛出Could not load driverClass com.mysql.jdbc.Driver的解决方案
- 警告: Could not load driverClass com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdb
- Could not load JDBC driver class [com.mysql.jdbc.Driver]
- spring配置c3p0报错Could not load driverClass oracle.jdbc.OracleDriver
- Could not load driverClass oracle.jdbc.driver.OracleDriver
- Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver
- Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver
- Could not load requested class : com.mysql.jdbc.Driver
- spring+mybatis 报Could not load driverClass ${jdbc.driverClass}
- spring+mybatis 报Could not load driverClass ${jdbc.driverClass}
- 报错:Could not load JDBC driver class [com.mysql.jdbc.Driver]
- Could not load JDBC driver class [com.mysql.jdbc.Driver]异常
- can not load com.mysql.jdbc.Driver
- 解决 Could not load JDBC driver class [com.mysql.jdbc.Drivers]
- Spring Boot 出现 Could not load JDBC driver class [com.mysql.jdbc.Drivers]
- powerDesigner Non SQL Error : Could not load class com.mysql.jdbc.Driver
- PowerDesigner提示错误Non SQL Error : Could not load class com.mysql.jdbc.Driver
- Cannot load JDBC driver class 'com.mysql.jdbc.Driver' 错误的解决方案
- [LeetCode] ZigZag Conversion
- Python爬取今日头条搜索的照片。使用requests+正则表达式
- SpringBoot一些很实用的功能
- 中序线索化二叉树以及中序遍历线索化二叉树、倒中序遍历线索化二叉树
- 直接插入排序
- c3p0数据源配置抛出Could not load driverClass com.mysql.jdbc.Driver的解决方案
- Slim Span UVA
- django开发(6)配置url
- 希尔排序 插入排序的升级
- android的几种数据存储方式
- 洛谷 P2756 飞行员配对方案问题
- 堆排序 选择排序的升级
- 如何提高前端工作效率?
- c语言 快速排序