jsp com.mysql.jdbc.driver,无法加载JDBC驱动程序类[com.mysql.jdbc.Driver]

最新推荐文章于 2023-04-20 11:55:43 发布
最新推荐文章于 2023-04-20 11:55:43 发布
阅读量332 收藏
点赞数
文章标签： jsp com.mysql.jdbc.driver

So, this is my project structure:

5wH7Y.png

Inside cats-application I have CatsDAO class where I am trying to @Autowire DataSource object:

import javax.sql.DataSource;

@Repository

public class CatsDAO {

@Autowired

private DataSource dataSource;

public Cat getCat(String name) {

String sql = "SELECT * FROM cats WHERE name = ?";

Connection conn = null;

try {

...

} catch (SQLException e) {

throw new RuntimeException(e);

} finally {

...

}

}

}

And this is my applicationContext.xml in cats-webapp:

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:mvc="http://www.springframework.org/schema/mvc"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">

And this is my cats-application pom.xml file:

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

cats

ninja.majewski

1.0-SNAPSHOT

4.0.0

cats-application

ninja.majewski

cats-domain

1.0-SNAPSHOT

org.springframework

spring-context

4.2.5.RELEASE

mysql

mysql-connector-java

6.0.2

org.apache.maven.plugins

maven-compiler-plugin

3.5.1

1.8

1.8

And my cats-webapp pom.xml file:

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

4.0.0

groupId

cats-webapp

1.0-SNAPSHOT

ninja.majewski

cats-application

1.0-SNAPSHOT

org.springframework

spring-webmvc

4.2.5.RELEASE

jstl

jstl

1.2

org.hibernate

hibernate-validator

5.2.4.Final

org.apache.maven.plugins

maven-compiler-plugin

3.5.1

1.8

1.8

But when I try to run this on server I get this exception:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'catsDAO': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private javax.sql.DataSource ninja.majewski.cats.CatsDAO.dataSource; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:

PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver]

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:334)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)

at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4994)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5492)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)

at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1762)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:301)

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)

at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)

at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:618)

at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:565)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:301)

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)

at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)

at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468)

at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)

at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309)

at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1401)

at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323)

at sun.rmi.transport.Transport$1.run(Transport.java:200)

at sun.rmi.transport.Transport$1.run(Transport.java:197)

at java.security.AccessController.doPrivileged(Native Method)

at sun.rmi.transport.Transport.serviceCall(Transport.java:196)

at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)

at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)

at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$256(TCPTransport.java:683)

at java.security.AccessController.doPrivileged(Native Method)

at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private javax.sql.DataSource ninja.majewski.cats.CatsDAO.dataSource; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:

PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver]

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:573)

at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:331)

... 58 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:

PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1518)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014)

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:545)

... 60 more

Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:

PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver]

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:121)

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1514)

... 71 more

What am I missing here?

解决方案

You probably skipped some dependencies:

mysql

mysql-connector-java

5.1.6

weixin_39857513
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
【CSDN】
02-26 938
首先查看配置内mysqlDriver是否匹配： com.mysql.jdbc.Driver是 mysql-connector-java 5中的，com.mysql.cj.jdbc.Driver是 mysql-connector-java 6中的 其次查看pom内驱动是否版本对应、 mysql的版本对应jdbc驱动的版本 Connector/J 5.1 支持Mysql 4.1、Mysql 5.0、Mysql 5.1、Mysql 6.0 alpha这些版本。 Connecto...
在idea中遇到，编写jsp与MySQL遇到ClassNotFoundException:com.mysql.jdbc.Driver问题的解决方案
weixin_43353748的博客
04-20 372
1.打开Project Structure 2.找到Artifacts . 3.在WEB-INF处会有红色的报错，在右下角会有改正的操作，选择第一个就可以了 因为我的改过了，所以不会看到报错。 下面是实验的jsp代码，和一些sql语句 jsp <%-- Created by IntelliJ IDEA. User: Lenovo Date: 2020/4/20 Time:...
com.mysql.jdbc.Driver驱动包，亲测可用
10-09
com.mysql.jdbc.Driver驱动包，亲测可用,自用版，
jenkins mysql插件_无法加载JDBC驱动程序类'com.mysql.jdbc.Driver'声纳插件jenkins
weixin_39805720的博客
02-26 337
我正在与詹金斯使用声纳插件。它总是产生此错误。看来插件找不到JDBC驱动程序。我尝试根据我在google中找到的许多解决方案将JDBC驱动程序放在许多可能的位置，但是它仍然会产生此错误。C:\Jenkins\tools\hudson.plugins.sonar.SonarRunnerInstallation\sonar-runner-2.4SonarQube Runner 2.4Java 1.7....
Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’
T1798218285的博客
04-20 6938
确保在“JDBC Connection Configuration”元件的“JDBC Driver Class”字段中输入正确的驱动程序类名（如 com.mysql.jdbc.Driver），并且在“JDBC Connection Configuration”和“JDBC Request”元件的“JDBC Driver”字段中输入正确的驱动程序 jar 包路径。3. **驱动程序版本不兼容：** 如果你使用的是较新版本的 JDBC 驱动程序，则可能与 JMeter 不兼容。
com.mysql.jdbc.driver at org.apache.catali_tomcat – 无法加载JDBC驱动程序类’com.mysql.jdbc.Driver’...
weixin_35039018的博客
01-19 145
嗨,我在linux机器上的tomcat中部署我的应用程序,我收到错误……我在tomcat / server / lib文件夹中放了mysql-connector-java-5.1.18-bin.jar ..org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'...
IDEA中JDBC连接数据库无法加载驱动问题
sheguangfei的博客
03-06 3537
环境： <dependencies> <!--mysql的驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.16</version>
JSP com.mysql.jdbc.Driver‘. This is deprecated. The new d.pdf
12-16
在JavaServer Pages (JSP)开发中，与数据库交互是一个常见的任务，而连接MySQL数据库时，通常会使用MySQL Connector/J，这是一个Java Database Connectivity (JDBC)驱动程序。然而，随着时间的推移，技术也在不断...
jsp连接数据库出现java.lang.ClassNotFoundException: com.mysql.jdbc.Driver异常以及不同情况的排错解决方法
Xmumu_的博客
10-31 4099
今天在开心的写项目的时候，我想在jsp页面上测试一下我连接数据库成功没有，所以呢，今天又是排错成功的一天，所以写篇博客小小庆祝一下???? 以下是我在index.jsp上写好了代码： <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.DriverManager" %> <%@ page import="java.sql.SQLException" %><%-- Created
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
bird
06-23 1514
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188) at java
Access-Jdbc-Driver jar包.zip
09-11
1、解压后lib目录里面的jar包为Access-jdbc-driver依赖包，没有请一起导入 2、压缩包里面有示例代码 3、不是Access_JDBC.jar 4、没有连接次数限制，完全开源免费，亲测可用 5、有问题可发邮件联系jeeva.wang@qq.com
AccessJdbc驱动JAR包
10-15
1、解压后lib目录里面的jar包为Access-jdbc-driver依赖包，没有请一起导入 2、压缩包里面有示例代码 3、不是Access_JDBC.jar 4、没有连接次数限制，完全开源免费，亲测可用 5、有问题可发邮件联系jeeva.wang@qq.com
com.mysql.jdbc.driver at org.apache.catali_Cannot find class: com.mysql.jdbc.Driver错误及解决办法。...
weixin_42356460的博客
01-26 156
org.apache.ibatis.exceptions.PersistenceException:### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Canno...
jsp连接数据库老是报Driver的错
YW博客
05-03 315
解决， 将myslq-connector.jar放到tomcat的lib下
Java/JSP程序连接不上Mysql驱动问题解决方法
w36680130的博客
09-02 134
Java/JSP程序连接不上Mysql驱动问题解决方法
JDBC 加载驱动报错解决办法
m0_57448314的博客
10-14 4120
常见的 JDBC 报错：问题点1.注册驱动‘；问题点2. 获取链接；
Cannot load driver class: com.mysql.jdbc.Driver 异常解决办法
热门推荐
pingweicheng的博客
06-13 4万+
启动springboot应用时，报以下异常：Cannot load driver class: com.mysql.jdbc.Driver 如图所示：原因：可能由于application.properties文件中数据源相关配置值有空格，如图所示：解决办法：检查每个配置值最后是否有空格，把鼠标放在配置值最后，如果发现前面有空格，则去掉空格，保存配置文件，重启即可。处理后配置值无空格的效果图如下，...
com.mysql.jdbc.Driver错误解决方法
weixin_42407721的博客
06-20 2万+
把mysql的驱动包放在web工程下的WEB-INF下的lib目录下即可。
Stacktrace:] java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
最新发布
03-16
在你的情况下，程序尝试加载com.mysql.cj.jdbc.Driver类，但是该类不存在或者没有正确配置相关的依赖。 为了解决这个问题，你可以尝试以下几个步骤： 1. 确保你的项目中包含了mysql-connector-java的依赖。你可以在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值