not supported jdbc statement function 'executeBatch'

[laura098]

The batch update function of tibco is not supported in the citrus jdbc adapter. This function is needed for all inserts that affect more than one row. And all updates which gets a list of different where-clauses.
Please see the attached file for some screenshots.

Best Regards,
Laura
JDBC-Batch Update-Bug.docx

[svettwer]

Hi!

Yes this is absolutely the case. We've just implemented a set of driver functionality with the idea of extending the driver over time and on demand.

Thx for reporting your demand on this feature! 👍

BR,
Sven

[svettwer]

Further refinement information:

The interface for batch functionality includes three methods:

1. void addBatch( String sql ) throws SQLException;
2. void clearBatch() throws SQLException;
3. int[] executeBatch() throws SQLException;

executeBatch() requires some more implementation on driver side to ensure that the updated rows count is simulated accurately. The exchanged Citrus JDBC messages contain the amount of affected rows, so that there should be minimum changes required on server side if any.

[svettwer]

closed in favor of citrusframework/citrus-db#36 as the implementation effort goes into the driver