13-Sep-2018 14:11:27.049 严重 [http-nio-8080-exec-6] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [SpringMVC] in context with path [/gbs_dm] threw exception [Request processing failed; nested except
ion is org.springframework.dao.DataIntegrityViolationException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous
### The error may exist in class path resource [com/data/mapping/TSysPermissionMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select a.* from t_sys_permission a inner join t_sys_role_permission b on a.PERMISSION_NO=b.PERMISSION_NO inner join t_sys_role c on b.ROLE_NO=c.ROLE_NO inner join t_sys_user_role d on c.ROLE_NO=d.ROLE_NO where d.USER_NO='dsa' a
nd DELETE_FLAG=0 order by a.PERMISSION_NO
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous
; SQL []; Column 'DELETE_FLAG' in where clause is ambiguous; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous
at sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
2 个回复
luohuanfeng
赞同来自:
l18586854856
赞同来自:
ion is org.springframework.dao.DataIntegrityViolationException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous
### The error may exist in class path resource [com/data/mapping/TSysPermissionMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select a.* from t_sys_permission a inner join t_sys_role_permission b on a.PERMISSION_NO=b.PERMISSION_NO inner join t_sys_role c on b.ROLE_NO=c.ROLE_NO inner join t_sys_user_role d on c.ROLE_NO=d.ROLE_NO where d.USER_NO='dsa' a
nd DELETE_FLAG=0 order by a.PERMISSION_NO
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous
; SQL []; Column 'DELETE_FLAG' in where clause is ambiguous; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'DELETE_FLAG' in where clause is ambiguous
at sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)