类JPA定制mysql中日志打印

在类JPA自定义框架中,使用mysql 数据库,开发环境可以考虑调整driver:

jdbc.driver=net.sf.log4jjdbc.DriverSpy

配置:

spring.datasource.driver-class-name=net.sf.log4jdbc.DriverSpy
spring.datasource.url=jdbc:log4jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8

使用时需引入包:

<!-- log4jdbc -->
<dependency>
    <groupId>com.googlecode.log4jdbc</groupId>
    <artifactId>log4jdbc</artifactId>
    <version>1.2</version>
    <scope>runtime</scope>
</dependency>

注意: 此driver 性能较差, 压测环境和生产环境需使用其他driver:

com.mysql.cj.jdbc.Driver

配置:

# 数据库配置
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root   #你本地的数据库用户名
    password: 123456 #你本地的数据库密码
    url: jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2b8&allowPublicKeyRetrieval=true

否者可能会出现概率不定期服务器服务断数据库连接,并出现报错:

CommunicationException: Communications link failure 

The last packet successfully received from the serve was 20000 milliseconds ago.