New JDBC 4.2 Features: executeLargeUpdate

Detail name	Value
Changelog Number	12610
Type	New Feature
Status	Resolved
Fix Versions	Exasol 7.1.3
Resolution Date	2021-11-26

New Feature

The following JDBC 4.2 Features are added:

executeLargeUpdate(String sql, int autoGeneratedKeys)
executeLargeUpdate(String sql, int[] columnIndexes)
executeLargeUpdate(String sql, String[] columnNames)

1. Method: executeLargeUpdate(String sql, int autoGeneratedKeys)

When the method is executed with an SQL query and the parameter autoGeneratedKeys is set to NO_GENERATED_KEYS. The method will return the number of rows affected (Data type: long)  by the query.

If the parameter autoGeneratedKeys is set to values other than NO_GENERATED_KEYS, then the below exception will be generated

Feature not supported - executeLargeUpdate(String sql, RETURN_GENERATED_KEYS)

Reference:

see also executeLargeUpdate

see also no generated keys

2. Method: executeLargeUpdate(String sql, int[] columnIndexes)

When the method is executed with an SQL query and the parameter columnIndexes is set to null or empty array {}. The method will return the number of rows affected (Data type: long)  by the query.

If the parameter columnIndexes is not empty, then the below exception will be generated

Feature not supported - executeLargeUpdate(String sql, int columnIndexes[]) 

Reference:

see also executeLargeUpdate

3. executeLargeUpdate(String sql, String[] columnNames)

When the method is executed with an SQL query and the parameter columnNames is set to null or empty array {}. The method will return the number of rows affected (Data type: long)  by the query.

If the parameter columnNames is not empty, then the below exception will be generated

Feature not supported - executeLargeUpdate(String sql, String columnNames[])

Reference:

see also executeLargeUpdate