Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FAQ for the PostgreSQL JDBC Driver Upgrade
What is happening?
We plan to upgrade have upgraded the JDBC driver for the PostgreSQL Snap Pack from v9.4.1207 to v42.7.2 (Java 8). This upgrade will be part of the GA release on August 14, 2024 (Stable release). As a part of this upgrade, the 42.7.2 JDBC driver is bundled with the PostgreSQL Snap Pack as the default JDBC driver.
...
What is the timeline for this upgrade?
This upgrade will be is now available with the Snap Pack version 4postgresupgrade26570
for PostgreSQL and can be manually selected if you want to do early testing before the Latest July release (available on July 10 (Latest release), 2024, and ). This driver upgrade will be part of the GA release on August 14, 2024 (Stable release).
...
Changes in the query in the error messages:
Some error messages will now include the data type for certain values, for example:
Old:
"...where (badId = 1) was aborted:..."
New:
"...where (badId = ('1'::numeric)) was aborted:..."
Improvisations in error messages:
There are some minor text changes to few of the error messages, for example:
Old:
"Hint: No operator matches the given name and argument types."
New:
"Hint: No operator matches the given name and argument type(s)."
The following table lists the additional behavior changes in the Snap Pack:
PostgreSQL Snaps | Scenario | Error/Output from the old (v9.4.1207) JDBC Driver | Error/Output from the new (v42.7.2 (Java 8)) JDBC Driver |
When you provide multiple statements in the SQL Statement field, the Snap fails. | Status: Output message: | Status: Error message: | |
Table columns of the | Output as a string:
| Output message is now in an array:
| |
The various invalid SQL operation scenarios that result in failure include the following (but are not limited to):
| Error: Reason: For example: | Error:
For example: | |
| When the metadata is returned from the Snap’s second output view. | The original number of columns in the input data is displayed in the output. | In Select Snap, the second output view, some new columns are introduced. |
| When the delete condition has an unterminated quote string. | Error message: | Error message: |
When you provide the following query:
| Status : 0 | Status: 5 | |
All PostgreSQL Snaps | When the Dynamic Account has incorrect credentials. | Error : | Error message: |