IMPORT FROM JDBC: Allow sources without JDBC Connection.rollback() method

Details

Detail name Value
Changelog Number 13751
Type Improvement
Status Resolved
Fix Versions Exasol 8.0.0, Exasol 7.1.7
Resolution Date 2022-03-16

Background

At the end of each IMPORT FROM JDBC statement, Exasol calls the JDBC Connection.rollback() method before closing the connection to the data source to ensure that no persistent changes are made in the data source.

If JDBC Connection.rollback() method is not implemented for the specified driver, it will raise an exception causing the IMPORT to fail.

Improvement

IMPORT FROM JDBC supports sources where JDBC Connection.rollback() is not implemented.