mysql部分

问题1描述

mysql版本升级到5.7.25,警告mysql需要指定ssl链接

WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

原因是MySQL在高版本需要指明是否进行SSL连接。解决方案如下：

#解决办法mysql5.7.25注意点useSSL=true一定紧接在数据库名称之后，否则无效
spring.datasource.url=jdbc:mysql://bdm643975218.my3w.com:3306/bdm643975218_db?useSSL=false&useUnicode=true&amp&characterEncoding=UTF-8&amp;autoReconnect=true

useSSL=false位置

问题2描述

mybatis注解时，采用mybatis 插件生成表的实体类，没用开启驼峰转换，造成变量明与数据库不一致，所有造成get方法找不到

错误提示：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'pluginisActvie' in 'class com.younghare.pojo.Robotinfo'

解决办法
application.properties在数据库逆向时添加配置

# 设为true表示开启驼峰转换
#mybatis.configuration.mapUnderscoreToCamelCase=true

或修改get属性对应方法与数据库配置保持一致

问题3描述

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tk.mybatis.mapper.autoconfigure.MapperAutoConfiguration': Invocation of init method failed; nested exception is tk.mybatis.mapper.MapperException: tk.mybatis.mapper.provider.EmptyProvider中缺少selectOne方法!
原因：通用mapper报这个错，是因为与热部署的插件

<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<optional>true</optional>
</dependency>
解决办法：冲突了，注视这个插件后就好了

问题4描述

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause

解决方案：

select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));