Ask Your Question
1

What is the solution for resolving the error ORA-01795, which indicates that the maximum limit of 1000 expressions in a list has been exceeded while updating rows with Spring Integration's jdbc inbound channel adapter?

asked 2021-10-27 11:00:00 +0000

ladyg gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2021-04-27 15:00:00 +0000

huitzilopochtli gravatar image

One solution for resolving the error ORA-01795 while updating rows with Spring Integration's jdbc inbound channel adapter is to divide the list of expressions into batches of 1000 or less and execute the update query for each batch. This can be done by splitting the list into smaller lists using Java code and executing the update query in a loop for each batch. Another solution is to increase the limit of expressions in the Oracle database by modifying the MAXINLIST parameter in the initialization file. However, this solution is not recommended as it can have adverse effects on the performance of the database.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-10-27 11:00:00 +0000

Seen: 16 times

Last updated: Apr 27 '21