JDBC Technical Notes

Technical Notes for JDBC component

---

Changelog

2.5.12 (March 18, 2026)

• Updated Sailor to 5.0.1 to address the issue when the component failed to execute when there was an array in any of the preceding steps passthrough data.
• Fix issue in the Select trigger.
• Improvements for Select trigger: support case-insensitive %%EIO_LAST_POLL%% placeholder, handle quoted placeholders, and support date-only/high-precision polling values.
• Fix issue in the Get rows polling trigger.
• Improved Date/Timestamp parsing in Get rows polling trigger to support fractional seconds (up to 9 digits) and date-only formats (e.g., YYYY-MM-DD).
• Enhanced snapshot accuracy and safety by using direct ResultSet.getTimestamp() access, preventing string-parsing errors during polling.
• Fix MySQL timestamp comparison in polling trigger by using CONVERT(?, DATETIME(3)) for exact precision matching.
• Fix JsonObjectBuilder reuse bug in getRowsExecutePolling method to prevent data corruption.
• Fix maxPollingValue initialization in GetRowsPollingTrigger to ensure accurate snapshot updates.
• Fix: Get Rows Polling Trigger now correctly defaults to Unix Epoch (1970-01-01) for the first execution.
• Docs: Updated Select Trigger documentation to clarify that it defaults to today’s midnight.
• Tests: Added unit test cases to verify trigger fallback behaviors for missing or invalid inputs.
• Fix Incorrect SQL Parameter Binding Order in NewSelectAction.

2.5.11 (November 18, 2025)

• Replaced the Oracle JDBC driver (ojdbc) from 6 to 8 (ojdbc8:21.5.0.0)
• Updated Sailor version to 5.0.0

2.5.10 (June 27, 2025)

• Fixed the issue with aliases in the Select Query action

2.5.9 (August 01, 2024)

• Updated Sailor version to 4.0.3

2.5.8 (July 09, 2024)

• Updated Sailor version to 4.0.2
• Bumped Postgresql library to 42.5.5
• Bumped MySQL library to 8.4.0

2.5.7 (July 07, 2023)

• Updated Sailor version to 4.0.1

2.5.6 (November 04, 2022)

• Added limitations in readme about custom timezone behavior
• Update Sailor version to 3.5.0

2.5.5 (May 20, 2022)

• Set default connectionTimeZone parameter for MYSQL to SERVER

2.5.4 (May 11, 2022)

• Made an automated vulnerability check run in CI/CD

2.5.3 (May 06, 2022)

• Add an automated vulnerability check

2.5.2 (April 08, 2022)

• Updated the Sailor version to 3.3.9

2.5.1 (November 26, 2021)

• Updated the sailor version to 3.3.6
• Reduced the size of component icon file

2.5.0 (October 1, 2021)

• Add New Select action
• Deprecate old Select action

2.4.5 (September 1, 2021)

Open only one connection pool per one execution and reuse it

2.4.4 (August 12, 2021)

• Remove dependencyCheckAnalyze task

2.4.3 (February 12, 2021)

• Update sailor version to 3.3.2

2.4.2 (November 20, 2020)

• Upgrade sailor to 3.3.1
• Annual audit of the component code to check if it exposes a sensitive data in the logs
• Annual dependencies vulnerabilities audit

2.4.1 (October 21, 2019)

• Add rebound mechanism in case of deadlocks for actions: Insert, UpsertByPK, DeleteByPK

2.4.0 (October 17, 2019)

• Add Custom Query action
• Add rebound mechanism in case of deadlocks for actions: Insert, UpsertByPK, DeleteByPK

2.3.1 (September 30, 2019)

• Add placeholder to MySQL schemas list

2.3.0 (September 25, 2019)

• Add new action Insert

2.2.0 (August 28, 2019)

• Add support Configuration properties for DB connection
• Enable circleci

2.1.0 (2019-07-22)

• Add Execute stored procedure action

2.0.1 (2019-06-24)

• Fix error logging for generating metadata of Select action

2.0.0 (2018-09-19)

• Add Select trigger

• Add Get rows polling trigger

• Add Select action
• Add Lookup by primary key action
• Add Upsert by primary key action (for migration)

• Add Delete by primary key action

• Remove CreateOrUpdateRecord action

• Fix issue in postgresql - getDate(null)
• Fix null values as input for select

Completeness Matrix

Here is the JDBC Component Completeness Matrix.