jOOQ Library and JDBC Driver Upgrades for Database Snaps

The jOOQ library for the Database Snaps is being upgraded from v3.9.1 to 3.17.x. This upgrade is happening phase-wise as it involves extensive testing of all Database Snaps. The JDBC driver upgrades for all the Database Snaps are also done phase-wise. The table below informs you about the timelines for the upgrade and other details, such as behavior changes in the Snaps as a result of the jOOQ upgrade.

Given the variety of custom JAR files in use, we cannot test against each one. So we recommend that you test your pipelines in your environment to ensure compatibility and functionality with your specific custom JDBC drivers before planning the jOOQ upgrade.

Snap Pack	Upgrade done	Deployment Date	Snap Pack Version		Related Documents
Snap Pack	Upgrade done	Deployment Date	Latest	Stable	Related Documents
MySQL Server	✔		-	`main25112`	No behavior changes.
Redshift	✔		-	`main23721`	No behavior changes.
Oracle	✔	October 13, 2024	`434patches23000`	`main23721`	Oracle jOOQ and JDBC Driver Upgrade
PostgreSQL	✔	January 12, 2023	`431patches19454`	`main19844`	PostgreSQL JDBC Driver Upgrade
SAP HANA	✔	-	-	`main26341`	No behavior changes.
Snowflake	✖️	January 12, 2023	`431patches19454`	`main19844`	No behavior changes.
SQL Server	✔	June 8, 2023	`433patches21386`	`main25112`	FAQ for SQL Server JDBC Driver Upgrade
Teradata	✖️	June 10, 2024	4.37 patches	`437patches26471`	No behavior changes.
Vertica	✖️	-	4.37 patches	4.38	Vertica jOOQ Upgrade

The latest jOOQ library includes the following benefits:

Query SQL statements in a type-safe and fluent API style.
Supports SQL dialect-specific data types and advanced SQL features.
Integrates seamlessly with various database connection pools.
Provides native support for Snowflake and Timestamp with Time Zone capabilities.

For any other specific queries, contact support@snaplogic.com