问题描述
### Cause: java.sql.SQLException: ORA-01795: 列表中的最大表达式数为 1000
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-01795: 列表中的最大表达式数为 1000
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLException: ORA-01795: 列表中的最大表达式数为 1000
### The error may exist in com/unicompayment/stimulate/core/dao/xml/StimulateIssueOrderMapper.xml
### The error may involve com.unicompayment.stimulate.core.dao.mapper.StimulateIssueOrderMapper.countByExample-Inline
### The error occurred while setting parameters
### SQL: select count(*) from STIMULATE_ISSUE_ORDER WHERE ( ORDER_RESP_TIME like ? and USER_MOBILE in ( ? , ? , ? ,
问题原因
原因在于Oracle语法限制,in内数量必须小于1000
解决方案
1、进行连表查询
2、分割用OR连接