5.1.47版本的jdbc添加不成功

来源：6-17 实战之统计结果写入数据库(非常重要)

酱汁怪兽

2022-03-16

描述：
在C:\Users\jieqiong\IdeaProjects\spark-log4j\log-ss\pom.xml中，添加5.1.47的jdbc，报错。
图片描述

尝试方式一：
（1）手动将mysql-connector-java-5.1.47.jar，放入C:\Users\jieqiong.m2\repository\mysql\mysql-connector-java\5.1.47目录中。
（2）在主pom.xml中添加5.1.47的依赖。
结果：子pom.xml的依赖，依然无法添加成功。object ForeachRDDNetworkWordCount运行报错是：找不到jdbc

22/03/16 10:23:20 ERROR Executor: Exception in task 0.0 in stage 2.0 (TID 1)
java.sql.SQLException: No suitable driver found for jdbc:mysql:192.168.131.66:3306/jieqiong
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.imooc.bigdata.ss.MySQLUtils $. g e t C o n n e c t i o n (M y S Q L U t i l s . s c a l a : 11) a t c o m . i m o o c . b i g d a t a . s s . F o r e a c h R D D N e t w o r k W o r d C o u n t$ . $a n o n f u n$ main $5 (F o r e a c h R D D N e t w o r k W o r d C o u n t . s c a l a : 141) a t c o m . i m o o c . b i g d a t a . s s . F o r e a c h R D D N e t w o r k W o r d C o u n t$ . $a n o n f u n$ main $5$ adapted(ForeachRDDNetworkWordCount.scala:137)
at org.apache.spark.rdd.RDD. $a n o n f u n$ foreachPartition $2 (R D D . s c a l a : 994) a t o r g . a p a c h e . s p a r k . r d d . R D D .$ anonfun$foreachPartition $2$ adapted(RDD.scala:994)
at org.apache.spark.SparkContext. $a n o n f u n$ runJob $5 (S p a r k C o n t e x t . s c a l a : 2133) a t o r g . a p a c h e . s p a r k . s c h e d u l e r . R e s u l t T a s k . r u n T a s k (R e s u l t T a s k . s c a l a : 90) a t o r g . a p a c h e . s p a r k . s c h e d u l e r . T a s k . r u n (T a s k . s c a l a : 127) a t o r g . a p a c h e . s p a r k . e x e c u t o r . E x e c u t o r$ TaskRunner. $a n o n f u n$ run $3 (E x e c u t o r . s c a l a : 444) a t o r g . a p a c h e . s p a r k . u t i l . U t i l s$ .tryWithSafeFinally(Utils.scala:1377)
at org.apache.spark.executor.Executor $T a s k R u n n e r . r u n (E x e c u t o r . s c a l a : 447) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r . r u n W o r k e r (T h r e a d P o o l E x e c u t o r . j a v a : 1149) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r$ Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

22/03/16 10:23:20 WARN TaskSetManager: Lost task 0.0 in stage 2.0 (TID 1, LAPTOP-IDKAAD44, executor driver): java.sql.SQLException: No suitable driver found for jdbc:mysql:192.168.131.66:3306/jieqiong
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.imooc.bigdata.ss.MySQLUtils $. g e t C o n n e c t i o n (M y S Q L U t i l s . s c a l a : 11) a t c o m . i m o o c . b i g d a t a . s s . F o r e a c h R D D N e t w o r k W o r d C o u n t$ . $a n o n f u n$ main $5 (F o r e a c h R D D N e t w o r k W o r d C o u n t . s c a l a : 141) a t c o m . i m o o c . b i g d a t a . s s . F o r e a c h R D D N e t w o r k W o r d C o u n t$ . $a n o n f u n$ main $5$ adapted(ForeachRDDNetworkWordCount.scala:137)
at org.apache.spark.rdd.RDD. $a n o n f u n$ foreachPartition $2 (R D D . s c a l a : 994) a t o r g . a p a c h e . s p a r k . r d d . R D D .$ anonfun$foreachPartition $2$ adapted(RDD.scala:994)
at org.apache.spark.SparkContext. $a n o n f u n$ runJob $5 (S p a r k C o n t e x t . s c a l a : 2133) a t o r g . a p a c h e . s p a r k . s c h e d u l e r . R e s u l t T a s k . r u n T a s k (R e s u l t T a s k . s c a l a : 90) a t o r g . a p a c h e . s p a r k . s c h e d u l e r . T a s k . r u n (T a s k . s c a l a : 127) a t o r g . a p a c h e . s p a r k . e x e c u t o r . E x e c u t o r$ TaskRunner. $a n o n f u n$ run $3 (E x e c u t o r . s c a l a : 444) a t o r g . a p a c h e . s p a r k . u t i l . U t i l s$ .tryWithSafeFinally(Utils.scala:1377)
at org.apache.spark.executor.Executor $T a s k R u n n e r . r u n (E x e c u t o r . s c a l a : 447) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r . r u n W o r k e r (T h r e a d P o o l E x e c u t o r . j a v a : 1149) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r$ Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)