Sqoop问题已解决：连接数据库报错 javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disab-优快云博客

本文链接：https://blog.youkuaiyun.com/zzzzzzz_77/article/details/146917186

在学习有关大数据的知识中，使用sqoop连接数据库发生异常，现在问题已解决，做一下经验总结。

以下是我遇到的错误：

1.运行报错java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver：

[king@Hadoop102 lib]$ sqoop list-databases --connect jdbc:mysql://hadoop102:3306 --username root --password 123456
Warning: /opt/module/sqoop-1.4.6/../hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /opt/module/sqoop-1.4.6/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /opt/module/sqoop-1.4.6/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
2025-04-01 16:24:28,775 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
2025-04-01 16:24:28,804 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
2025-04-01 16:24:28,893 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
2025-04-01 16:24:28,894 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver
java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver
   at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:856)
   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: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)

解决办法：提示我没有监测到driver，但是我已经把驱动放到/lib目录中，检查了一下版本发现mysql-connector版本是5.1.37

2.于是替换版本为mysql-connector-java-5.1.47，此时又报错误：

2025-04-01 16:46:36,952 ERROR manager.CatalogQueryManager: Failed to list databases
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)