Update embulk-{input|output} default JDBC driver. (MySQL/PostgreSQL).

[hiroyuki-sato]

I think we need make a plan to update default JDBC driver (MySQL/PostgreSQL) .

Current default drivers.

• PostgreSQL: 9.4-1205-jdbc41
• MySQL: mysql-connector-java:5.1.44

Motivation.

The current PostgreSQL driver doesn't support scram-sha-256 authentication which used default authentication mechanism in the version 14.0.

The current MySQL JDBC driver doesn't support caching_sha2_password authentication which used in MySQL 8.

Actions

We need Investigate difference / incompatibility between PostgreSQL/MySQL JDBC driver versions

• Investigate difference / incompatibility between MySQL JDBC driver versions embulk-input-jdbc#238
• Investigate difference / incompatibility between PostgreSQL JDBC driver versions embulk-input-jdbc#239

And we also need to discuss this Idea.
https://github.com/orgs/embulk/discussions/15

In my opinion, it is better to updates JDBC driver at first.

See also.

• MySQL:
  • jdbc error embulk-input-jdbc#209
  • embulk-input-mysql doesn't support Connector/J 8.X embulk-input-jdbc#163
  • [MySQL] Support Connector/J 8.X embulk-input-jdbc#200
• PostgreSQL
  • https://github.com/orgs/embulk/discussions/18

[dmikurube]

Thanks for raising this up! Yeah, we'll eventually need to catch up with the latest, but as you mentioned, we'll need to discuss :

• Possible incompatibilities -- expected such as default JDBC options
• Which to do at first-- this or https://github.com/orgs/embulk/discussions/15

Any comment is welcome. @embulk/core-team @embulk/jdbc-maintainers

[hiroyuki-sato]

PgJDBC(PostgreSQL) Changes.

🔵: New Feature
🔴: Change behavior. We need to care about this change.

• 42.0.0 and newer https://github.com/pgjdbc/pgjdbc/blob/master/CHANGELOG.md
• < 42.0.0: https://github.com/pgjdbc/www/blob/master/documentation/changelog.md

[42.6.0] (2023-03-17 15:34:34 -0400)

Changed

• fix: use PhantomReferences instead of Obejct.finalize() to track Connection leaks PR #2847

  The change replaces all uses of Object.finalize with PhantomReferences.
  The leaked resources (Connections) are tracked in a helper thread that is active as long as
  there are connections in use. By default, the thread keeps running for 30 seconds after all
  the connections are released. The timeout is set with pgjdbc.config.cleanup.thread.ttl system property.

• refactor:(loom) replace the usages of synchronized with ReentrantLock PR #2635
  Fixes Issue #1951

[42.5.4] (2023-02-15 10:21:04 -0500)

Fixed

• fix: fix testGetSQLTypeQueryCache by searching for xid type. We used to search for box type but it is now cached. xid is not cached, this nuance is required for the test.
• fix OidValueCorrectnessTest BOX_ARRAY OID, by adding BOX_ARRAY to the oidTypeName map [PR #2810]((fix: fix testGetSQLTypeQueryCache by searching for xid type instead of box.  pgjdbc/pgjdbc#2810).
• fixes Issue #2804.
• fix: Make sure that github CI runs tests on all PRs #2809.

[42.5.3] (2023-02-03 08:24:50 -0500)

Fixed

• fix: Add box to TypeInfoCache, fixes Issue #2746 PR #2747
• fix: regression in PgResultSet LONG_MIN copy and paste error fixes Issue #2748 PR#2749

[42.5.2] (2023-01-31 14:30:46 -0500)

Changed

• regression: This release has 2 known regressions which make it unusable see the notes above. We advise people to use 42.5.3 instead.
• docs: specify that timeouts are in seconds and there is a maximum. Housekeeping on some tests fixes #Issue 2671 PR #2686
• docs: clarify binaryTransfer and add it to README PR# 2698
• docs: Document the need to encode reserved characters in the connection URL PR #2700
• feat: Define binary transfer for custom types dynamically/automatically fixes Issue #2554 PR #2556

Added

• fix: added gssResponseTimeout as part of PR #2687 to make sure we don't wait forever on a GSS RESPONSE

Fixed

• fix: Ensure case of XML tags in Maven snippet is correct PR #2682
• fix: Make sure socket is closed if an exception is thrown in createSocket fixes Issue #2684 PR #2685
• fix: Apply patch from Issue #2683 to fix hanging ssl connections PR #2687
• fix - binary conversion of (very) long numeric values (longer than 4 * 2^15 digits) PR #2697 fixes Issue #2695
• minor: enhance readability connection of startup params PR #2705

[42.5.1] (2022-11-23 10:14:59 -0500)

Security

• security: StreamWrapper spills to disk if setText, or setBytea sends very large Strings or arrays to the server. createTempFile creates a file which can be read by other users on unix like systems (Not macos).
  This has been fixed in this version fixes CVE-2022-41946 see the security advisory for more details. Reported by Jonathan Leitschuh This has been fixed in versions 42.5.1, 42.4.3 42.3.8, 42.2.27.jre7. Note there is no fix for 42.2.26.jre6. See the security advisory for work arounds.

Fixed

• fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes #Issue 2548 PR #2552
• fix: binary decoding of bool values PR #2640
• perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns PR #2634
• chore: fix various spelling errors PR #2592
• chore: Feature/urlparser improve URLParser PR #2641

[42.5.0] (2022-08-23 11:20:11 -0400)

Changed

• fix: revert change in PR #1986 where float was aliased to float4 from float8.
  float now aliases to float8 PR #2598 fixes Issue #2597

[42.4.2] (2022-08-17 10:33:40 -0400)

Changed

• fix: add alias to the generated getUDT() query for clarity (PR #2553)[https://github.com/Add table alias to the getUDT query for clarity pgjdbc/pgjdbc#2553]

Added

• fix: make setObject accept UUID array PR #2587

Fixed

• fix: regression with GSS. Changes introduced to support building with Java 17 caused failures Issue #2588
• fix: set a timeout to get the return from requesting SSL upgrade. PR #2572
• feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads)

[42.4.1] (2022-08-01 16:24:20 -0400)

Security

• fix: CVE-2022-31197 Fixes SQL generated in PgResultSet.refresh() to escape column identifiers so as to prevent SQL injection.
  • Previously, the column names for both key and data columns in the table were copied as-is into the generated
    SQL. This allowed a malicious table with column names that include statement terminator to be parsed and
    executed as multiple separate commands.
  • Also adds a new test class ResultSetRefreshTest to verify this change.
  • Reported by Sho Kato

Changed

• chore: skip publishing pgjdbc-osgi-test to Central
• chore: bump Gradle to 7.5
• test: update JUnit to 5.8.2

Added

• chore: added Gradle Wrapper Validation for verifying gradle-wrapper.jar
• chore: added "permissions: contents: read" for GitHub Actions to avoid unintentional modifications by the CI
• chore: support building pgjdbc with Java 17
• feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads)

[42.4.0] (2022-06-09 08:14:02 -0400)

Changed

• fix: added GROUP_STARTUP_PARAMETERS boolean property to determine whether or not to group
  startup parameters in a transaction (default=false like 42.2.x) fixes Issue #2425
  pgbouncer cannot deal with transactions in statement pooling mode PR #2425

Fixed

• fix: queries with up to 65535 (inclusive) parameters are supported now (previous limit was 32767)
  PR #2525, Issue #1311
• fix: workaround JarIndex parsing issue by using groupId/artifactId-version directory namings.
  Regression since 42.2.13. PR #2531, issue #2527
• fix: use Locale.ROOT for toUpperCase() toLowerCase() calls
• doc: add Vladimir Sitnikov's PGP key
• fix: return correct base type for domain from getUDTs PR #2520 Issue #2522
• perf: utcTz static and renamed to UTC_TIMEZONE PR #2519
• doc: fix release version for #2377 (it should be 42.3.6, not 42.3.5)

[42.3.6] (2022-05-24 08:52:27 -0400)

Changed

Added

Fixed

• fix: close refcursors when underlying cursor==null instead of relying on defaultRowFetchSize PR #2377

[42.3.5] (2022-05-04 08:48:35 -0400)

Changed

• test: polish TimestampUtilsTest
• chore: use GitHub Action concurrency feature to terminate CI jobs on fast PR pushes

Added

• Added KEYS file to allow for verifying artifacts PR 2499

Fixed

• perf: enable tcpNoDelay by default PR 2495.
  This is a regression from 42.2.x versions where tcpNoDelay defaulted to true
• docs: fix readme.md after PR 2495 PR 2496
• feat: targetServerType=preferPrimary connection parameter PR 2483
• fix: revert removal of toOffsetDateTime(String timestamp) fixes Issue #2497 PR 2501

[42.3.4] (2022-04-01 14:16:28 -0400)

Changed

• fix: change name of build cache PR 2471
• feat: add support for ResultSet#getObject(OffsetTime.class) and PreparedStatement#setObject(OffsetTime.class) PR 2467
• fix: Use non-synchronized getTimeZone in TimestampUtils PR 2451
• docs: Fix CHANGELOG.md misformatted markdown headings PR 2461
• docs: remove loggerLevel and loggerFile from docs and issues PR 2489
• feat: use direct wire format -> LocalDate conversion without resorting to java.util.Date, java.util.Calendar,
  and default timezones PR 2464 fixes Issue #2221

Added

Fixed

• docs: Update testing documentation PR 2446
• fix: Throw an exception if the driver cannot parse the URL instead of returning NULL fixes Issue #2421 PR 2441
• fix: Use PGProperty instead of the property names directly PR 2444
• docs: update changelog, missing links at bottom and formatting PR 2460
• fix: Remove isDeprecated from PGProperty. It was originally intended to help produce automated docs. Fixes Issue #2479 PR 2480
• fix: change PGInterval parseISO8601Format to support fractional second PR 2457
• fix: GSS login to use TGT from keytab fixes Issue #2469 PR 2470
• fix: More test and fix for issues discovered by PR #2476 PR #2488

[42.3.3] (2022-02-15 11:32:24 -0500)

Changed

• fix: Removed loggerFile and loggerLevel configuration. While the properties still exist.
  They can no longer be used to configure the driver logging. Instead use java.util.logging
  configuration mechanisms such as logging.properties.

Added

Fixed

[42.3.2] (2022-02-01 07:35:41 -0500)

Security

• CVE-2022-21724 pgjdbc instantiates plugin instances based on class names provided via authenticationPluginClassName,
  sslhostnameverifier, socketFactory, sslfactory, sslpasswordcallback connection properties.
  However, the driver did not verify if the class implements the expected interface before instantiating the class. This
  would allow a malicious class to be instantiated that could execute arbitrary code from the JVM. Fixed in commit

Changed

• perf: read in_hot_standby GUC on connection PR #2334
• test: materialized view privileges PR #2209 fixes Issue #2060
• docs: add info about convenience maven project PR #2407
• docs: Document timezone reversal from POSIX to ISO PR #2413
• fix: we will ask the server if it supports GSS Encryption if gssEncryption
  is prefer or require PR #2396 remove the need to have a ticket in the cache before asking the server if gss encryptions are supported
• docs: remove Java 6 and 7 references from contributing PR #2385
• style: remove Java 8 / JDBC 4.2 checks PR #2383 Remove all remaining checks whether the source is lower than Java 8
  or JDBC 4.2.
• fix: throw SQLException for #getBoolean BIT(>1) PR #2386 Throw SQLException instead of ClassCastException when calling
  CallableStatement#getBoolean(int) on BIT(>1).
• style: import java.time types in more classes PR #2382 Use imports for java.time types in all remaining classes.
• style: import java.time types in TimestampUtils PR #2380 Use imports for java.time types in TimestampUtils.
• refactor: Change internal constructors to pass only connection Properties
  Changes internal constructors for PgConnection and related classes to only accept the connection properties object and
  remove the user and password arguments. Any locations that required those fields can retrieve them from the properties map.
• test: Fix DatabaseMetadataTest to perform mview tests only on 9.3+
• perf: read in_hot_standby GUC on connection PR #2334
• doc: improv doc around binary decoding of numeric data #2331
• Add cert key type checking to chooseClientAlias PR #2417

Added

• feat: Add authenticationPluginClassName option to provide passwords at runtime
  Adds authenticationPluginClassName connection property that allows end users to specify a class
  that will provide the connection passwords at runtime. Users implementing that interface must
  ensure that each invocation of the method provides a new char[] array as the contents
  will be filled with zeroes by the driver after use.Call sites within the driver have been updated to use the char[] directly wherever possible.
  This includes direct usage in the GSS authentication code paths that internally were already converting the String password into a char[] for internal usage.
  This allows configuring a connection with a password that must be generated on the fly or periodically changes. PR #2369 original issue Issue #2102
• feat: add tcpNoDelay option PR #2341 fixes Issue #2324
• 🔵 feat: pg_service.conf and .pgpass support (jdbc:postgresql://?service=my-service) PR #2260 fixes Issue #2278

Fixed

• Use local TimestampUtil in PgStatement and PgResultset for thread safety PR #2291
  fixes Issue #921 synchronize modification of shared calendar
• fix: PgObject isNull() was reporting the opposite fixes Issue #2411 PR #2414
• fix: default file name is ".pg_service.conf" on Windows (not "pg_service.conf") PR #2398 fixes Issue #2278
• test: Fix RefCursorFetchTest on older platforms
• fix: do not close refcursor after reading if fetchsize has been set fixes Issue #2227 PR #2371
• fix: rework gss authentication to use the principal name to get the credentials fixes Issue #2235 PR #2352
• fix: return getIndexInfo metadata columns in UPPER CASE PR #2368
• fix: Connection leak in ConnectionFactoryImpl#tryConnect PR #2350 Issue #2351
• fix: Fix For IS_AUTOGENERATED Flag PR #2348
• fix: parsing service file tests for windows PR #2347
• fix: The spec says that calling close() on a closed connection is a noop. PR #2345 fixes Issue #2300
• fix: add microsecond precision to getTimestamp() called on sql TIME(6) Currently, "when fetching a value of type TIME(6) through
  resultSet.getTimestamp() only ms precision is retained, the microsecond fractional digits are lost." This change will retain the microsecond
  precision when .getTimestamp() is called on TIME(6). PR #2181 Closes Issue #1537
• test: materialized view privileges PR #2209 add and drop a materialized view
  Add to TestUtil and also to DatabaseMetaData setup and teardown fixes Issue #2060
• fix: typo in connect.md PR #2338 OutOfMemoryException => OutOfMemoryError
• fix: use local TimestampUtil in PgStatement and PgResultset for thread
  safety TimestampUtil is not thread safe. It raises exceptions when multiple threads use ResultSets of one connection. PR #2291
  fixes Issue #921
  If PgStatement and PgResultSet use their own TimestampUtil no synchronize is needed.
• fix: typo in CONTRIBUTING.md PR #2332 seccion => section

[42.3.1] (2021-10-29)

Changed

• improv: Arrays in Object[] PR 2330 when an Object[] contains other arrays, treat as though it were a
  multi-dimensional array the one exception is byte[], which is not supported.
• improv: Use jre utf-8 decoding PR 2317 Remove use of custom utf-8 decoding.
• perf: improve performance of bytea string decoding PR 2320
  improve the parsing of bytea hex encoded string by making a lookup table for each of the valid ascii code points to the 4 bit numeric value
• feat: intern/canonicalize common strings PR 2234

Added

Fixed

• numeric binary decode for even 10 thousands PR #2327 fixes Issue 2326
  binary numeric values which represented integers multiples of 10,000 from 10,000-9,990,000 were not decoded correctly
• [typo] typo in certdir/README.md PR #2309 certificatess => certificates
• [typo] typo in TimestampUtils.java PR #2314 Change Greagorian to Gregorian.
• remove check for negative pid in cancel request. Apparently pgbouncer can send one fixes Issue 2317 PR #2319

[42.3.0] (2021-10-18)

Changed

• No longer build for Java 6 or Java 7
• If assumeMinServerVersion is not defined and server is at least 9.0, group startup statements into a single transaction PR #1977

Added

• 🔵 Support for pg_service.conf file and jdbc URL syntax: "jdbc:postgresql://?service=service1".
  Resource can be provided using 1) property "-Dorg.postgresql.pgservicefile=file1" 2) environment variable PGSERVICEFILE=file2 3) default location "$HOME/.pg_service.conf" 4) environment variable PGSYSCONFDIR=dir1 looks for file "dir1/pg_service.conf".
• 🔵 Support for .pgpass file. Resource can be provided using 1) property "-Dorg.postgresql.pgpassfile=file1" 2) environment variable PGPASSFILE=file2 3) default location "$HOME/.pgpass"

Fixed

• Rework OSGi bundle activator so it does not rely on exception message to check DataSourceFactory presence PR #507
• Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified PR #2174
• Fix refreshRow made the row readOnly. [PR #2195](Fix: RefreshRow causes row to become readOnly Issue #2193 pgjdbc/pgjdbc#2195 Fixes Issue #2193
• Fix do not add double quotes to identifiers already double quoted PR #2224 Fixes Issue #2223
  Add a property QUOTE_RETURNING_IDENTIFIERS which determines if we put double quotes
  around identifiers that are provided in the returning array.
• Fix Provide useful error message for empty or missing passwords for SCRAM auth PR #2290 fixes Issue #2288

[42.2.24] (2021-09-23)

Fixed

• Fix startup regressions caused by PR #1949. Instead of checking all types by OID, we can return types for well known types PR #2257
• Backport PR #2148
  Avoid leaking server error details through BatchUpdateException when logServerErrorDetail PR #2254
• Backpatch PR #2247
  QueryExecutorImpl.receiveFastpathResult did not properly handle ParameterStatus messages.
  This in turn caused failures for some LargeObjectManager operations. Closes Issue #2237
  Fixed by adding the missing code path, based on the existing handling in processResults. PR #2253
• Backpatch PR #2242 PgDatabaseMetaData.getIndexInfo() cast operands to smallint PR#2253
  It is possible to break method PgDatabaseMetaData.getIndexInfo() by adding certain custom operators. This PR fixes it.
• Backpatching PR #2251 into 42.2 Clean up open connections to fix test failures on omni and appveyor
  use older syntax for COMMENT ON FUNCTION with explicit no-arg parameter parentheses as it is required on server versions before v10.
  Handle cleanup of connection creation in StatementTest, handle cleanup of privileged connection in DatabaseMetaDataTest
• Backpatch PR #2245 fixes case where duplicate tables are returned if there are duplicate descriptions oids are not guaranteed to be unique in the catalog PR #2248
• Change to updatable result set to use correctly primary or unique keys PR #2228
  fixes issues introduced in PR #2199 closes Issue #2196
• Fix NPE calling getTypeInfo when alias is null PR #2220
• Backpatch PR #2217 to fix Issue #2215. OIDs are unsigned integers and were not being handled correctly when they exceeded the size of signed integers

[42.2.23] (2021-07-06)

Changed

• Renewed the SSL keys for testing

Fixed

• getColumnPrecision for Numeric when scale and precision not specified now returns 0 instead of 131089 fixes: Issue #2188
• Calling refreshRow on an updateable resultset made the row readOnly. Fixes Issue #2193
• results should be updateable if there is a unique index available PR#2199 Fixes Issue #2196
• Rework sql type gathering to use OID instead of typname.
  This does not have the issue of name shadowing / qual-names, and has the added benefit of fixing #1948.

[42.2.22] (2021-06-16)

Fixed

• Regression caused by pgjdbc/pgjdbc@4fa2d5b. Unfortunately
  due to the blocking nature of the driver and issues with seeing if there is a byte available on a blocking stream when it is encrypted
  this introduces unacceptable delays in returning from peek(). At this time there is no simple solution to this.

[42.2.21] (2021-06-10)

Changed

• Update docs to reflect deprecated DataSource API setServerName backpatch PR#2057 PR #2105

Fixed

• make sure the table has defined primary keys when using updateable resultset backpatch PR#2101 fixes Issue 1975 PR #2106
• backpatch PR #2143 read notifies or errors that come in asynchronously after the ready for query PR #2168
• backpatch PR #507 which reworks OSGI bundle activator fixes ISSUE #2133
• Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified. backpatch PR #2174
  fixes Issue 2173

[42.2.20] (2021-04-19)

Fixed

• Partitioned indexes were not found fixes #2078 PR #2087
• isValid() timeout should not be blocked #1943 Cherry-picked #2076
  The usage of setQueryTimeout(); with the same value as the setNetworkTimeout(); is blocking the current transaction timeout.
  The timeouts are blocking each other with this approach.
• DatabaseMetaData.getTables returns columns in UPPER case as per the spec PR #2092 fixes Issue #830

[42.2.19] (2021-02-18)

Notable Changes

• Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
• If closeOnCompletion is called on an existing statement and the statement is executed a second time it will fail.

Changed

• Perf: avoid duplicate PGStream#changeSocket calls
• Fix: Actually close unclosed results. Previously was not closing the first unclosed result fixes #1903 (#1905).
  There is a small behaviour change here as a result. If closeOnCompletion is called on an existing statement and the statement
  is executed a second time it will fail.

Added

• Verify code via forbidden-apis (jdk-internal and jdk-non-portable signatures) PR #2012

Fixed

• Fix Binary transfer for numeric fixes #1935
• Fix Allow specifying binaryTransferEnable even for those types that are not enabled by default
• Fix: properly set cancel socket timeout (#2044)
• Fix "Required class information missing" when old org.jboss:jandex parses pgjdbc classes [issue 2008][https://github.com/Required class information missing after upgrade to version higher than 42.2.14 pgjdbc/pgjdbc#2008]
• Fix PGCopyInputStream returning the last row twice when reading with CopyOut API [issue 2016][https://github.com/ the last row is repeated on the PGCopyInputStream  pgjdbc/pgjdbc#2016]
• Fix Connection.isValid() to not wait longer than existing network timeout PR #2040
• Fix Passwords with spaces (ASCII and non-ASCII) now work with SCRAM authentication (driver now uses SASLprep normalization) PR #2052
• Fix DatabaseMetaData.getTablePrivileges() to include views, materialized views, and foreign tables PR #2049
• Fix Resolve ParseError in PGtokenizer fixes #2050
• Fix return metadata privileges for views and foreign tables

[42.2.18] (2020-10-15)

Fixed

• Unfortunately changing the default of gssEncMode to ALLOW was not enough. The GSSEncMode Enum was not changed as well
  fixed in #1920

[42.2.17] (2020-10-09)

Changed

• Change default of gssEncMode to ALLOW. PostgreSQL can deal with PREFER but there are cloud providers that did not implement the protocol properly. Libpq gets around this by checking for a GSS credential cache before attempting the connection. This is possible in JDK 8 and up, but not JDK6, or JDK7 fixes Issue #1868 PR #1913

Added

• Add smallserial metadata [PR #899(https://github.com/feat: add smallserial metadata pgjdbc/pgjdbc#899)

Fixed

• Avoid NullPointerException when receiving PGbox, PGcircle, PGline, PGlseg, PGpath, PGpoint, PGpolygon, and PGmoney [PR 1873] (Handle nulls when the following classes are used: PGbox, PGcircle, PGline, PGlseg, PGpath, PGpoint, PGpolygon, and PGmoney pgjdbc/pgjdbc#1873).
• The driver returns enum and jsonb arrays elements as String objects (like in 42.2.14 and earlier versions) PR 1879.
• PgTokenizer was ignoring last empty token PR #1882
• Remove osgi from karaf fixes Issue #1891 PR #1902
• Handle nulls when the following classes are used: PGbox, PGcircle, PGline, PGlseg, PGpath, PGpoint, PGpolygon, and PGmoney.

[42.2.16] (2020-08-20)

Known issues

• The driver returns enum and jsonb arrays elements are returned as PGobject instances (fixed in 42.2.17)

Fixed

• Arrays sent in binary format are now sent as 1 based. This was a regression for multi-dimensional arrays as well as text/varchar, oid and bytea arrays.
  Since 42.2.0 single dimensional arrays were stored 0 based. They are now sent 1 based which is the SQL standard, and the default
  for Postgres when sent as strings such as '{1,2,3}'. Fixes issue 1860 in PR 1863.

[42.2.15] (2020-08-14)

Known issues

• The driver returns enum and jsonb arrays elements are returned as PGobject instances (fixed in 42.2.17)

Changed

• Rename source distribution archive to postgresql-$version-jdbc-src.tar.gz, and add top-level archive folder ba017507
• 🔵 Add the ability to connect with a GSSAPI encrypted connection. As of PostgreSQL version 12 GSSAPI encrypted connections
  are possible. Now the driver will attempt to connect to the server with a GSSAPI encrypted connection. If that fails then
  attempt an SSL connection, finally falling back to a plain text connection. All of this is controlled using both the gssEncMode
  and sslMode parameters which, in concert with pg_hba.conf, determine if a particular mode is allowed and or required. PR 1821 ad921b9e
• Source release archive shades dependencies (scram) by default. It affects only postgresql-version-src.tar.gz release artifact f0301eb9
• Refactor decoding arrays PR 1194

Added

• Verify nullness with CheckerFramework 6e524ae5

Fixed

• Avoid preparedStatement leak when using updateable ResultSet via insert/update/refreshRow PR 1815 9a0d2b18
• Change order of checks for oid vs primary keys. OID's have been deprecated. PR 1613
• Close certificate file stream. PR 1837
• Make sure socketTimeout is enforced PR 1831
• Assume PKCS-8 SSL key format by default PR 1819
• Preserve unquoted unicode whitespace in array literals PR 1266

[42.2.14] (2020-06-10)

Changed

• Reverted com.github.waffle:waffle-jna, org.osgi:org.osgi.core, org.osgi:org.osgi.enterprise dependencies to optional=true in Maven PR 1797.

[42.2.13] (2020-06-04)

Notable Changes

• Security: The primary reason to release this version and to continue the 42.2.x branch is for CVE-2020-13692.
  Reported by David Dworken, this is an XXE and more information can be found here.
  Sehrope Sarkuni reworked the XML parsing to provide a solution in commit 14b62aca4.
• The build system has been changed to Gradle thanks to Vladimir PR 1627.
• Regression: com.github.waffle:waffle-jna, org.osgi:org.osgi.core, org.osgi:org.osgi.enterprise dependencies are listed as non-optional issue 1975.

Changed

Added

• jre-6 was added back to allow us to release fixes for all artifacts in the 42.2.x branch PR 1787

Fixed

• I/O error ru translation PR 1756
• Issue 1771 PgDatabaseMetaData.getFunctions() returns
  procedures fixed in PR 1774
• getTypeMap() returning null PR 1781
• Updated openssl example command PR 1763
• fix documentation with ordered list to be displayed correctly PR 1783

[42.2.12] (2020-03-31)

Notable changes

We have released 42.2.12 to correct regressions in this version: Specifically

• PR 1729 was reverted as this is a breaking change
• PR 1719 has been reverted as it introduced errors in the PgType Cache

We recommend that version 42.2.11 not be used.

Changed

• reverted PR 1729 throw an error instead of silently rolling back a commit error.
  This change introduced a breaking change which will be moved to 42.3.0
• reverted PR 1719 add support for full names of data types (#1719)

[42.2.11] (2020-03-07)

Notable changes
As mentioned above this version is broken and should not be used.

Changed

• Reverted PR 1641. The driver will now wait for EOF when sending cancel signals.
• DatabaseMetaData#getProcedures returns only procedures (not functions) for PostgreSQL 11+ PR 1723
• Convert silent rollbacks into exception if application sends commit or xa.prepare command PR 1729

Added

• feat: raiseExceptionOnSilentRollback connection option to configure if silent rollback should raise an exception PR 1729
• feat: Expose ByteStreamWriter in CopyManager PR 1702
• feat: add way to distinguish base and partitioned tables in PgDatabaseMetaData.getTables PR 1708
• refactor: introduce tuple abstraction (rebased) PR 1701
• refactor: make PSQLState enum consts for integrity constraint violations PR 1699
• test: add makefile to create ssl certs PR 1706

Fixed

• fix: Always use . as decimal separator in PGInterval PR 1705
• fix: allow DatabaseMetaData.getColumns to describe an unset scale PR 1716

Changed

• Build system update from Maven to Gradle PR 1627

Added

• docker-compose image for creating test databases (see docker folder)

[42.2.10] (2020-01-30)

Changed

• (!) Regression: remove receiving EOF from backend after cancel PR 1641. The regression is that the subsequent query might receive the cancel signal.

Added

• Add maxResultBuffer property PR 1657
• add caller push of binary data (rebase of #953) PR 1659

Fixed

• Cleanup PGProperty, sort values, and add some missing to docs PR 1686
• Fixing LocalTime rounding (losing precision) PR 1570
• Network Performance of PgDatabaseMetaData.getTypeInfo() method PR 1668
• Issue #1680 updating a boolean field requires special handling to set it to t or f instead of true or false PR 1682
• bug in pgstream for replication PR 1681
• Issue #1677 NumberFormatException when fetching PGInterval with small value PR 1678
• Metadata queries improvements with large schemas. PR 1673
• Utf 8 encoding optimizations PR 1444
• interval overflow PR 1658
• Issue #1482 where the port was being added to the GSSAPI service name PR 1651
• remove receiving EOF from backend after cancel since according to protocol the server closes the connection once cancel is sent (connection reset exception is always thrown) PR 1641
• Unable to register out parameter Issue #1646 PR 1648

[42.2.9] (2019-12-06)

Changed

Added

• read only transactions PR 1252
• pkcs12 key functionality PR 1599
• new "escapeSyntaxCallMode" connection property PR 1560
• connection property to limit server error detail in exception exceptions PR 1579
• cancelQuery() to PGConnection public interface PR 1157
• support for large update counts (JDBC 4.2) PR 935
• Add Binary Support for Oid.NUMERIC and Oid.NUMERIC_ARRAY PR 1636

Fixed

• issue 716 getTypeInfo() may not return data in the order specified in Oracle documentation PR 1506
• PgSQLXML setCharacterStream() results in null value PR 1608
• get correct column length for simple domains PR 1605
• NPE as a result of calling executeQuery twice on a statement fixes issue #684 [PR 1610] (fix: NPE as a result of calling executeQuery twice on a statement  pgjdbc/pgjdbc#1610)
• handle numeric domain types PR 1611
• pginterval to take iso8601 strings PR 1612
• remove currentTimeMillis from code, tests are OK PR 1617
• NPE when calling setNull on a PreparedStatement with no parameters PR 1620
• allow OUT parameter registration when using CallableStatement native CALL PR 1561
• add release save point into execute with batch PR 1583
• Prevent use of extended query protocol for BEGIN before COPY PR 1639

[42.2.8] (2019-09-13)

Changed

Added

Fixed

• fix: Revert inet default Java type to PGObject and handle values with net masks PR 1568

[42.2.7] (2019-09-03)

Changed

Added

• Expose parameter status messages (GUC_REPORT) to the user PR 1435
• Add automatic module name to manifest for jdk9+ PR 1538
• Log ignoring rollback when no transaction in progress PR 1549
• Map inet type to InetAddress PR 1527 issue 1134

Fixed

• fix issue 1547 As long as peek returns some bytes do not reset the timeout, this allows us to continue checking until any async notifies are consumed PR 1548
• fix: issue 1466 In logical decoding the if the backend was requesting a reply we… PR 1467
• fix: issue 1534 Proleptic java.time support PR 1539
• fix Ensure isValid() will not last more than timeout seconds PR 1557

[42.2.6] (2019-06-19)

Known issues

• Waffle has dropped support for 1.6, 1.7 as such the new waffle 1.9.x is only available in jre8
• Microseconds in timestamps might be truncated when transferred in binary mode
• 24:00 time handling is not consistent issue 1385
• Unexpected packet type during stream replication issue 1466
• Driver goes missing after OSGi bundle restart issue 1476

Changed

• Change IS_GENERATED to IS_GENERATEDCOLUMN as per spec PR 1485
• Fix missing metadata columns, and misspelled columns in PgDatabaseMetaData#getTables PR 1323

Added

• CI tests with Java 11, and Java EA
• Support temporary replication slots in ReplicationCreateSlotBuilder PR 1306
• Support PostgreSQL 11, 12
• Return function (PostgreSQL 11) columns in PgDatabaseMetaData#getFunctionColumns
• Return information on create replication slot, now the snapshot_name is exported
  to allow a consistent snapshot in some uses cases. PR 1335

Fixed

• Fixed async copy performance (1ms per op) in SSL mode PR 1314
• Return Double.NaN for 'NaN'::numeric PR 1304
• Performance issue in PgDatabaseMetaData#getTypeInfo with lots of types in DB PR 1302
• PGCopyInputStream#read should cap values to [0, 255], -1 PR 1349
• Fixes LocalDateTime handling of BC dates PR 1388
• Release savepoints in autosave mode to prevent out of shared memory errors at the server side PR 1409
• Fix execution with big decimal in simple query mode. PR 1463
• Fix rounding for timestamps truncated to dates before 1970 PR 1502

[42.2.5] (2018-08-27)

Known issues

• 1ms per async copy call issue 1312

Changed

• 🔵 ssl=true implies sslmode=verify-full, that is it requires valid server certificate cdeeaca4

targetServerType=master has been deprecated in favour of targetServerType=primary. master
will still be accepted but not documented.

Added

• 🔵 Support for sslmode=allow/prefer/require cdeeaca4

Fixed

• Security: added server hostname verification for non-default SSL factories in sslmode=verify-full (CVE-2018-10936) cdeeaca4
• Updated documentation on SSL configuration fa032732
• Updated Japanese translations PR 1275
• IndexOutOfBounds on prepared multistatement with insert values c2885dd0

[42.2.4] (2018-07-14)

Changed

• PreparedStatement.setNull(int parameterIndex, int t, String typeName) no longer ignores the typeName
  argument if it is not null PR 1160

Fixed

• Fix treatment of SQL_TSI_YEAR, SQL_TSI_WEEK, SQL_TSI_MINUTE PR 1250
• Map integrity constraint violation to XA_RBINTEGRITY instead of XAER_RMFAIL PR 1175 f2d1352c

[42.2.3] (2018-07-12)

Known issues

• SQL_TSI_YEAR is treated as hour, SQL_TSI_WEEK is treated as hour, SQL_TSI_MINUTE is treated as second

Changed

• Reduce the severity of the error log messages when an exception is re-thrown. The error will be
  thrown to caller to be dealt with so no need to log at this verbosity by pgjdbc PR 1187
• Deprecate Fastpath API PR 903
• Support parenthesis in {oj ...} JDBC escape syntax PR 1204
• ubenchmark module moved pgjdbc/benchmarks repository due to licensing issues PR 1215
• Include section on how to submit a bug report in CONTRIBUTING.md PR 951

Fixed

• getString for PGObject-based types returned "null" string instead of null PR 1154
• Field metadata cache can be disabled via databaseMetadataCacheFields=0 PR 1052
• Properly encode special symbols in passwords in BaseDataSource PR 1201
• Adjust date, hour, minute, second when rounding nanosecond part of a timestamp PR 1212
• perf: reduce memory allocations in query cache PR 1227
• perf: reduce memory allocations in SQL parser PR 1230, PR 1233
• Encode URL parameters in BaseDataSource PR 1201
• Improve JavaDoc formatting PR 1236

[42.2.2] (2018-03-15)

Added

• Documentation on server-side prepared statements PR 1135

Fixed

• Avoid failure for insert ... on conflict...update for reWriteBatchedInserts=true case PR 1130
• fix: allowEncodingChanges should allow set client_encoding=... PR 1125
• Wrong data from Blob/Clob when mark/reset is used PR 971
• Adjust XAException return codes for better compatibility with XA specification PR 782
• Wrong results when single statement is used with different bind typesPR 1137
• Support generated keys for WITH queries that miss RETURNING PR 1138
• Support generated keys when INSERT/UPDATE/DELETE keyword is followed by a comment PR 1138

[42.2.1] (2018-01-25)

Known issues

• client_encoding has to be UTF8 even with allowEncodingChanges=true

Changed

• socksProxyHost is ignored in case it contains empty string PR 1079

Fixed

• Avoid connection failure when DateStyle is set to ISO (~PgBouncer) Issue 1080
• Package scram:client classes, so SCRAM works when using a shaded jar PR 1091 1a89290e
• reWriteBatchedInserts=true causes syntax error with ON CONFLICT Issue 1045 PR 1082
• Avoid failure in getPGArrayType when stringType=unspecified PR 1036
• For PostgreSQL 9.0+ return a complete list of keywords in DatabaseMetadata.getSQLKeywords() from pg_catalog.pg_get_keywords(). PR 940

[42.2.0] (2018-01-17)

Known issues

• SCRAM does not work as scram:client library is not packaged
• client_encoding has to be UTF8 even with allowEncodingChanges=true

Added

• 🔵 Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library. PR 842
• Make SELECT INTO and CREATE TABLE AS return row counts to the client in their command tags. Issue 958 PR 962
• Support Subject Alternative Names for SSL connections. PR 952
• Support isAutoIncrement metadata for PostgreSQL 10 IDENTITY column. PR 1004
• Support for primitive arrays PR#887 3e0491a
• 🔵 Implement support for get/setNetworkTimeout() in connections. PR 849
• Make GSS JAAS login optional, add an option "jaasLogin" PR 922 see Connecting to the Database

Changed

• Improve behaviour of ResultSet.getObject(int, Class). PR 932
• Parse CommandComplete message using a regular expression, allows complete catch of server returned commands for INSERT, UPDATE, DELETE, SELECT, FETCH, MOVE, COPY and future commands. PR 962
• 🔴 Use 'time with timezone' and 'timestamp with timezone' as is and ignore the user provided Calendars, 'time' and 'timestamp' work as earlier except "00:00:00" now maps to 1970-01-01 and "24:00:00" uses the system provided Calendar ignoring the user-provided one PR 1053
• Change behaviour of multihost connection. The new behaviour is to try all secondaries first before trying the master PR 844.
• Avoid reflective access to TimeZone.defaultTimeZone in Java 9+ PR 1002 fixes Issue 986

Fixed

• Make warnings available as soon as they are received from the server. This is useful for long running queries, where it can be beneficial to know about a warning before the query completes. PR 857
• Use 00:00:00 and 24:00:00 for LocalTime.MIN/MAX. PR 992
• Now the DatabaseMetaData.getFunctions() implementation complies with the JDBC docs. PR 918
• Execute autosave/rollback savepoint via simple queries always to prevent "statement S_xx not exists" when autosaving fixes Issue #955
• Received resultset tuples, but no field structure for them" when bind failure happens on 5th execution of a statement Issue 811

Removed

• Drop support for the (insecure) crypt authentication method. PR 1026

Deprecated

• Reintroduce Driver.getVersion for backward compatibility reasons, mark it as deprecated as application should not rely on it (regression since 42.0.0) 50d5dd3e

[42.1.4] (2017-08-01)

Changed

• Statements with non-zero fetchSize no longer require server-side named handle. This might cause issues when using old PostgreSQL versions (pre-8.4)+fetchSize+interleaved ResultSet processing combo. Issue 869

[42.1.3] (2017-07-14)

Fixed

• Fix NPE in PreparedStatement.executeBatch in case of empty batch (regression since 42.1.2). PR 867

[42.1.2] (2017-07-12)

Changed

• Better logic for returning keyword detection. Previously, pgjdbc could be defeated by column names that contain returning, so pgjdbc failed to "return generated keys" as it considered statement as already having returning keyword PR 824 201daf1d
• Use server-prepared statements for batch inserts when prepareThreshold>0. Note: this enables batch to use server-prepared from the first executeBatch() execution (previously it waited for prepareThreshold executeBatch() calls) abc3d9d7

Fixed

• Replication API: fix issue in #834 setting statusIntervalUpdate causes high CPU load. PR 835 59236b74

Regressions

• NPE in PreparedStatement.executeBatch in case of empty batch. Fixed in 42.1.3

[42.1.1] (2017-05-05)

Fixed

• Fix infinite dates that might be corrupted when transferred in binary for certain JREs. For instance, 5881610-07-11 instead of infinity. 1e5bf563

[42.1.0] (2017-05-04)

Added

• Support fetching a REF_CURSOR using getObject PR 809

Fixed

• Fix data being truncated in setCharacterStream (bug introduced in 42.0.0) PR 802
• Fix calculation of lastReceiveLSN for logical replication PR 801
• Make sure org.postgresql.Driver is loaded when accessing though DataSource interface Issue 768

Regressions

• There's no 42.1.0.jre6 version due to infinity handling bug. Fixed in 42.1.1.jre6

[42.0.0] (2017-02-20)

Added

• Replication protocol API was added: replication API documentation. PR 550
• java.util.logging is now used for logging: logging documentation. PR 722
• Add support for PreparedStatement.setCharacterStream(int, Reader). ee4c4265

Changed

• Version bumped to 42.0.0 to avoid version clash with PostgreSQL version and follow a better sematic versioning. 46634923
• Ensure executeBatch() can be used with pgbouncer. Previously pgjdbc could use server-prepared statements for batch execution even with prepareThreshold=0. Issue 742
• Error position is displayed when SQL has unterminated literals, comments, etc. Issue 688
• 🔴 Strict handling of accepted values in getBoolean and setObject(BOOLEAN), now it follows PostgreSQL accepted values, only 1 and 0 for numeric types are accepted (previously !=0 was true). PR 732
• Return correct versions and name of the driver. PR 668

Removed

• 🔴 Support for PostgreSQL versions below 8.2 was dropped. PR 661

Deprecated

• Deprecated PGPoolingDataSource, instead of this class you should use a fully featured connection pool like HikariCP, vibur-dbcp, commons-dbcp, c3p0, etc. PR 739

Regressions

• Data truncated in setCharacterStream. Fixed in 42.1.0
• No suitable driver found for jdbc:postgresql when using a DataSource implementation. Fixed in 42.1.0

[hiroyuki-sato]

Original docment: https://github.com/pgjdbc/www/blob/master/documentation/changelog.md

Version 9.4.1212 (2016-11-02)

Notable changes:

• ? can now be used in non-prepared statements (regression was introduced in 1210)

AlexElin (1):

• chore: add coverage badge (#646) 05c2f8d

Jorge Solorzano (6):

• docs: split readme.md to contributing.md (#652) 7270435
• docs: improve readme.md (#666) cf6b836
• docs: change license to BSD-2-Clause (#660) b4c90c8
• style: update the header in the project (#662) 8be516d
• fix: copy src/main/resources (#676) 14f3fce
• style: copy license file to META-INF folder (#677) c518697

Sebastian Utz (1):

• fix: makes escape processing strict according to JDBC spec PR#657 00a8478

Vladimir Sitnikov (4):

• 🔴 fix: do not convert ?, ? to $1, $2 when statement.executeQuery(String) is used (#644) PR#643 08e1a40
• tests: make CursorFetchTest.testGetRow to use stable order of rows so the test does not depend on actual implementation of UNION 3c8efe4
• fix: avoid ClassLoader leaks caused by SharedTimer PR#664 f52bf7f
• Make successful OSGi activation less noisy PR#672 22b9025

zapov (1):

• fix: Don't break when there is no column metadata (#663) 6d2a53e

Contributors to this release

We thank the following people for their contributions to this release.

AlexElin
Jorge Solorzano
Rikard Pavelic
Sebastian Utz
Vladimir Sitnikov

Version 9.4.1211 (2016-09-18)

Notable changes:

• json type is returned as PGObject like in pre-9.4.1210 (fixed regression of 9.4.1210)
• 'current transaction is aborted' exception includes the original exception via caused-by chain

Daniel Gustafsson (1):

• doc: fix brand names and links in readme (#636) 56c04d0

Vladimir Sitnikov (4):

• chore: eploy to Travis was silently broken for a couple of days since "test" command was missing 67d7e3c
• fix: json should be returned as PGObject, not as String for backward compatibility reasons (#640) PR#639 beaec3a
• test: add DebugNonSafepoints to FlightRecorderProfiler PR#622 154c463
• feat: include root cause exception in case transaction fails (#628) 51775c1

Contributors to this release

We thank the following people for their contributions to this release.

Daniel Gustafsson
Vladimir Sitnikov

Version 9.4.1210 (2016-09-07)

Notable changes:

• Better support for RETURN_GENERATED_KEYS, statements with RETURNING clause
• Avoid user-visible prepared-statement errors if client uses DEALLOCATE/DISCARD statements (invalidate cache when those statements detected)
• Avoid user-visible prepared-statement errors if client changes search_path (invalidate cache when set search_path detected)
• Support comments when replacing {fn ...} JDBC syntax
• Support for Types.REF_CURSOR

AlexElin (3):

• style: change method names to start with a lower case letter (#615) 22c72b4
• refactor: fix some hintbugs warnings (#616) dd71f6f
• refactor: use varargs in Gt.tr (#629) 07c7902

Chrriis (1):

• perf: cache result set column mapping for prepared statements PR#614 88fbbc5

Marios Trivyzas (1):

• perf: add point type info to Client (#612) ba14509

Mathias Fußenegger (2):

• doc: fix test README link in README (#609) c09be96
• perf: add json type info to Client (#610) 4ad2df3

Pavel Raiskup (1):

• packaging: sync spec file with Fedora package PR#608 dd48911

Philippe Marschall (1):

• feat: support Types.REF_CURSOR PR#635 b5c3f59

Vladimir Gordiychuk (1):

• test: fix Travis job so it actually tests against HEAD PostgreSQL (#630) 9030373

Vladimir Sitnikov (23):

• test: skip json testing on pre-9.2 databases (those do not implement json type) 0a17d82
• chore: make sure JDK9+PG 9.4 Travis job indeed uses PG 9.4 01b65c3
• test: add PostgreSQL HEAD to pgjdbc regression test matrix (#613) PR#561 65a32ff
• test: add benchmark for resultSet.getByName ff4bfda
• chore: use Travis' PostgreSQL 9.5 d1feb58
• docs: add javadoc badge to the project readme 5d7a9bb
• refactor: remove autoCommit argument from QueryExecutor#createSimpleQuery/createParameterizedQuery 756363e
• fix: support cases when user-provided queries have 'returning' PR#488 c3d8571
• feat: support execute statements via simple 'Q' command PR#558 232569c
• feat: show proper error message when connecting to non-UTF-8 database PR#594 ec5fb4f
• test: add tests for Parser.parseDelete/Select/Move/WithKeyword 3b7c7c4
• chore: update to 1.1.0 version of parent pom to upgrade bndlib 2.3.0 -> 2.4.0 4019ed6
• chore: use latest java version for one of Java 8 Travis jobs 0452e79
• refactor: introduce ResultHandlerBase to factor out common error processing logic edcdccd
• feat: reset server-prepared statements on deallocate/discard, ability to autorollback on sqlexception from executing a query PR#451 adc08d5
• fix: add a test case when "deallocate all" detector is turned off aa53fba
• fix: invalidate prepared statement cache when "set search_path=..." query is detected PR#496 17c8afb
• fix: properly account cache size when duplicate entries returned to the cache 191ccf2
• feat: support 10+ version parsing Note: 10.2 means 10 major, 2 minor, that is 10_00_02 9.2 means 9.2 major, that is 9_02_00 PR#631 a639431
• fix: honor comments when replacing {fn curdate()} kind of calls PR#632 2d9b313
• chore: skip "deploy to Central" step when building PRs 9bc194a
• test: add performance test for "reused vs non-reused at client side" prepared statements 2d70385
• chore: improve ./release_notes.sh so it does not require parameters d8736b4

Contributors to this release

We thank the following people for their contributions to this release.

AlexElin
Christopher Deckers
Marios Trivyzas
Mathias Fußenegger
Pavel Raiskup
Philippe Marschall
Vladimir Gordiychuk
Vladimir Sitnikov

Version 9.4.1209 (2016-07-15)

Notable changes:

• BUG: json datatype is returned as java.lang.String object, not as PGObject (fixed in 9.4.1211)
• Many improvements to insert into .. values(?,?) -> insert .. values(?,?), (?,?)... rewriter. Give it a try by using reWriteBatchedInserts=true connection property. 2-3x improvements for insert batch can be expected
• Full test suite passes against PostgreSQL 9.6, and OpenJDK 9
• Performance optimization for timestamps (~TimeZone.getDefault optimization)
• Allow build-from-source on GNU/Linux without maven repositories, and add Fedora Copr test to the regression suite

AlexElin (2):

• style: code cleanup and Java 5' features 8e8dbab
• style: cleanup and Java 5' features for tests (#602) 28c0c22

Christian Ullrich (4):

• docs: fix test password in readme closes #553 PR#553 07f8610
• test: make tests independent from server LC_MESSAGES (#554) b756a15
• fix: update waffle version PR#555 db1a6e4
• test: add basic tests for SSPI authentication PR#557 16c27b9

Christopher Deckers (2):

• fix: improve insert values(...) batch rewrite PR#580 510e6e0
• perf: cache timezone in statement#setDate, resultSet#getDate, etc PR#588 d2b86a0

Dave Cramer (5):

• use binary trick for tolower, optimize switch, added tests 2200a4d
• fix:bugs with parse 72945b0
• fix: added test for move and fixed checkstyle errors fc59851
• fixed index ASC/DESC for 9.6 (#569) c9e5fc8
• test: DataSource.getConnection().unwrap(PGConnection.class) PR#573 f6b176e

Florin Asăvoaie (1):

• Refactored an unnecessary conversion of List<String[]> to String[][] when calling the sendStartupPacket. (#544) 2032836

George Kankava (1):

• fix: PgDatabaseMetaData: close statement in finally PR#516 b4c45ca

Jeremy Whiting (3):

• perf: Add optimization to re-write batched insert stataments. ac8abf3
• fix: Change optimization to delay parameter and statement re-write to immediately before execution. e591577
• feat: Added to SQL parser to allow inspection of Statement attributes and Command. 4ddb693

Laurenz Albe (1):

• fix: interpretation of empty but set "ssl" connection property PR#528 91f05b4

Minglei Tu (1):

• feat: support java.sql.Types.TIME_WITH_TIMEZONE and java.sql.Types.TIMESTAMP_WITH_TIMEZONE in setNull method PR#570 1b73bf6

Pavel Raiskup (3):

• Allow build-from-source on GNU/Linux without maven repositories (#546) 87489a9
• chore: test Fedora packaging CI via Travis job PR#578 1eb4085
• packaging: heal Fedora build (#601) af50d0b

Petro Semeniuk (1):

• fix: use per-connection cache for field metadata (table name, column name, etc) PR#551 dc3bdda

Philippe Marschall (4):

• style: Use more generics PR#519 88e39a0
• style: remove unused code PR#520 f21f168
• refactor: Remove pgTypeName null check PR#525 462928b
• refactor: remove ClassCastException catch PR#527 8bee06b

Tanya Gordeeva (1):

• fix: add a socket timeout on cancel requests PR#603 ab2a6d8

Vladimir Sitnikov (23):

• test: add tests for null::float8[] e6b5bb3
• test: createArrayOf(..., null) test a274321
• test: avoid "The connection attempt failed" in ConnectTimeoutTest.testTimeout PR#531 fbabfa4
• fix: NPE in DatabaseMetaData.getTypeInfo when types are dropped concurrently PR#530 f3b0fd0
• 🔴 fix: binary timestamptz -> getString should add +XX zone offset to text representation PR#130 1e1f3c4
• refactor: "build without waffle/osgi" PR 766f806
• test: add PostgreSQL 9.6 to CI tests (#560) 3ff47da
• chore: make sure ubenchmark is tested with checkstyle PR#564 f6ed8e6
• chore: add explicit MCENTRAL=Y to Travis jobs that deploy to Maven Central 18ca8f2
• test: prune some Travis jobs to make CI faster c5c1d7c
• chore: propagate java source/target to maven-compiler-plugin d8117d1
• chore: add codecov.yml fb2977f
• refactor: use enum instead of int for PgStatement.statementState to simplify debugging 32d4e08
• test: use TestUtil.getPort() in V3ParameterListTests instead of hard-coded 5432 9a4b296
• chore: make codecov to always wait 7 builds 9f9aa95
• test: add jdk9 Travis job PR#565 bbb0d35
• fix: incorrect binary data format in bind parameter X when using batch execution (#582) 7388dc9
• perf: execute "SET application_name" if name has changed only PR#537 893c1a4
• fix: fix some sonarqube warnings 7311b4e
• fix: revert array naming to pre 1202 behavior (e.g. _int4) PR#595 1d8ebfc
• refactor: rename dmlcommand -> sqlcommand 79db127
• perf: implement fast-path to TimeZone.getDefault if the cache field is accessible through reflection 6b3f2e0
• 🔴 feat: make connectTimeout=10 (seconds) by default b4d5976

aryabukhin (1):

• feat: add support for url-encoded JDBC URL property values PR#532 4c15f31

Marc Petzold (1):

• feat: support HSTORE in PgPreparedStatement#setObject(int, java.lang.Object, int, int) 785d0c7

goeland86 (1):

• fix: avoid NPE in new PgArray(, null).toString() PR#526 74b4972

Contributors to this release

We thank the following people for their contributions to this release.

AlexElin
Christian Ullrich
Christopher Deckers
Dave Cramer
Florin Asăvoaie
George Kankava
Jeremy Whiting
Laurenz Albe
Minglei Tu
Pavel Raiskup
Petro Semeniuk
Philippe Marschall
Tanya Gordeeva
Vladimir Sitnikov
aryabukhin
Marc Petzold
goeland86

Version 9.4.1208 (2016-02-16)

John Harvey (1):

• chore: rework update-translations.sh into pom file as a profile e2fa9ec

Dave Cramer (3):

• fix:regression from previous behaviour where setObject(index,object,VARHCAR) should call getString if it can't cast it to a string PR#482 9d6389c
• fix:correct comment PR#482 bfd73c7
• Update README.md PR#482 5a956a3

George Kankava (3):

• fix: squid:S1206 -equals(Object obj) and hashCode() should be overridden in pairs PR#515 a07d6d3
• fix: squid:S2325 - private methods that don't access instance data should be static PR#514 7aac95c
• fix: squid:S1488 - Local Variables should not be declared and then immediately returned or thrown PR#513 299c9f5

Gilles Cornu (1):

• docs: update travis-ci badge PR#475 f9405db

Jeremy Whiting (1):

• fix: load the ssl configuration property when defined through Properties. a6a61be

Markus KARG (1):

• docs: fix broken link to testing README PR#481 0a11144

Philippe Marschall (7):

• style: use java generics instead of raw types PR#463 c10acf0
• refactor: do not synchronize on ConcurrentHashMap PR#482 ea4cadd
• perf: add guards around debug log statements PR#469 d77aa41
• fix: Do not swallow security exceptions PR#471 beab720
• feat: implement resultSet.getObject(col, Class) with JSR-310 support PR#482 9aa3142
• feat: implement JSR-310 support in setObject e52f7e3
• fix: support local date times not in time zone 61384ec

Rikard Pavelic (1):

• perf: cache result of parsing server_version PR#464 9c43d27

Vladimir Sitnikov (24):

• doc: update current versions in readme.md PR#482 4f5d57c
• refactor: move implementation of Prepared and Callable statements to PgPreparedStatement and PgCallableStatement PR#459 8fca8b4
• style: add import order check PR#482 77a188c
• style: align import order with style convention PR#482 00c7eb3
• doc: add gitter chat link to readme PR#482 53190c9
• style: enable more checkstyle verifications PR#482 b0225f6
• style: reformat code to fix checkstyle violations PR#482 8f1c9d7
• style: reformat with Eclipse PR#467 2d5e7fa
• Update IDEA config PR#482 7083008
• docs: fix typos in code comments PR#472 5d43712
• style: update translations 484eafd
• doc: update russian translations 92011d7
• test: add insert .. on conflict tests for PostgreSQL 9.5 d622a9f
• fix: improve handling of DATE columns around DST dates in binary transfer 642b48a
• test: improve insertBatch test aea9383
• test: track code coverage PR#494 0f979c3
• test: PostgreSQL 8.4 and 9.5 databases, XA configuration PR#499 8c9898a
• fix: make sure executeBatch returns error response for rows that would not get into database PR#502 d6e3b17
• test: add benchmarks for insert via copy and insert via array of structs 880244e
• fix: PgArray returning null for binary arrays PR#504 b225535
• doc: backend protocol, wanted features PR#478 ee6118e
• fix: OSGi require-capability manifest entry PR#497 a3e2045
• fix: make sure {fn now()} jdbc translation is not performed in dollar-quoted strings PR#511 9109451

mtran (1):

• feat: ability to customize socket factory (e.g. for unix domain sockets) PR#457 dc1844c

Contributors to this release

We thank the following people for their contributions to this release.

John Harvey
Dave Cramer
George Kankava
Gilles Cornu
Markus KARG
Rikard Pavelic
Jeremy Whiting
Vladimir Sitnikov
Stephen Nelson
Philippe Marschall
mtran

Version 9.4.1207 (2015-12-23)

Jeremy Whiting (3):

• Changed property loader to avoid using a default when property not already set. Allows the caller to detect when unset. Thus allowing connection Cto use programmatic log level value. Added test cases to check PGProperty method working properly. PR#438 ecf4a2c
• Update testcase to set properties where TestUtil methods look them up. PR#438 b86e07a
• Restore boot time ssl property after test cases complete. Revert change to assertion test. Safely remove existing ssl property. PR#438 274f382

Philippe Marschall (2):

• Fix null check in getTablePrivileges PR#453 244ce59
• Useless condition in parseQuery PR#454 dd229d5

Stephen Nelson (1):

• chore: migrate the build to Maven PR#322 f470f05

Vladimir Sitnikov (12):

• doc: add coding guidelines to readme PR#442 af62c6d
• chore: remove docbkx/pgjdbc.xml from reposiory PR#435 92b65f0
• chore: move files to "pgjdbc" maven module to prepare for pre-processor fix PR#435 f95b44e
• chore: use java comment preprocessor to build jre6/jre7/jre8 jars from the same sources PR#435 42c2e3b
• doc: fix javadocs warnings when building via java 8 PR#435 3b10873
• test: improve CopyLargeFileTest performance by dropping non required index and foreign key PR#435 410a662
• test: speedup DriverTest.testConnectFailover by adding a connect timeout of 5 seconds PR#435 ed1a916
• chore: skip gpg signature when deploying snapshot artifacts via Travis PR#449 d196cf4
• chore: use custom settings.xml when deploying snapshots via Travis PR#449 cf40cf2
• test: add test for insert batch that changes server-prepared statement names PR#449 e5ac899
• fix: prepared statement "S_2" does not exist in batch executions PR#449 fa310e0
• doc: add note on how to skip tests when building from source PR#460 823e124

Yao Chunlin (1):

• Fix bug when call XAResource.start with TMJOIN flag, the old localAutoCommitMode lost. PR#434 df09e2b

Contributors to this release

We thank the following people for their contributions to this release.

Jeremy Whiting
Vladimir Sitnikov
Stephen Nelson
Philippe Marschall
Yao Chunlin

Version 9.4-1206 (2015-11-25)

Andrea Catalucci (1):

• Fixed typo in Driver.java.in PR#428 2589020

Dave Cramer (3):

• make sure logs actually get written PR#422 2ad367e
• fix: Binary handling of empty arrays. The type of the empty array was not properly read as a result getting the type of the array caused an NPE fixes Issue #421 reported by Juha Komulainen PR#422 38d8488
• fix:building on java 1.6 PR#422 9133012
• fix test case to actually check the value don't mask the exception in the event that it is thrown PR#422 e975c07
• add an explicit message for the test case PR#422 270b1a3

Laurenz Albe (3):

• Replace question marks only in PreparedStatements PR#427 3d30a4c
• Allow both single and double question marks in simple statements PR#427 39d510c
• Prettify code and add another regression test PR#427 2f8a67f

Vladimir Sitnikov (3):

• chore: fix dos end-of-lines PR#418 63d1dd3
• test: add tests for getBigDecimal of int4 field in both text and binary modes PR#426 faac288
• fix: fix invalid values when receiving int2, int4, int8 via getBigDecimal() PR#424 e6f1beb

John K. Harvey(1)

• fix: update translations to handle Russian characters PR#430 this hasn't been committed yet but the message class files were updated

Contributors to this release

We thank the following people for their contributions to this release.

[John K Harvey] (https://github.com/crunchyjohn)
Andrea Catalucci
Laurenz Albe
Vladimir Sitnikov

[dmikurube]

I'd like to leave making decisions and actual changes upon @embulk/jdbc-maintainers as I am not an expert there.

Inputs from @embulk/core-team and anyone else would be also welcome.