TIMESTAMP data in prepared statements and IMPORT/EXPORT may cause session termination
Details
| Detail name | Value |
|---|---|
| Changelog Number | 22949 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.32.0 |
| Fix Versions | Exasol 2025.1.2, Exasol 2025.2.0 |
| Resolution Date | 2025-08-20 |
Problem
When reading TIMESTAMP or TIMESTAMP WITH LOCAL TIME ZONE column data from an older driver (see details below) while executing a prepared statement, the session could terminate leading to an error message such as the following.
ETL-4220: Closing prepared SQL statement failed. [Socket error. Connection interrupted. sslreadtimeout: connection closed by remote host
ETL-4220: Closing prepared SQL statement failed. [Database server not connected.]
Note: EXA IMPORT/EXPORT statements may also be affected if one Exasol instance has version 8.32+ and the other has a version before 8.32.
Affected driver versions
All drivers released before the nonaffected versions (see below) could trigger the issue.
Nonaffected driver versions
The following drivers will not trigger the issue.
- ODBC 24.2.0+
- SDK 24.2.0+
- JDBC 24.2.0+
- ADO.NET 24.2.0+
- All drivers using WebSocket API v5+
Workaround
JDBC IMPORT/EXPORT can be used as a workaround if the non-8.32+ Exasol instance uses a nonaffected JDBC driver (see above).
Fix
The issue is fixed such that older drivers (see above) can not cause this issue.