Drivers will run legacy metadata queries in snapshot mode
Details
| Detail name | Value |
|---|---|
| Changelog Number | 16161 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.19, ODBC 24.0.0, JDBC 24.0.0, ADO.NET 24.0.0 |
| Resolution Date | 2023-03-21 |
Background
The Exasol JDBC, ADO.NET and ODBC drivers can query interface-specific metadata queries. There are two ways to query metadata from the server in these drivers: using specific metadata commands and using SQL Statements (legacy mode). Sometimes, a user may need to use the legacy mode, which is in most cases slower.
Improvement
Legacy metadata queries using SQL now run in “snapshot mode”, which prevent transaction conflicts caused by these queries. For more information, see Snapshot Mode.
