Loading class `com.mysql.jdbc.Driver'. This is deprecated.

Question

overriding auto.offset.reset to none for executor
2020-02-24 11:10:20,670   WARN --- [main]  org.apache.spark.streaming.kafka010.KafkaUtils(line:66) : overriding executor group.id to spark-executor-11group11
2020-02-24 11:10:20,671   WARN --- [main]  org.apache.spark.streaming.kafka010.KafkaUtils(line:66) : overriding receive.buffer.bytes to 65536 see KAFKA-3135
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.
 

Answer 1

处理：提示信息表明数据库驱动com.mysql.jdbc.Driver'已经被弃用了、应当使用新的驱动com.mysql.cj.jdbc.Driver'

所以，按照提示更改jdbc.properties配置 .com.mysql.jdbc.Driver  改为  com.mysql.cj.jdbc.Drive

 

 

仍存在报错信息

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>
运行结果如下：