Overview
We plan to upgrade the JDBC driver for the PostgreSQL Snap Pack from v9.4.1207 to v42.7.2 (Java 8) <TBD>. As a part of this upgrade, the 42.7.2 JDBC driver is bundled with the PostgreSQL Snap Pack as the default JDBC driver.
Behavior Changes
This driver upgrade will likely result in specific behavior changes in the Snap Pack. These changes are for status codes and success and failure messages. This table lists these changes:
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 message:
| Output message:
| |
When the input value provided for a column is invalid for the column type. | Error Message: Reason:
| Error Message: Reason: | |
| 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, 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 : | |
All PostgreSQL Snaps | When the Dynamic Account has incorrect credentials. | Error : | Error message: |
FAQ for upgrading the PostgreSQL JDBC Driver from v9.4.1207 to v42.7.2 (Java 8)
What is happening?
We plan to upgrade the JDBC driver for the PostgreSQL Snap Pack shortly from v9.4.1207 to v42.7.2 (Java 8). As a part of this upgrade, the v42.7.2 (Java 8) JDBC driver is bundled with the PostgreSQL Snap Pack as the default JDBC driver.
Why are we upgrading the PostgreSQL driver?
To improve security, performance, stability, and reliability.
What is the timeline for this upgrade?
This upgrade is available as a stable upgrade on August 14th, 2024.
Will I be impacted?
Yes, if you use the default version, you will be impacted. The impact might be minimal if you use the latest driver or a higher version than the v42.7.2 (Java 8) JDBC driver.
To check the version of the current JAR file that you are using, refer to PostgreSQL's latest versions.
To know the JAR file that is in use, follow these steps:
Open the JAR file using a ZIP utility or a JAR viewer tool.
Look for the
META-INF/MANIFEST.MF
file in the JAR and check the version.
Do I need to reconfigure my accounts?
You do not have to reconfigure your account settings or drivers; the account can remain as-is to work with the latest driver. However, if you currently use the default version and want to revert to the previous version behavior, we recommend you use the postgres 9.4.1207.jar
.
How do you override the behavior changes?
Use the postgres 9.4.1207.jar
from v9.4.1207 to maintain the same behavior as before the driver upgrade.