.. _jdbc_connector_changelog: Changelog ========= Version 5.4.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-761 `_ - CC-7414: Fix SqlServer column converter infinite loop & add column converter tests * `PR-757 `_ - CC-7332: Changed one log message from INFO to DEBUG to reduce verbocity * `PR-750 `_ - CC-7265: Support SQL Server DateTimeOffset * `PR-752 `_ - CC-7265: Add support for SQL Server DateTimeOffset type * `PR-727 `_ - CC-6773: Abort source task if all columns were not converted correctly. * `PR-724 `_ - CC-6747: Replace static mocking for the CachedConnectionProvider * `PR-677 `_ - Fix `ERROR Graceful stop of task failed` * `PR-686 `_ - MINOR: Upgrade PostgreSQL jdbc driver to most recent bugfix release (9.4.1212) * `PR-655 `_ - CC-4946: changing log msgs on filtering and avoiding frequently retrying tasks when no tables exist * `PR-672 `_ - Change TableQuerier log to use real class name for file JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-759 `_ - CC-7382: use true/false as default values for boolean type * `PR-728 `_ - MINOR: Expose SinkRecordField schema to database dialects * `PR-706 `_ - MINOR: Avoid NPE when columns cannot be described * `PR-686 `_ - MINOR: Upgrade PostgreSQL jdbc driver to most recent bugfix release (9.4.1212) * `PR-673 `_ - SqlServerDialect uses varchar(900) for primary key as string type * `PR-605 `_ - Fix PostgreSqlDatabaseDialect to generate proper UPSERT queries when no non-key columns are present Version 5.3.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-642 `_ - CC-4423 Remove semicolon from Db2 dialect timestamp query. * `PR-628 `_ - Use Java 7 to validate timezones. JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-663 `_ - MINOR: Remove the final keyword from JdbcSinkConnector. * `PR-641 `_ - CC-349: Add delete support for sink. * `PR-642 `_ - CC-4423 Remove semicolon from Db2 dialect timestamp query. * `PR-628 `_ - Use Java 7 to validate timezones. Version 5.2.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-612 `_ - CC-3812: Sqlite timestamp parse error * `PR-529 `_ - Update the SQL Server dialect to properly retrieve auto incremented column information. * `PR-519 `_ - Fix UPDATE WHERE with multiple keyColumns * `PR-505 `_ - Added db.timezone setting JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-612 `_ - CC-3812: Sqlite timestamp parse error * `PR-529 `_ - Update the SQL Server dialect to properly retrieve auto incremented column information. * `PR-519 `_ - Fix UPDATE WHERE with multiple keyColumns * `PR-505 `_ - Added db.timezone setting Version 5.1.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-535 `_ - CC-3414: Changed PostgreSQL dialect to use BYTEA rather than BLOB * `PR-459 `_ - Fix checkstyle to pass on 8.5 after upgrade from 6.19 JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-535 `_ - CC-3414: Changed PostgreSQL dialect to use BYTEA rather than BLOB * `PR-527 `_ - MINOR Add log statements to debug different flush paths * `PR-530 `_ - CC-3069: Corrected DB2 and Derby upsert statements Version 5.0.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-438 `_ - Fail if the filtered tables list has duplicates based on unqualified table name * `PR-436 `_ - CC-2116: Fix offsets compatibility * `PR-431 `_ - CC-2220: Parse to get the actual table name to avoid double prefixing * `PR-428 `_ - CC-2139: Moved the call to set the fetch direction out of generic dialect * `PR-333 `_ - CC-1193: Refactored with a new dialect framework for DBMS-specific behavior * `PR-416 `_ - CC-2043: Update pom.xml to target Java 8 JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-431 `_ - CC-2220: Parse to get the actual table name to avoid double prefixing * `PR-428 `_ - CC-2139: Moved the call to set the fetch direction out of generic dialect * `PR-333 `_ - CC-1193: Refactored with a new dialect framework for DBMS-specific behavior * `PR-416 `_ - CC-2043: Update pom.xml to target Java 8 Version 4.1.2 ------------- No changes Version 4.1.1 ------------- No changes JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-392 `_ - CC-918 Add |kconnect-long| Maven plugin to build * `PR-396 `_ - CC-1843: Add config option for extended handling of numeric data type JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-392 `_ - CC-918 Add |kconnect-long| Maven plugin to build * `PR-399 `_ - CC-1852: Be less restrictive in JDBC URL validation * `PR-400 `_ - CC-1878: Allow for case differences while finding missing columns Version 4.1.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-351 `_ - CC-1366: close ResultSets and Statements during shutdown * `PR-331 `_ - add a note about SSL with JDBC * `PR-319 `_ - get current timestamp on all DB2 versions - reopening from k1th/master JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-331 `_ - add a note about SSL with JDBC * `PR-306 `_ - Log out actual sql exceptions (fix for #291) Version 4.0.1 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-331 `_ - add a note about SSL with JDBC * `PR-319 `_ - get current timestamp on all DB2 versions - reopening from k1th/master JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-319 `_ - get current timestamp on all DB2 versions - reopening from k1th/master Version 4.0.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-295 `_ - Remove unused imports * `PR-288 `_ - Remove unnecessary surefire configuration overrides. * `PR-287 `_ - CC-1112: Use common pom as parent and fix checkstyle issues. * `PR-212 `_ - Fixed issue #211 - get current timestamp on DB2 UDB for AS/400 * `PR-203 `_ - Issue #198: Improved the JdbcSourceConnector to retry JDBC connection when needed on startup JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-295 `_ - Remove unused imports * `PR-288 `_ - Remove unnecessary surefire configuration overrides. * `PR-287 `_ - CC-1112: Use common pom as parent and fix checkstyle issues. * `PR-212 `_ - Fixed issue #211 - get current timestamp on DB2 UDB for AS/400 * `PR-250 `_ - Fix typo (dd -> add) Version 3.3.1 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-293 `_ - Fix source connector start/stop test * `PR-285 `_ - Add upstream project so build are triggered automatically * `PR-273 `_ - CC-1065 Source connector’s recommender uses table type filter and caches results * `PR-272 `_ - CC-1064 Corrected the table name recommender to always close the JDBC connection JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~~~ No changes Version 3.3.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ No changes JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-188 `_ - Add rpm build to lifecycle. * `PR-195 `_ - Statement.SUCCESS_NO_INFO should be treated in BufferedRecords.flush. * `PR-202 `_ - HP Vertica dialect. * `PR-205 `_ - JDBC Sink Connector - Add insert.mode = UPDATE, that generates only update queries. Version 3.2.2 ------------- No changes Version 3.2.1 ------------- No changes Version 3.2.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-156 `_ - CC-348: Separate username & password config for JDBC source connector * `PR-155 `_ - Switch RST generation to ConfigDef.toEnrichedRst() available against 0.10.2 * `PR-154 `_ - Re-check stop flag before continuing after sleep * `PR-167 `_ - Connection.isValid() expects seconds not milliseconds * `PR-175 `_ - Use UTC Calendar when binding date/times in sink; fix thread-unsafe usage of UTC_CALENDAR in TimestampIncrementingTableQuerier * `PR-169 `_ - Widen schema types for unsigned numeric types. JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ * `PR-168 `_ - Change default MySQL Schema.Type.TIMESTAMP mapping from TIMESTAMP to DATETIME * `PR-171 `_ - CC-432: Missing PreparedStatement.close() * `PR-180 `_ - SqlServerDialect's upsert query placeholders should be in the order keyCols*, cols* Version 3.1.1 ------------- No changes Version 3.1.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-148 `_ - Update licenses, tweaking some dependency scopes, files to include in packaging, and ensuring the create-licenses scope can run cleanly without extra manual steps. * `PR-144 `_ - CC-263: Prevent retrying queries with a broken connection * `PR-140 `_ - CC-331: Config option doc updates * `PR-129 `_ - CC-311: support for Decimal logical type as incrementing column * `PR-128 `_ - Fix short version in conf.py * `PR-109 `_ - Ability to set the schema pattern for tables metadata retrieval * `PR-122 `_ - supporting tinyint for primary key * `PR-110 `_ - Added link to Confluent documentation for the connector. * `PR-49 `_ - CC-69: support nanoseconds precision for timestamp-based offset tracking * `PR-96 `_ - CC-243: use Long for nanos in offset map rather than Integer * `PR-93 `_ - Fix thread-safety of date/time conversions in DataConverter * `PR-87 `_ - Clean up table types documentation config and include it in a group with display attributes. * `PR-37 `_ - Exposed Table Types as a config * `PR-85 `_ - Add table.blacklist display name JDBC Sink Connector ~~~~~~~~~~~~~~~~~~~ New in 3.1.0 Version 3.0.1 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-88 `_ - Close all ResultSets in JdbcUtils * `PR-94 `_ - add version.txt to share/doc Version 3.0.0 ------------- JDBC Source Connector ~~~~~~~~~~~~~~~~~~~~~ * `PR-73 `_ - Update doc for Confluent Platform 3.0. * `PR-66 `_ - Task config should not show up in connector config. * `PR-59 `_ - Add schema evolution in doc. * `PR-55 `_ - Use new config definition. * `PR-53 `_ - Adding checkstyle checks and the traditional minor fixes related. * `PR-51 `_ - Add config to disable non-null checks. * `PR-50 `_ - Bump version to 3.0.0-SNAPSHOT and |ak-tm| dependency to 0.10.0.0-SNAPSHOT. * `PR-48 `_ - Delayed copy. * `PR-45 `_ - Added some logging.