executeBatch() return SUCCESS_NO_INFO values - version 8.0.26
Posted by: Gil Amsalem
Date: November 17, 2021 04:52PM


I am using jdbi3-core version 3.21.0 with J connector 8.0.26.

I am using PreparedBatch, to execute batch INSERT query with multiple rows.
All rows are written as expected, but the response from the executeBatch() method is: [-2, -2, -2, -2, -2]

When I execute a standard INSERT query (not batch), the return value is correct.
The query which I use in my batch example is:
INSERT INTO mytable (col1,col2,col3) VALUES (:val1,:val2,:val3)

Any idea why do I get SUCCESS_NO_INFO and not the correct value representing the affected rows?

Options: ReplyQuote

Written By
executeBatch() return SUCCESS_NO_INFO values - version 8.0.26
November 17, 2021 04:52PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.