系统设置--机构管理，报错

ZDS222 VIP3 2018-10-10 10:24:20

收藏

• 

  蓝色忧郁 VIP5

  2018-10-10 10:29:16
  把 sql日志贴出来，包括参数日志。 在eclipse控制台会打印出sql语句的。
  0 回复
• 

  ZDS222 VIP3 (楼主)

  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: 参数个数无效
  0 回复
• 

  ZDS222 VIP3 (楼主)

  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: 参数个数无效
  0 回复