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

bug反馈 未结 3 195
喜之郎
喜之郎 VIP3 2018-10-10 10:24:20
收藏
产品:ani 版本:2.2
img[/userfiles/fly/434742ba4f03495e82fe015bc25af32e/files/1539138182582.] 系统内部错误. 错误信息: ### 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: 参数个数无效 ---------------------------------------------------------------- 普通管理员账号登陆,点击 机构管理 报错 admin登录 页面正常,但是页面内按钮点击全部失效。 oracle 数据库
回帖
  • 2018-10-10 10:29:16
    把 sql日志贴出来,包括参数日志。 在eclipse控制台会打印出sql语句的。
    0 回复
  • 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 回复
  • 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 回复