JDBC - Reading EXAResultSet changes the cursor status
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10506 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.2.0, Exasol 7.0.rc1 |
| Fix Versions | Exasol 7.0.0, Exasol 6.2.9 |
| Resolution Date | 2020-07-30 |
Description
In JDBC, the EXAResultSet class has a toString method. This puts the content of the result set into a string by reading the whole result with JDBC methods.
The reading of the result changes the cursor status and the user is not aware of this. This can cause problems in reading the result and also makes debugging EXAResultSet related issues very hard.
Workaround
There is no workaround.
Fix
The toString() method of the EXAResultSet class will be fixed so the cursor position is not changed anymore. Also it will display only the part of the result set that is in memory at that time, to prevent performance issues.
