解决 Could not load JDBC driver class [com.mysql.jdbc.Drivers]

最新推荐文章于 2023-04-20 11:55:43 发布
最新推荐文章于 2023-04-20 11:55:43 发布
阅读量1.3k 收藏 1
点赞数
CC 4.0 BY-SA版权
分类专栏： java报错 文章标签： java报错
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_32325583/article/details/79020576
本文介绍如何使用Maven项目管理工具导入mysql-connector-java.jar，实现Java应用程序与MySQL数据库的连接。文中提供了具体的依赖配置代码示例。

先确定是否导出  mysql-connector-java.jar JAR包

方法：【maven】项目直接再pom.xml文件中添加

<dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <version>5.1.5</version>
</dependency>

其他通过java building path -> add External jars 导入外部包。



spark.read.option(jdbc)参数
卡奥斯道的博客
10-25 5762
Property Name Meaning url The JDBC URL to connect to. The source-specific connection properties may be specified in the URL. e.g.,jdbc:postgresql://localhost/test?user=fred&password=secre...
hive查看数据库之后报HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoo
徐磊的博客
02-04 4026
错误详情 FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient 错误分析 该错误表明无法初始化元数据存储客户端的会话对象，即无法访问Hive元数据。 解决： 运行hive --serv...
关于Could not load driverClass ${jdbc.driverClassName}问题解决方案
alwpojz297332的博客
07-15 597
在spring与mybatis3整合时一直遇到Could not load driverClass ${jdbc.driverClassName}报错如果将 ${jdbc.driverClassName} 改成具体的值就不会报错！ 解决方案一： 将 　　<property name="sqlSessionFactory"ref="sqlSessionFactory"/&gt...
添加spring boot devtools 依赖包 报错： 导致 the url can not null
qq_16298769的博客
09-15 1515
添加spring boot devtools依赖包时导致的the url can not null springboot devtools 配置如下。 <!-- spring boot devtools 依赖包. --> <dependency> <groupId>org.springframework.boot&...
JDBC和数据库连接池
itzzan的博客
10-29 1818
JDBC为访问不同的数据库提供了统一的接口，为使用者屏蔽了细节问题Java程序员使用JDBC，可以连接任何提供了JDBC驱动程序的数据库系统，从而完成对数据库的各种操作JDBC的基本原理图一般将实现接口打包成jar包，只需要调用接口即可表示数据库结果集的数据表，通常通过执行查询数据库的语句生成ResultSet对象保持一个光标指向其当前的数据行。最初，光标位于第一行之前。
Could not load JDBC driver class [com.mysql.jdbc.Driver]
z19799100的博客
03-21 5695
使用springboot获取数据源的时候出现这个错误 错误原因：是因为没有导入mysql的依赖 解决：去maven官网将mysql的依赖复制粘贴到pom文件中 ok保存重启就好了 <!-- mysql依赖 --> <dependency> <groupId>mysql</groupId> <artifactId>...
ODI代理找不到驱动
03-08
oracle.odi.core.exception.OdiRuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.microsoft.jdbc.sqlserver.SQLServerDriver] at oracle.odi.core.datasource....
28-Mar-2025 11:04:59.597 INFO [mysql-cj-abandoned-connection-cleanup] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1440) at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:1065) at com.mysql.jdbc.AbandonedConnectionCleanupThread.checkThreadContextClassLoader(AbandonedConnectionCleanupThread.java:112) at com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:79) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)
03-29
Could not load [] ``` --- ### 二、根本原因 #### 1. **MySQL连接清理线程未正确终止** - **现象**：`AbandonedConnectionCleanupThread`（MySQL JDBC驱动内建的废弃连接清理线程）在Web应用关闭后未自动停止...
08-Sep-2025 13:35:44.453 SEVERE [http-nio-8080-exec-15] org.apache.catalina.core.StandardContext.startInternal Context [/mesFERROTEC] startup failed due to previous errors 08-Sep-2025 13:35:44.976 WARNING [http-nio-8080-exec-15] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [mesFERROTEC] registered the JDBC driver [com.mysql.cj.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 08-Sep-2025 13:35:44.978 WARNING [http-nio-8080-exec-15] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [mesFERROTEC] appears to have started a thread named [mysql-cj-abandoned-connection-cleanup] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.lang.Object.wait(Native Method) java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144) com.mysql.cj.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:85) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) java.lang.Thread.run(Thread.java:748) 08-Sep-2025 13:35:44.979 WARNING [http-nio-8080-exec-15] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [mesFERROTEC] appears to have started a thread named [pool-21-thread-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: sun.misc.Unsafe.park(Native Method) java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215) java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078) java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093) java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809) java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) java.lang.Thread.run(Thread.java:748) 08-Sep-2025 13:35:44.986 INFO [http-nio-8080-exec-15] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/mesFERROTEC.war] has finished in [109,199] ms 08-Sep-2025 13:35:47.008 INFO [mysql-cj-abandoned-connection-cleanup] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access. at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1378) at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:1030) at com.mysql.cj.jdbc.AbandonedConnectionCleanupThread.checkThreadContextClassLoader(AbandonedConnectionCleanupThread.java:117) at com.mysql.cj.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:84) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)
最新发布
09-09
Driver driver = drivers.nextElement(); DriverManager.deregisterDriver(driver); } } } ``` #### 步骤2: 配置Tomcat强制注销JDBC驱动 在Tomcat的`context.xml`中配置： ```xml ... ...
org.springframework.beans.factory.BeanCreationException-C3P0错误修改
weixin_30755709的博客
01-03 232
具体报错信息 org.springframework.beans.factory.BeanCreationException:Error creating bean with name 'dataSource' defined in class path resource [spring/appilcationContast.xml]:Error setting property value...
maven 引入了mysql jdbc的Driver之后仍提示Cannot load driver class: com.mysql.jdbc.Driver
热门推荐
billluffy的博客
10-18 1万+
之前实习的时候就遇到了这个问题，但是当时是别人教我解决的，也没太注意，mark了一个解决方案： 首先，我需要连接到MySQL 5.5的jar应该是  mysql-connector-java-5.1.15-bin.jar 但不是  mysql-connector-java-5.1.15.jar。其次，这个jar在maven存储库中是不可用的，所以我需要手动将其添加到我的本地mav
Could not load JDBC driver class [com.mysql.cj.jdbc.Driver]
qq_36109477的博客
08-12 702
今天使用JdbcTemplate连接数据库时，配置驱动类，结果报错如下： Could not load JDBC driver class [com.mysql.cj.jdbc.Driver] 分析是没有找到驱动类，修改配置如下： dataSource.setDriverClassName("com.mysql.jdbc.Driver"); 问题出现是因为驱动类跟数据库版本不一致。 ...
Could not load JDBC driver class [oracle.jdbc.driver.OracleDriver]
天道酬勤，且行且思，勿思而不行
11-12 1453
在用spring框架连接JDBC数据库时 发生如下错误： org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [applicationContext.xml]: Error set...
java 运行报错：Could not load JDBC driver class [com.mysql.cj.jdbc.Driver]
m0_58049574的博客
04-05 4819
spring配置文件链接数据库操作异常及解决方法
Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’
T1798218285的博客
04-20 8690
确保在“JDBC Connection Configuration”元件的“JDBC Driver Class”字段中输入正确的驱动程序类名（如 com.mysql.jdbc.Driver），并且在“JDBC Connection Configuration”和“JDBC Request”元件的“JDBC Driver”字段中输入正确的驱动程序 jar 包路径。3. **驱动程序版本不兼容：** 如果你使用的是较新版本的 JDBC 驱动程序，则可能与 JMeter 不兼容。
Failed to load ApplicationContext和Could not load JDBC driver class com.mysql.cj.jdbc.Driver
欢迎。
10-20 665
在使用Spring纯注解配置声明式事务的时候，突然报错。 首先报错Failed to load ApplicationContext，原因不外乎三个： 配置文件错误。 包未扫描到错误。 没有把各层存入容器（即像Service层的@Service注解此类）。 最下面报错Could not load JDBC driver class com.mysql.cj.jdbc.Driver 检查配置文件中数据库连接发现com.mysql.cj.jdbc.Driver后面多写了个“;”，删除后成功运行。 所以报错的
spring+mybatis 报Could not load driverClass ${jdbc.driverClass}
Hu199055的专栏
04-10 2809
使用spring+mybaits，将数据库连接信息写在jdbc.properties中， Xml代码   bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">          property name="loca
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
12-31 1万+
在使用spring+mybatis时会出现Cannot load JDBC driver class ${jdbc.driverClassName}之类的出错。  原因是在spring里使用org.mybatis.spring.mapper.MapperScannerConfigurer 进行自动扫描的时候，设置了sqlSessionFactory 的话，可能会导致PropertyPlaceho
could not load driverclass com.mysql.jdbc.driver
03-16
这个错误提示是因为无法加载MySQL的JDBC驱动程序com.mysql.jdbc.Driver。可能是因为驱动程序的jar包没有正确添加到项目中，或者驱动程序的版本不兼容。需要检查驱动程序的jar包是否存在，并且是否与MySQL数据库版本...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值