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.