； bad SQL grammar []； nested exception is java.sql.SQLSyntaxErrorException: ORA-00909: 参数个数无效

╰半夏微凉° 2022-12-25 15:58 75阅读 0赞

2020-12-02 18:35:41.035 DEBUG 7464 --- \[WT-EventQueue-0\] c.e.i.d.m.M.convertRuleQuery             : ==>  Preparing: select \* from (select ROWNUM rn, tar.\* from( select ID, DEVICE\_MODEL, CABLE\_MODEL, REMARK, CONN\_AWG, CONN\_MANU from IDS\_MODEL\_TRAN\_RULE rule where UPPER(DEVICE\_MODEL) like UPPER(concat('%',?,'%')) or UPPER(CABLE\_MODEL) like UPPER(concat('%',?,'%')) order by DEVICE\_MODEL) tar where ROWNUM < ? ) WHERE rn >= ?   
2020-12-02 18:35:41.037 DEBUG 7464 --- \[WT-EventQueue-0\] c.e.i.d.m.M.convertRuleQuery             : ==> Parameters: 9(String), 9(String), 21(Long), 1(Long)  
org.springframework.jdbc.BadSqlGrammarException:   
\#\#\# Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00909: 参数个数无效

\#\#\# The error may exist in com/esoon/ids/dao/mapper/ModelConvertRuleMapper.xml  
\#\#\# The error may involve defaultParameterMap  
\#\#\# The error occurred while setting parameters  
\#\#\# SQL: select \* from (select ROWNUM rn, tar.\* from(         select ID, DEVICE\_MODEL, CABLE\_MODEL, REMARK, CONN\_AWG, CONN\_MANU from IDS\_MODEL\_TRAN\_RULE rule                        where UPPER(DEVICE\_MODEL) like UPPER(concat('%',?,'%'))             or UPPER(CABLE\_MODEL) like UPPER(concat('%',?,'%'))                    order by DEVICE\_MODEL) tar                            where ROWNUM < ? )                 WHERE rn >= ?  
\#\#\# Cause: java.sql.SQLSyntaxErrorException: ORA-00909: 参数个数无效

; bad SQL grammar \[\]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00909: 参数个数无效