spring-boot引入通用mapper报错
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'permission_name' in 'field list'
### The error may exist in com/wenkang/mapper/PermissionMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,permission_name,url FROM permission
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'permission_name' in 'field list'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'permission_name' in 'field list'] with root cause
引入通用mapper会自动将小驼峰转换成下换线,在mybatis配置:
mybatis-plus:
configuration:
map-underscore-to-camel-case: false
是无效的。默认mybatis是没开启驼峰匹配的,好像。
这是引入通用mapper导致的,你只需要配置如下就OK。
mapper:
style: normal