spring下配置tomcat jdbc pool 报找不到"com.mysql.jdbc.Driver"类

最新推荐文章于 2022-09-18 10:34:31 发布

weixin_33859504

最新推荐文章于 2022-09-18 10:34:31 发布

阅读量784

点赞数 1

文章标签： java 数据库开发工具

原文链接：https://my.oschina.net/u/1051372/blog/1553378

版权

2019独角兽企业重金招聘Python工程师标准>>>

初始配置如下：

<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource">
   <property name="url" value="${demo.jdbc.url}" />
   <property name="username" value="${demo.jdbc.username}" />
   <property name="password" value="${demo.jdbc.password}" />
   <property name="driverClassName" value="${demo.jdbc.driverClassName}" />
</bean>

启动tomcat报异常信息：

严重: Unable to create initial connections of pool.
java.sql.SQLException: com.mysql.jdbc.Driver
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:254)
   at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
   at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
   at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
   at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)

....

最后解决方式两种：

一：在tomcat/lib目录添加数据库连接jar包

二：tomcat目录不变，修改配置如下：

<bean id="dataSourceTemplate" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
   <property name="url" value="${demo.jdbc.url}" />
   <property name="username" value="${demo.jdbc.username}" />
   <property name="password" value="${demo.jdbc.password}" />
   <property name="driverClassName" value="${demo.jdbc.driverClassName}" />
</bean>

<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource">
   <property name="dataSource" ref="dataSourceTemplate"/>
</bean>

转载于:https://my.oschina.net/u/1051372/blog/1553378