Sqoop报错- 'com.mysql.jdbc.Driver' is deprecated.The new driver class is 'com.mysql.cj.jdbc.Driver'.

最新推荐文章于 2022-08-21 11:57:20 发布
原创 最新推荐文章于 2022-08-21 11:57:20 发布 · 1.9k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#Sqoop报错 #'com.mysql.jdbc.Driver' #This is deprecated #'com.mysql.cj.jdbc.Driver'

Issue

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.
ERROR manager .SqlManager: Error executing statement: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

在这里插入图片描述
在这里插入图片描述

Answer

在Sqoop-MySQL导入到Hive中，com.mysql.jdbc.Driver过期， 新的驱动程序类是'com.mysql.cj.jdbc.Driver'

降低mysql jdbc包的版本，从mysql-connector-java-8.0.15.jar降低到mysql-connector-java-5.1.47.jar（放在sqoop下的lib文件夹下），就恢复正常

在这里插入图片描述
在这里插入图片描述

快速解决：Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.c
快乐学习
10-20 1万+
快速解决报错：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.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdb
qq_43303414的博客
04-17 793
运行idea中的项目爆红 Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdb 大致是爆这个东西 Loading class com.mysql.jdbc.Driver’. This is deprecated. The new driver cl...
sqoop组件运行出错问题解决--com.mysql.jdbc.Driver
weixin_34242509的博客
04-17 595
  sqoop list-tables --connect jdbc:mysql://192.168.11.94:3306/huochetoudalian --username xxx -password xxxWarning: /opt/cloudera/parcels/CDH-5.0.2-1.cdh5.0.2.p0.13/bin/../lib/sqoop/../accumulo does n...
Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.cj.jdb
智十七的博客
03-25 2103
Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.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”.
sqoop连接MySQL报错Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is
weixin_55549435的博客
08-21 1391
sqoop连接MySQL报错Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is
`com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver‘的解决办法
Spring Boot-Common On With You
03-26 1578
问题概述 在工程项目中使用的是MySQL数据库，在项目构建完毕后启动项目工程是没有问题的，但是在接口访问就老是提示驱动弃用，具体提示内容“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 o...
【JDBC连接MySql数据库报错】Loading class `com.mysql.jdbc.Driver‘. This is deprecated.The new driver class is
蓦然一笑的博客
03-12 2777
使用mysql8.0.27连接数据库时，运行测试报错如下： 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.
INFO tool.CodeGenTool: Beginning code generation Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'.
06-25
$ sqoop job --create myjob -- import --connect jdbc:mysql://example.com/db --table mytable --driver com.mysql.cj.jdbc.Driver ``` 这将确保作业始终使用最新的 JDBC 驱动运行，从而提升整体稳定性与兼容性 [^...
sqoop语句执行报Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is
07-09
The new driver class is 'com.mysql.cj.jdbc.Driver'`。用户希望解决这个警告，即更新驱动类。 根据引用[1]，用户已经将MySQL 8.0的JDBC驱动（mysql-connector-java-8.0.12.jar）复制到了Sqoop的lib目录。但是，...
[root@hadoop0 bin]# sh sqoop list-databases --connect jdbc:mysql://hadoop0:3306 --username root --password 230920Ljj/ Warning: /usr/lib/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail. Please set $HCAT_HOME to the root of your HCatalog installation. 25/07/07 19:47:28 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 25/07/07 19:47:28 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. 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. 25/07/07 19:47:29 ERROR manager.CatalogQueryManager: Failed to list databases java.sql.SQLException: Access denied for user 'root'@'hadoop0' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:801) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.CatalogQueryManager.listDatabases(CatalogQueryManager.java:57) at org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) 25/07/07 19:47:29 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'root'@'hadoop0' (using password: YES) java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'root'@'hadoop0' (using password: YES) at org.apache.sqoop.manager.CatalogQueryManager.listDatabases(CatalogQueryManager.java:73) at org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) Caused by: java.sql.SQLException: Access denied for user 'root'@'hadoop0' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:801) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.CatalogQueryManager.listDatabases(CatalogQueryManager.java:57) ... 7 more [root@hadoop0 bin]#
最新发布
07-09
我们正在处理一个Sqoop连接MySQL时出现的访问被拒绝错误。用户之前尝试在MySQL中授权时遇到了语法错误，现在使用Sqoop时又遇到了访问被拒绝的问题。结合之前的讨论，我们需要注意MySQL 8.0的授权语法变更，以及Sqoop...
解决Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.cj.~
King_wq_2020的博客
07-31 1613
报错详情： 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. 原因： jdbc驱动和mysql版本..
解决Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.j
weixin_40359716的博客
03-03 623
解决Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. 整合spring boot项目过程中出现的，用了最新的mysql 连接驱动 需要将 com.mysql.jdbc.Driver 改为 com.mysql.cj.jdbc.Dri...
解决Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.
weixin_44012721的博客
05-18 682
解决Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. 异常： Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.m...
Loading class `com.mysql.jdbc.Driver‘. This is deprecated.解决方法
一切因为是码农
10-11 2万+
警告信息： Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. 提示信息表明： 数据库驱动com.mysql
Loading class com.mysql.jdbc.Driver.This is deprecated. The new driver的解决方法
weixin_43297668的博客
06-04 1万+
今天新建一个Springboot项目，项目运行时出现以下警告： 翻译为： 加载类“com.mysql.jdbc.Driver”。已经被弃用。新的驱动程序类是“com.mysql.cj.jdbc.Driver”。驱动程序是通过SPI自动注册的，手动加载驱动程序类通常是不必要的。所以只需要在application.yml文件中把com.mysql.jdbc.Driver修改为com.mysql.cj.jdbc.Driver即可 ...
sqoop job import mysql com.mysql.jdbc.Driver包异常
hello_java_lcl的博客
09-17 260
异常信息： 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. 网上查了一下是mysq...
解决Driver class ‘com.mysql.cj.jdbc.Driver‘ not found.
热门推荐
qq_39885923的博客
04-01 3万+
IDE链接mysql数据库报错Driver class ‘com.mysql.cj.jdbc.Driver’ not found. 解决办法： 1.点击链接mysql数据的设置页面进入到驱动查看页面 2.点击driver files 里面的mysql的驱动更改驱动内容 3.点击下面的apply完成设置 4.设置完成如果提示找不到class，重启ide后进入到设置页面遍可以更改class文件。 注：不同版本的mysql对应的驱动也是不一样的。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值