; 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
- SQL引數資料型別text對於replace函式的引數1無效SQL資料型別函式
- MyBatis - java.sql.SQLSyntaxErrorException: ORA-00911: 無效字元MyBatisJavaSQLErrorException字元
- 引數資料型別 sql_variant 對於 like 函式的引數 1 無效。資料型別SQL函式
- 每個月的sql引數配置SQL
- Java對比有引數和無引數Java
- Oracle 處理無效物件數Oracle物件
- vue17自定義指令(有引數,無引數)Vue
- 12.MyBatis學習--對映檔案_引數處理_單個引數&多個引數&命名引數MyBatis
- Asp.net報錯彙總:回發或回撥引數無效ASP.NET
- nested exception is IncompleteElementException: Could not find parameter mapException
- SQL 掃描引數(SARG)SQL
- List分頁(SQL引數化2100個 )SQL
- kettle 引數——變數引數和常量引數變數
- nested exception is java.lang.NoSuchMethodException: 實體類.()ExceptionJava
- Initialization of bean failed; nested exception is java.lang.StackOverflowErrorBeanAIExceptionJavaError
- SQL*Plus Set引數詳解SQL
- pl/sql中的引數模式SQL模式
- mysql Sql引數用?而不用@MySql
- SQL SERVER 引數化選項SQLServer
- 隱藏引數查詢sqlSQL
- SQL Server效能分析引數 (轉)SQLServer
- web40 無引數rceWeb
- SQL Server SQL效能優化之引數化SQLServer優化
- javascript bind()第一個引數以後引數介紹JavaScript
- SQL Server-儲存過程(Procedure),帶入引數和出引數SQLServer儲存過程
- Sql Server 的引數化查詢SQLServer
- 抽象SQL引數化查詢VK抽象SQL
- 淺析SQL Server效能分析引數SQLServer
- 【SQL 效能優化】引數設定SQL優化
- SQLBulkOperations及陣列作引數的SQLSQL陣列
- SQL Server 的max degree of parallelism引數SQLServerParallel
- oracle兩個 retention 引數Oracle
- 兩個引數設定
- JavaScript replace()第二個引數為函式時的引數JavaScript函式
- mybatis 的傳入引數如何既有物件又有單個引數MyBatis物件
- 給一個介面傳遞引數,並接收返回的引數