Concurrently open statements: [message #1864618] |
Thu, 28 March 2024 15:14 |
Pradeep KC Messages: 1 Registered: March 2024 |
Junior Member |
|
|
I am working on migrating an existing Spring application from Eclipselink version 2.5.2 to 4.0.2. In this application, there is a API in which the data is saved using the JpaRespository to the data, and once the loop ends it does a repo.flush(). Depending on the data, the loop creates the statement for inserting thousand of records to the database, if this number is huge, then I am getting the below error from the DB2 database:
[INFO] [err] ***** Out of Package Error Occurred (2024-03-28 20:34:23.76) *****
[INFO]
[INFO] Exception stack trace:
[INFO] com.ibm.db2.jcc.am.SqlException: NULLID.SYSLH103 0X5359534C564C3031
Concurrently open statements:
[INFO] 1. SQL string: INSERT INTO TEST.TABLE1 (CTRYCODE) VALUES (?)
[INFO] Number of statements: 1338
I suspect that the statement caching is not working as expected. Can someone provide any more information? I do have the property eclipselink.jdbc.cache-statements set to true.
The application on the previous version of eclipselink was working fine in these scenarios. Has anything changed in newer version of eclipselink which could cause this?
Let me know if I need to share any more information.
|
|
|
Powered by
FUDForum. Page generated in 0.03307 seconds