JDBC prepared statement batch execution broken after exception
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8342 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.rc1 |
| Fix Versions | Exasol 6.2.0, Exasol 7.0.0, Exasol 6.1.5 |
| Resolution Date | 2019-07-24 |
Description:
When executing multiple batches in a prepared statement, there can occur an exception the server side, for example a "Data exception". This will break the statement within the JDBC driver and all batches sent after that will be in an undefined state.
How to reproduce:
Insert data into a table using prepared statements and executeBatch. One of the batches should contain some data that will be rejected by the server, for example a too long string. After the exception, all batches will contain broken data and will also cause exceptions.
Workaround:
No malformed data should be sent to the server.
