使用spring boot集成mybatis时,在服务器上插入数据时报错 Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found
将配置数据库文件中的 spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
改成:spring.datasource.driver-class-name=oracle.jdbc.OracleDriver 去掉
driver
-
com.mysql.jdbc.Driver 和 com.mysql.cj.jdbc.Driver的区别 serverTimezone设定
2017-12-06 17:09:14com.mysql.jdbc.Driver 是 mysql-connector-java 5中的, com.mysql.cj.jdbc.Driver 是 mysql-connector-java 6中的1,JDBC连接Mysql5 com.mysql.jdbc.Driver:driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql...com.mysql.jdbc.Driver
是 mysql-connector-java 5中的,com.mysql.cj.jdbc.Driver
是 mysql-connector-java 6中的下载地址:https://dev.mysql.com/downloads/connector/j/5.1.html
仓库地址:https://mvnrepository.com/artifact/mysql/mysql-connector-java
mysql-connector-java 5
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.49</version> </dependency>
1、JDBC连接Mysql5
com.mysql.jdbc.Driver
:driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false username=root password=
2、JDBC连接Mysql6
com.mysql.cj.jdbc.Driver
, 需要指定时区serverTimezone:driverClassName=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false username=root password=
在设定时区的时候,如果设定serverTimezone=UTC,会比中国时间早8个小时,如果在中国,可以选择Asia/Shanghai或者Asia/Hongkong,例如:
driverClassName=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false username=root password=
备注:
I、如果mysql-connector-java用的6.0以上的,如下:
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>6.0.6</version> </dependency>
但是你的driver用的还是
com.mysql.jdbc.Driver
,就会报错:Loading class 'com.mysql.jdbc.Driver'. This is deprecated. The new driver class is 'com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
此时需要把
com.mysql.jdbc.Driver
改为com.mysql.cj.jdbc.Driver
II、还有一个警告:
WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
不推荐不使用服务器身份验证来建立SSL连接。
如果未明确设置,MySQL 5.5.45+, 5.6.26+ and 5.7.6+版本默认要求建立SSL连接。
为了符合当前不使用SSL连接的应用程序,verifyServerCertificate
属性设置为’false’。
如果你不需要使用SSL连接,你需要通过设置useSSL=false
来显式禁用SSL连接。
如果你需要用SSL连接,就要为服务器证书验证提供信任库,并设置useSSL=true
。SSL – Secure Sockets Layer(安全套接层)
-
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdb
2017-05-04 08:55:40异常错误:Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the ...异常错误:Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
这个问题 是在我整合项目过程中出现的,用了最新的mysql 连接驱动
以前版本的jdbc.properties
jdbc.driverClass = com.mysql.dbc.Driver jdbc.url = jdbc:mysql://127.0.0.1:3306/db?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT jdbc.username = root jdbc.password = root123
现在按照最新官方提示支持将com.mysql.jdbc.Driver 改为 com.mysql.cj.jdbc.Driver
jdbc.driverClass = com.mysql.cj.jdbc.Driver jdbc.url = jdbc:mysql://127.0.0.1:3306/db?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT jdbc.username = root jdbc.password = root123
如上情况不能解决君的问题,请耐心自行搜索解决!同时也希望此贴能够帮助各位!
-
Loading class `com.mysql.jdbc.Driver'. This is deprecated警告处理,jdbc更新处
2018-09-07 18:04:53处理:提示信息表明数据库驱动com.mysql.jdbc.Driver'已经被弃用了、应当使用新的驱动com.mysql.cj.jdbc.Driver' 所以,按照提示更改jdbc.properties配置 .com.mysql.jdbc.Driver 改为 com.mysql.cj.jdbc.Driver...声明:使用JDK9、MYSQL8、idea
1.报错信息是这样的;
处理:提示信息表明数据库驱动com.mysql.jdbc.Driver'已经被弃用了、应当使用新的驱动com.mysql.cj.jdbc.Driver'
所以,按照提示更改jdbc.properties配置 .com.mysql.jdbc.Driver 改为 com.mysql.cj.jdbc.Driver
运行结果如下:PS 已经没有这一条报错或者警示了,一条一条处理报错。
2.仍存在报错信息
Fri Sep 07 17:48:01 GMT+08:00 2018 WARN: Establishing SSL connection without server's identity verification
处理:根据报错我们知道这是时间报错,没有指定明确的时区,是因为新版的mysql会询问是否SSL连接,返回一个Boolean值,我们需要手动指定true或者false。所以再次更改配置文件中的 url 满足其要求即可,如下:
"jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8&serverTimezone=UTC&useSSL=false"
2.1、这里是配置了jdbc.properties,完整配置如下:
jdbc.DriverClassName=com.mysql.cj.jdbc.Driver jdbc.url =jdbc:mysql://localhost:3306/student?serverTimezone=UTC&useSSL=false jdbc.username=root jdbc.password=root
2.2、mybatis-config.xml 中引入配置文件、配置数据源如下:
<environments default="development"> <environment id="development"> <!-- 使用jdbc事务管理,事务控制由mybatis--> <transactionManager type="JDBC" /> <!-- 数据库连接池,由mybatis管理--> <dataSource type="POOLED"> <property name="driver" value="${jdbc.DriverClassName}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> </dataSource> </environment> </environments>
运行结果如下:
3、警告处理
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.ibatis.reflection.Reflector (file:/G:/Develop/20180907am/lib/mybatis-3.4.6.jar) to method java.lang.Class.checkPackageAccess(java.lang.SecurityManager,java.lang.ClassLoader,boolean)
WARNING: Please consider reporting this to the maintainers of org.apache.ibatis.reflection.Reflector
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release译文如下: 警告:发生了非法的反射访问操作 警告:通过org.apache. ibatis.com .reflection非法访问。方法java.lang.Class.checkPackageAccess(java.lang.SecurityManager,java.lang.ClassLoader,boolean) 警告:请考虑向org.apache. ibatistics . reflection.reflector的维护者报告此情况 警告:使用——非法访问=warn启用进一步的非法反射访问操作的警告 警告:所有非法访问操作将在未来版本中被拒绝
原因:JDK9的问题,非法反射,用回JDK8就可以了。JDK9版本作为小版本,相对JDK8,以及新出的JDK11这些长期版本来讲、有些许BUG正常,针对这个问题,我看了官方社区,有给出答案说是在未来可能对该问题进行优化处理,并不影响使用;
PS:在框架以后,建议小伙伴都使用JDK8版本开发学习,毕竟好多产品最近更新都已支持到了JDK8、并且、使用重量级的WEB服务器 weblogic 也仅仅支持到JDK8;
-
springboot找不到OracleDriver,求大神解决(Cannot load driver class: oracle.jdbc.driver.OracleDriver)
2019-04-01 14:43:17nested exception is java.lang.IllegalStateException: Cannot load driver class: oracle.jdbc.driver.OracleDriver at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$... -
Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found
2020-02-20 15:48:00使用spring boot集成mybatis时,在服务器上插入数据时报错 Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found将配置数据库文件中的 spring.datasource.driver-class-name=... -
com.mysql.jdbc.Driver驱动包工具
2013-09-13 11:13:23com.mysql.jdbc.Driver驱动包 -
oracle的驱动类:oracle.jdbc.driver.OracleDriver和oracle.jdbc.OracleDriver有什么区别?
2019-08-01 10:16:22oracle.jdbc.OracleDriver与oracle.jdbc.driver.OracleDriver完全一样的 估计是为了与老的版本兼容的问题 。 建议使用oracle.jdbc.OracleDriver类,不建议使用oracle.jdbc.driver.OracleDriver。 jdbc驱动类。。。... -
GeckoDriver
2016-12-20 15:46:44在Selenium对新版本Firefox浏览器的支持,就需要用到了GeckoDriver。首先要启动GeckoDriver,然后使用remote的方式来连接。 支持的Firefox版本范围:50.1.0 启动 geckodriver.exe -b "D:\Program... -
NVIDIA驱动安装报错:this standard driver package cannot be installed on this system
2019-11-05 11:58:20this standard driver package cannot be installed on this system.your system is configured to require a DCH package,please update update your driver using geforce experience to download ... -
selenium中需要的chrome的driver以及firefox的driver应该存放的位置
2019-09-24 06:00:05当我们在这个地址https://github.com/mozilla/geckodriver/releases里下载的firefox的driver放到C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Scripts里,即放到Scripts里即可。而且firefox要在... -
The driver is automatically registered via the SPI and manual loading of the driver class....
2019-05-21 09:23:42Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class... -
KETTLE连接Oracle报错:Driver class 'oracle.jdbc.driver.OracleDriver' could not be found
2019-03-22 11:19:49Driver class ‘oracle.jdbc.driver.OracleDriver’ could not be found, make sure the ‘Oracle’ driver (jar file) is installed. oracle.jdbc.driver.OracleDriver 解决办法: 1.找到Oracle/jdbc/lib路径下的... -
解决 Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found, trying ...
2019-05-22 09:32:00spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver 改为 spring.datasource.driver-class-name=oracle.jdbc.OracleDriver 转载于:... -
No Suitable Driver Found For Jdbc解决方法
2018-08-21 18:00:24在学习java数据库连接池使用的时候遇到问题,无法连接到数据库,之前练习别的时候都没事,莫名的到这里有连接不上了,查看日志是”No Suitable Driver Found For Jdbc”,但查看数据库连接配置没问题啊,后来发现原来是少... -
hibernate问题解决 JDBC Driver class not found: oracle.jdbc.driver.OracleDriver
2017-12-12 20:12:03org.hibernate.HibernateException: JDBC Driver class not found: oracle.jdbc.driver.OracleDriver at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.ja -
jdk版本切换,导致Cannot load JDBC driver class 'Oracle.jdbc.driver.OracleDriver'
2018-12-14 17:13:44后来切换到jdk1.6后,就报Cannot load JDBC driver class 'Oracle.jdbc.driver.OracleDriver' 解决方案,将tomcat中配置的jndi全局变量中的Oracle.jdbc.driver.OracleDriver,改为oracle.jdbc.dri... -
com.mysql.cj.jdbc.Driver和com.mysql.jdbc.Driver的区别
2019-05-23 20:50:50第一反应就是记忆中连接mysql的驱动不都是com.mysql.jdbc.Driver吗?com.mysql.cj.jdbc.Driver是什么鬼? 后来查看了一下才知道 这个跟驱动的依赖版本有关 <dependency> <groupId>mysql</grou... -
uefi driver
2017-05-18 10:29:23uefi drivers 是指在inf中将MODULE_TYPE指定为UEFI_DRIVER。例如inf的例子 [Defines] INF_VERSION = 0x00010005 BASE_NAME = DiskIoDxe MODULE_UNI_FILE = Disk -
Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct
2019-03-10 18:14:33记录一下遇到过的问题 ...Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation. 项目中之前在2.0.x版本的时候引入了mysql的JDBC依赖,能行,升... -
-
chromedriver、geckodriver与edgedriver下载
2019-03-26 09:18:34本人使用的是win10,对应驱动如下 一、三大浏览器的驱动地址: chrome驱动:... Firefox驱动:https://github.com/mozilla/geckodriver/releases/ edge驱动:https://developer.microsoft.com/en... -
SPRING BOOT踩坑——oracle.jdbc.driver.OracleDriver is deprecated
2020-06-09 14:47:262020-06-09 14:39:40.846 ERROR 9492 --- [ main] c.a.druid.pool.DruidAbstractDataSource : oracle.jdbc.driver.OracleDriver is deprecated. 启动日志中有报错信息。 解决方法: 将 driver-class-name: ... -
Cannot load driver class: com.mysql.jdbc.Driver
2017-07-14 16:39:27最新在学习Spring boot集成MyBatis一直报错: Cannot load driver class: com.mysql.jdbc.Driver -
错误:java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
2019-03-10 09:16:24关于这个问题,我找了一下...com.mysql.jdbc.Driver 是 mysql-connector-java 5中的 JDBC连接Mysql5 com.mysql.jdbc.Driver: org.quartz.dataSource.qzDS.driver:com.mysql.jdbc.Driver org.quartz.dataSource.q... -
kettle连接Oracle数据库时报错: Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, ...
2019-10-28 15:19:28Driver class ‘oracle.jdbc.driver.OracleDriver’ could not be found, make sure the ‘Oracle’ driver (jar file) is installed. oracle.jdbc.driver.OracleDriver… … … 这个错误原因是没有找到... -
MyEclipse 装载database driver 时提示driver class not found
2019-03-10 15:04:58MyEclipse 装载database driver 时提示driver class not found 原因: mysql-connector-java-xxx.jar 版本不对 由于Java 以及mysql的版本过于混乱,在不做测试前,不要完全更新为新版本 目前我测试的版本为 ... -
The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically
2019-09-29 16:19:12Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual load... -
安装Chrome driver/ IE driver
2014-08-15 11:38:04chrome driver的下载地址: https://chromedriver.storage.googleapis.com/2.10/chromedriver_win32.zip -
成功解决This DCH driver package is not compatible with the currently installed version of Windows....
2020-08-30 10:19:37成功解决This DCH driver package is not compatible with the currently installed version of Windows. This system is configured to require a Standard driver package. The correct driver can be downloaded ... -
idea下载mysql驱动失败 download missing driver files,downloading driver files
2020-02-14 11:01:35如下图 点击Download missing driver files 中的Download 下载驱动失败 打开手机热点,电脑连接手机热点,进行下载,很快就下载成功。
-
橙黄色职业培训中心网页模板
-
转行做IT-第5章 流程控制语句
-
python二级考试复习资料
-
转行做IT-第6章 IDEA、方法
-
juc的总结概要
-
教育培训会员平台网页模板
-
xcalbuild-v编译
-
电商设计专业思维
-
青春校园信息动态网页模板
-
第3章 入门程序、常量、变量
-
信通院-云计算发展白皮书2020.pdf
-
前端架构师-速成
-
重庆行政区PPT.pptx
-
少儿学习教育产品网页模板
-
Kotlin协程极简入门与解密
-
Python报错ValueError: embedded null character。
-
「SequoiaDB巨杉数据库」getLobDetail()概述2
-
优化数据库的操作
-
docker下的mysql server安装(树莓派4b)
-
gradle 运行 java test Out of memory(内存溢出)、GC overhead limit exceeded(超出GC开销限制)问题