-
2018-10-10 10:29:16
把 sql日志贴出来,包括参数日志。
在eclipse控制台会打印出sql语句的。
-
2018-10-10 12:04:47
### Error querying database. Cause: java.sql.SQLException: ORA-00909: 参数个数无效
### The error may exist in file [E:\dowork\code\wjjt_jp\target\jeeplus\WEB-INF\classes\com\jeeplus\modules\sys\mapper\xml\OfficeMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT a.id, a.parent_id AS "parent.id", a.parent_ids, a.area_id AS "area.id", a.code, a.name, a.sort, a.type, a.grade, a.address, a.zip_code, a.master, a.phone, a.fax, a.email, a.remarks, a.create_by AS "createBy.id", a.create_date, a.update_by AS "updateBy.id", a.update_date, a.del_flag, a.useable AS useable, a.primary_person AS "primaryPerson.id", a.deputy_person AS "deputyPerson.id", p.name AS "parent.name", ar.name AS "area.name", ar.parent_ids AS "area.parentIds", pp.name AS "primaryPerson.name", dp.name AS "deputyPerson.name" FROM sys_office a LEFT JOIN sys_office p ON p.id = a.parent_id LEFT JOIN sys_area ar ON ar.id = a.area_id LEFT JOIN sys_user pp ON pp.id = a.primary_person LEFT JOIN sys_user dp ON dp.id = a.deputy_person WHERE a.del_flag = ? AND (a.id = ? OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) AND (a.id IS NULL) AND (a.id = ? OR (a.parent_id = ? AND a.type = '2') OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) OR a.id = ? ORDER BY a.code
### Cause: java.sql.SQLException: ORA-00909: 参数个数无效
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00909: 参数个数无效
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLException: ORA-00909: 参数个数无效
### The error may exist in file [E:\dowork\code\wjjt_jp\target\jeeplus\WEB-INF\classes\com\jeeplus\modules\sys\mapper\xml\OfficeMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT a.id, a.parent_id AS "parent.id", a.parent_ids, a.area_id AS "area.id", a.code, a.name, a.sort, a.type, a.grade, a.address, a.zip_code, a.master, a.phone, a.fax, a.email, a.remarks, a.create_by AS "createBy.id", a.create_date, a.update_by AS "updateBy.id", a.update_date, a.del_flag, a.useable AS useable, a.primary_person AS "primaryPerson.id", a.deputy_person AS "deputyPerson.id", p.name AS "parent.name", ar.name AS "area.name", ar.parent_ids AS "area.parentIds", pp.name AS "primaryPerson.name", dp.name AS "deputyPerson.name" FROM sys_office a LEFT JOIN sys_office p ON p.id = a.parent_id LEFT JOIN sys_area ar ON ar.id = a.area_id LEFT JOIN sys_user pp ON pp.id = a.primary_person LEFT JOIN sys_user dp ON dp.id = a.deputy_person WHERE a.del_flag = ? AND (a.id = ? OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) AND (a.id IS NULL) AND (a.id = ? OR (a.parent_id = ? AND a.type = '2') OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) OR a.id = ? ORDER BY a.code
### Cause: java.sql.SQLException: ORA-00909: 参数个数无效
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00909: 参数个数无效
-
2018-10-10 12:04:59
@蓝色忧郁 ### Error querying database. Cause: java.sql.SQLException: ORA-00909: 参数个数无效
### The error may exist in file [E:\dowork\code\wjjt_jp\target\jeeplus\WEB-INF\classes\com\jeeplus\modules\sys\mapper\xml\OfficeMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT a.id, a.parent_id AS "parent.id", a.parent_ids, a.area_id AS "area.id", a.code, a.name, a.sort, a.type, a.grade, a.address, a.zip_code, a.master, a.phone, a.fax, a.email, a.remarks, a.create_by AS "createBy.id", a.create_date, a.update_by AS "updateBy.id", a.update_date, a.del_flag, a.useable AS useable, a.primary_person AS "primaryPerson.id", a.deputy_person AS "deputyPerson.id", p.name AS "parent.name", ar.name AS "area.name", ar.parent_ids AS "area.parentIds", pp.name AS "primaryPerson.name", dp.name AS "deputyPerson.name" FROM sys_office a LEFT JOIN sys_office p ON p.id = a.parent_id LEFT JOIN sys_area ar ON ar.id = a.area_id LEFT JOIN sys_user pp ON pp.id = a.primary_person LEFT JOIN sys_user dp ON dp.id = a.deputy_person WHERE a.del_flag = ? AND (a.id = ? OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) AND (a.id IS NULL) AND (a.id = ? OR (a.parent_id = ? AND a.type = '2') OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) OR a.id = ? ORDER BY a.code
### Cause: java.sql.SQLException: ORA-00909: 参数个数无效
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00909: 参数个数无效
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLException: ORA-00909: 参数个数无效
### The error may exist in file [E:\dowork\code\wjjt_jp\target\jeeplus\WEB-INF\classes\com\jeeplus\modules\sys\mapper\xml\OfficeMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT a.id, a.parent_id AS "parent.id", a.parent_ids, a.area_id AS "area.id", a.code, a.name, a.sort, a.type, a.grade, a.address, a.zip_code, a.master, a.phone, a.fax, a.email, a.remarks, a.create_by AS "createBy.id", a.create_date, a.update_by AS "updateBy.id", a.update_date, a.del_flag, a.useable AS useable, a.primary_person AS "primaryPerson.id", a.deputy_person AS "deputyPerson.id", p.name AS "parent.name", ar.name AS "area.name", ar.parent_ids AS "area.parentIds", pp.name AS "primaryPerson.name", dp.name AS "deputyPerson.name" FROM sys_office a LEFT JOIN sys_office p ON p.id = a.parent_id LEFT JOIN sys_area ar ON ar.id = a.area_id LEFT JOIN sys_user pp ON pp.id = a.primary_person LEFT JOIN sys_user dp ON dp.id = a.deputy_person WHERE a.del_flag = ? AND (a.id = ? OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) AND (a.id IS NULL) AND (a.id = ? OR (a.parent_id = ? AND a.type = '2') OR a.id IS NULL) AND (a.id = ? OR a.parent_ids LIKE concat(?,?,',%') OR a.id IS NULL) OR a.id = ? ORDER BY a.code
### Cause: java.sql.SQLException: ORA-00909: 参数个数无效
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00909: 参数个数无效