#配置数据源信息 spring: datasource: driverClassName: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/test #url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&?useUnicode=true&characterEncoding=utf8&useSSL=false(5.0) #url: jdbc:mysql://localhost:3306/test?serverTimezone=Shanghai&?useUnicode=true&characterEncoding=utf8&useSSL=false(6.0) username: root password: root #配置jpa jpa: hibernate: ddl-auto: update properties: hibernate: dialect: org.hibernate.dialect.MySQL5Dialect show-sql: true jackson: serialization: indent_output: true
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.46</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>6.0.6</version> </dependency>
mysql5用的驱动url是com.mysql.jdbc.Driver,mysql6以后用的是com.mysql.cj.jdbc.Driver
如果是mysql版本为6.0以上的com.mysql.jdbc.Driver需要改为com.mysql.cj.jdbc.Driver。jar包需要改为6.0以上的,如果当前mysql版本和jar包不一样会报错,6.0以上的jar包有线程池的功能