PostgreSQL JDBC Driver 42.0.0 Released

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 semantic 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 acepted (previusly !=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

You may have noticed the change in the versioning of the driver, you can read the FAQ for more information.

Commits by author

AlexElin (6):

refactor: use varargs PR 681 50b7fe0f
refactor: make HostChooser implement Iterable PR 645 3d37db78
refactor: migrate to Junit4 PR 682 f4a067cc
refactor: remove deprecated Utils' methods PR 678 0275d40f
refactor: migrate tests to junit4 PR 685 faab4998
refactor: remove checks for jdk version 1.4 (tests) PR 737 ee51dfce

Eric McCormack (1):

fix: accept server version with more than 3 parts PR 741 8437f6c1

Jordan Lewis (1):

feat: do not use pg_depend against PostgreSQL 9.0+ PR 689 62e25fba

Jorge Solorzano (22):

refactor: remove support for postgresql < 8.2 PR 661 14e64be7
fix: add query to support postgresql 8.2 without t.typarray PR 699 cb3995b5
test: add CI tests against PostgreSQL 8.3 PR 710 436365b0
fix: robust castToBoolean for setObject in PreparedStatement PR 714 edc2a14a
refactor: remove unused V2ReplicationProtocol.java PR 718 7881e41e
test: ignore tests that don’t apply to Pg8.2 and Pg8.3 PR 703 3bc0951e
style: reorder checkstyle in travis PR 721 ba812fb4
refactor: remove charset property not used PR 709 f6fd5a5a
fix: huntbugs on PgDatabaseMetaData, String concatenation in a loop PR 693 3a00ef94
refactor: fix getDriverVersion, getDriverName and getJDBCMajor/MinorVersion methods PR 668 aa974341
docs: reword supported versions, include datasources section, compare versions PR 673 b2cdd057
test: fix test replication on PG_HEAD PR 734 3b406a18
refactor: deprecated PGPoolingDataSource PR 739 55e2cd16
fix: strict handling of getBoolean and setObject with postgres accepted values PR 732 4942f7d1
docs: move docs from www/documentation/head PR 744 70e23c45
test: fix replication test in Pg10 PR 746 63ed2129
feat: use java.util.logging PR 722 43e6505e
perf: short circuit Oid. BOOL in getBoolean PR 745 e69e4a1d
fix: add isLoggable around parameterized logger PR 752 8b50cfe5
docs: move www repository to pgjdbc/docs d4e99198
add syntax highlight to documentation 8c035ade
add more style 9c510e65

Pavel Raiskup (3):

fix: sync with latest Fedora PR 637 a29ad80b
packaging: rpm: update srpm generator 5c3c9239
packaging: rpm_ci: use curl -L to download rawhide logs c8125cff

Philippe Marschall (3):

refactor: clean up PgDatabaseMetaData PR 692 d32b077e
refactor: delete Keyword enum PR 697 677e3c4c
feat: support microsecond resolution for JSR-310 types PR 691 6b3a1efb

Roman Ivanov (2):

config: move version of checkstyle to property PR 723 9ef7d6f1
chore: upgrade checkstyle to 7.4, make checkstyle version configurable via property PR 725 e1a25782

Steve Ungerer (1):

fix: ensure executeBatch() does not use server-side prepared statements when prepareThreshold=0 PR 690 aca26a07

Trygve Laugstøl (1):

feat: connect the socket only if the socket factory created an unconnected socket PR 587 f75572be

Vladimir Gordiychuk (4):

bug: fix not enscaped special symbol that fail build PR 686 b4604cd7
feat: add replication protocol API PR 550 f48c6bb7
test: fix drop replication slot on 9.4 for tests PR 696 c1c48bd7
chore: Gather backtrace from core dump on CI PR 736 da5e4ef1

Vladimir Sitnikov (12):

fedora: add BuildRequires: classloader-leak-test-framework 64b6750c
tests: remove Class.forName(..driver..) from test code c99507b5
test: add CI tests against PostgreSQL 8.2 PR 659 63ee60e2
feat: display error position when SQL has unterminated literals, comments, etc PR 688 8a95d991
feat: add support for PreparedStatement.setCharacterStream(int, Reader) PR 671 ee4c4265
chore: update next version to 42.0.0-SNAPSHOT 46634923
refactor: add CallableQueryKey#equals override 401c51a1
doc: correct wording in readme regarding PostgreSQL versions used in pgjdbc regression testing 60391d75
fix: revert ExpressionProperties to Properties in BaseDataSource 989b4d23
fix: correct edge cases for setCharacterStream(int, Reader) f1190d8c
test: add SharedTimerClassLoaderLeakTest to the regular test suite b3553276
refactor: wrap more log statements with isLoggable check 07d225ec

bd-infor (1):

docs: clarify handling of loglevel PR 711 6334bac0

Contributors to this release

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