Throw explicit exception when trying to use batched execution with prepared statement with generated keys option [JDBC451]

[firebird-issue-importer]

Submitted by: @mrotteveel

Is related to JDBC452

Using batch execution with Statement.RETURN_GENERATED_KEYS (or one of the other generated keys options) in Jaybird 2.2 results in:

Exception in thread "main" java.sql.BatchUpdateException
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeBatch(AbstractPreparedStatement.java:941)
at nl.lawinegevaar.fb.TestIdentityTable.main(TestIdentityTable.java:32)

We should throw an explicit exception that batch execution with generated keys is not supported (maybe already in addBatch()?)

Commits: 6b9c43c bdc6c4c

[firebird-issue-importer]

Commented by: @mrotteveel

Only fix in 2.2.

[firebird-issue-importer]

Modified by: @mrotteveel

Fix Version: Jaybird 2.2.12 [ 10781 ]

[firebird-issue-importer]

Modified by: @mrotteveel

Link: This issue is related to JDBC452 [ JDBC452 ]

[firebird-issue-importer]

Commented by: @mrotteveel

Calls to addBatch() and executeBatch() on a FBPreparedStatement instance now throw a FBDriverNotCapableException when the statements was prepared with one of the generated keys options.

[firebird-issue-importer]

Modified by: @mrotteveel

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

[firebird-issue-importer]

Modified by: @mrotteveel

status: Resolved [ 5 ] => Closed [ 6 ]