JDBC: Wrong error code for rejected credentials
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15645 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0, Exasol 7.1.0 |
| Fix Versions | Exasol 8.7.0, Exasol 7.1.16 |
| Resolution Date | 2022-11-01 |
Description
The JDBC driver incorrectly returns code 08004 (SQLSTATE_CONNECTION_REJECTED) when the user enters invalid credentials, and the connection is refused by the server.
Workaround
There is no workaround.
Fix
The JDBC driver returns code 28000 (SQLSTATE_INVALID_AUTH_MODE - invalid authorization specification) if the credentials were rejected by the server. This conforms to the SQL standard.
Changed behavior
The JDBC driver now returns 28000 (SQLSTATE_INVALID_AUTH_MODE - invalid authorization specification) if the credentials were rejected by the server.
