sqoop job import mysql com.mysql.jdbc.Driver包异常

最新推荐文章于 2023-05-23 15:42:27 发布
原创 最新推荐文章于 2023-05-23 15:42:27 发布 · 280 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #sqoop

异常信息：

        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-connector-java包的版本问题，需要下载mysql-connector-java-5.1.47.jar

查询后，发现好多都是付费资源，然后找到了官方下载地址：https://downloads.mysql.com/archives/c-j/MySQL :: Download MySQL Connector/J (Archived Versions)

问题解决的参考链接：Sqoop报错- 'com.mysql.jdbc.Driver' is deprecated.The new driver class is 'com.mysql.cj.jdbc.Driver'._Destiny的博客-优快云博客 

非常感谢大家的分享！ 

最低0.47元/天 解锁文章
CDH Sqoop 同步Mysql 数据至hive 报错The specified datastore driver (“org.apache.derby.jdbc.EmbeddedDriver“)
爱摄影的小章同学的博客
05-12 1082
CDH Sqoop 同步Mysql 数据至hive 报错，报错内容为 Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the “BONECP” plugin to create a ConnectionPool gave an error : The specified datastore driver (“org.apache.derby.jdbc.EmbeddedDriver”) was not fou
sqoop组件运行出错问题解决--com.mysql.jdbc.Driver
weixin_34242509的博客
04-17 609
  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...
com.mysql.jdbc.Driver驱动包工具
09-13
com.mysql.jdbc.Driver驱动包
Sqoop常用操作命令
qq_42264264的博客
05-23 265
注意： Sqoop导入数据时，如果多个数据源使用同一个Sqoop客户端，需要注意jdbc jar包冲突问题，建议每个数据源使用独立的Sqoop客户端。
Class.forName("com.mysql.jdbc.Driver") ;
angjiu8534的博客
04-07 1030
try { Class.forName("com.mysql.jdbc.Driver") ; } catch(ClassNotFoundException e) { System.out.println("找不到驱动程序类 ，加载驱动失败！"); // TODO } 　　在上面的代码中，class.forName("com.mysq...
sqoop找不到MySQL驱动_Sqoop jdbc 连接 MySQL 驱动包com.mysql.cj.jdbc.Driver 问题解决方法...
weixin_30999669的博客
01-18 1466
Sqloop 通过jdbc 连接Mysql数据库，提示驱动过期，如下：https://www.cndba.cn/cndba/dave/article/3302https://www.cndba.cn/cndba/dave/article/3302https://www.cndba.cn/cndba/dave/article/3302https://www.cndba.cn/cndba/dave/a...
25/09/04 22:42:23 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:494) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:327) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:736) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:143) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) at org.apache.sqoop.Sqoop.main(Sqoop.java:236) 25/09/04 22:42:23 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1651) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:143) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
最新发布
09-06
`mysql-connector-java-5.1.35-bin.jar` 的下载地址为 `http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.35.tar.gz`。下载完后解压，在解压的目录下可以找到 `mysql-connector-java-...
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 驱动运行，从而提升整体稳定性与兼容性 [^...
jdbc连接mysql加载驱动程序com.mysql.jdbc.Driver
weixin_30256901的博客
07-11 915
在开发环境如eclipse，中加载指定数据库的驱动程序。需要下载MySQL支持JDBC的驱动程序mysql-connector-java-5.1.25-bin.jar。 而具体在Java程序中加载驱动，是在Java程序中添加“Class.forName(“指定数据库的驱动程序”)” 来实现，MySQL的数据驱动程序的代码为：Class.forName(“com.mysql.jdbc.Dr...
Sqoop报错- 'com.mysql.jdbc.Driver' is deprecated.The new driver class is 'com.mysql.cj.jdbc.Driver'.
Destiny的博客
04-29 1980
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...
关于myeclipse连接mysql数据库显示：The import com.mysql cannot be resolved问题
weixin_45604566的博客
03-30 5691
首先贴出来我遇到的这个问题： 已经导入了mysql的驱动，但是导包的时候报出以下错误： 始终报出这个包无法解析 解决办法： 首先检查你的jdk版本，是否与你导入的mysql驱动所匹配，高版本的jdk可能会不兼容驱动，目前好像MySQL只支持到jdk1.8x（如果不是的话，求轻喷，也求科普） 查看方法： 打开myeclipse——>点击上方window ——>prefere...
JDBC-报错（Exception in thread “main“ java.lang.ClassNotFoundException: com.mysql.jdbc.Driver）已解决
MMH1028的博客
03-06 2883
JDBC-报错（Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver）已解决
sqoop连接MySQL报错Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is
weixin_55549435的博客
08-21 1419
sqoop连接MySQL报错Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is
com.mysql.jdbc是什么,什么是导入com.mysql.jdbc.Driver;
weixin_42299396的博客
02-04 899
As part of my project I am trying to connect it with database. I searched in google for the code and I got the following code. In that I don't understand 2 things - "import com.mysql.jdbc.Driver;" and...
jdbc连接mysql数据库简单代码
兴趣人生的博客
12-20 489
import com.mysql.jdbc.Driver; import java.sql.*; public class ConDB {     //设置本地MySQL数据库连接字符串     private final static String URL="jdbc:mysql:///approve_demo?user=root&password=admin";
sqoop找不到MySQL驱动_Sqoop：无法加载mysql驱动程序异常
weixin_33849758的博客
01-18 645
I Installed Sqoop in my local machine. Following are the config information.Bash.bashrc:export HADOOP_HOME=/home/hduser/hadoopexport HBASE_HOME=/home/hduser/hbaseexport HIVE_HOME=/home/hduser/hiveexpo...
Sqoop Could not load db driver class: com.mysql.jdbc.Driver
再难也要坚持的博客
04-07 2603
Could not load db driver class: com.mysql.jdbc.Driver 缺少mysql jar 解决办法： 上传mysql的jar包，移动到sqoop的lib目录下 mv mysql-connector-java-5.1.47.jar /opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/l...
java连接数据库报错`com.mysql.jdbc.Driver‘. This is deprecated及解决方案
weixin_45996656的博客
03-20 2805
java连接数据库报错
JDBC 连接MySQL数据库
huihu_bird的博客
10-06 290
package Connection; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class Te
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值