SpringBoot2.x踩坑集合第二弹

一、Failed to bind properties under ‘spring.datasource’ to javax.sql.DataSource

看的是尚硅谷的视频，springboot整合druid数据源时产生的问题：

参考：https://blog.csdn.net/xingkongtianma01/article/details/81624313

导入log4j的依赖或者删除配置文件中的log4j即可。

二、连接数据库出现The server time zone value ‘�й���׼ʱ��’ is unrecogni等问题的解决方案

这个问题和mysql驱动版本太高有关，按照如下修改连接配置即可：

    driver-class-name: com.mysql.cj.jdbc.Driver 
    url: jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC

三、SpringBoot2.x版本自动建表

参考：https://blog.csdn.net/weixin_41334434/article/details/90380540

• 指定脚本路径：classpath:sql/department.sql
• initialization-mode: always

spring:
  datasource:
    #   数据源基本配置
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC
    type: com.alibaba.druid.pool.DruidDataSource
    #   数据源其他配置
    initialSize: 5
    minIdle: 5
    maxActive: 20
    maxWait: 60000
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
    filters: stat,wall,log4j
    maxPoolPreparedStatementPerConnectionSize: 20
    useGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
    schema:
      - classpath:sql/department.sql
      - classpath:sql/employee.sql
    initialization-mode: always

四、Springboot与Mybatis整合相关配置问题（以驼峰命名为例）

参考：https://www.jianshu.com/p/1507a47f43ac

【配置properties或yml】

#application.yml
mybatis:
  configuration:
    map-underscore-to-camel-case: true

【配置Customizer】

@org.springframework.context.annotation.Configuration
public class MyBatisConfig {

    @Bean
    public ConfigurationCustomizer configurationCustomizer(){
        return new ConfigurationCustomizer() {
            @Override
            public void customize(Configuration configuration) {
                configuration.setMapUnderscoreToCamelCase(true);
            }
        };
    }
}