; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00909: 引數個數無效
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: 引數個數無效
相關文章
- 解決bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: 無效字元SQLExceptionJavaError字元
- Unknown column ‘name‘ in ‘field list‘ ; bad SQL grammar []; nested exception is com.mysql.jdbc.excepExceptionMySqlJDBC
- MyBatis - java.sql.SQLSyntaxErrorException: ORA-00911: 無效字元MyBatisJavaSQLErrorException字元
- List分頁(SQL引數化2100個 )SQL
- Java對比有引數和無引數Java
- nested exception is java.lang.NoSuchMethodException: 實體類.()ExceptionJava
- vue17自定義指令(有引數,無引數)Vue
- 12.MyBatis學習--對映檔案_引數處理_單個引數&多個引數&命名引數MyBatis
- SQL*Plus Set引數詳解SQL
- Sql Server 的引數化查詢SQLServer
- 抽象SQL引數化查詢VK抽象SQL
- SpringDataJpa列印Sql詳情(含引數)SpringSQL
- web40 無引數rceWeb
- nested exception is io.lettuce.core.RedisConnectionException: Unable to connect to localhost:6379ExceptionRedislocalhost
- 將第一個 sql 語句中的結果作為第二個 sql 的引數值SQL
- 【TUNE_ORACLE】列出返回行數較多的巢狀迴圈(NESTED LOOPS)SQL的SQL參考Oracle巢狀OOPSQL
- { “code”: “-1”, “msg”: “nested exception is org.apache.ibatis.exceptions.TooManyResultsException: ExExceptionApacheBATOOM
- mybatis 的傳入引數如何既有物件又有單個引數MyBatis物件
- 如何從文字檔案讀入 SQL 引數SQL
- java.sql.SQLSyntaxErrorExceptionORA-00911無效字元JavaSQLErrorException字元
- HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGramHTTPAIExceptionSpringFrameworkJDBCSQL
- 『無為則無心』Python函式 — 29、Python變數和引數傳遞Python函式變數
- 什麼是請求引數、表單引數、url引數、header引數、Cookie引數?一文講懂HeaderCookie
- 502bad gateway尋因——php-fpm關鍵引數:max_children和backlogGatewayPHP
- mybatis 傳入多個引數MyBatis
- JS forEach()第二個引數JS
- BIRT 中如何根據引數動態拼接 SQLSQL
- Oracle vs PostgreSQL Develop(23) - PL(pg)sql(引數宣告)OracleSQLdev
- 請求引數為物件,mybatis的sql寫法物件MyBatisSQL
- python疑問5:位置引數,預設引數,可變引數,關鍵字引數,命名關鍵字引數區別Python
- Mybatis(五)--原始碼分析傳入單個list引數和多個list引數寫法MyBatis原始碼
- Swift 使用lexicographicallyprecedes 多個引數排序Swift排序
- 巨集定義跟多個引數
- [寫了一個玩具] 引數注入
- in_array的第3個引數
- c#中DateTime轉字串時碰到無1個引數的過載C#字串
- 一個Java方法能使用多少個引數?Java
- C#通過反射獲取類中的方法和引數個數,反射呼叫方法帶引數C#反射