PostgreSQL JDBC Driver 42.2.6 Released

Notable Changes

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

Commits by author

Adam Brusselback (1):

Add method alias’s for each property which didn’t use the conventiona… PR 1436 0efcf81c

AlexElin (6):

chore: add .editorconfig PR 1410 61cc2756
style: enable checkstyle modules for name checking PR 1411 6b124a05
test: add tests for Driver and PgConnection PR 1402 7b52b0c9
chore: add EmptyStatement checkstyle rule PR 1400 4cd3f05a
chore: add StaticVariableName checkstyle rule PR 1414 ddb38e57
chore: enable AtclauseOrder checkstyle rule PR 1417 7ae1e833

Andrew Guibert (1):

Fix inconsistent javadoc for setDefaultAutoCommit PR 1472 fac5e09c

Craig Ringer (2):

fix: NPE in PGXAConnection$ConnectionHandler.invoke() of .equals(null) PR 1365 cea5231b
Update waffle-jna to new artifact coordinates PR 1383 72dc692e

Dave Cramer (31):

docs: update README.md for SSL tests 1fff6043
Update mailinglist.html 556c93d3
chore: add jdk11 and jdk12-ea tests to travis b53eedf6
fix: autosave being overwritten in BaseDataSource by setUrl PR 1309 10201f61
perf: ignore tables for PgDatabaseMetaData.getTypeInfo PR 1302 e44e4e89
Update issue_template.md f3ade07d
Remove tests that use oids fixes PR 1347 (#1348) da4d6577
Fix setURL in BaseDataSource PR 1341 2ad1ac3f
Add support for version 11 and version 12 PR 1332 7f0e200a
fix missing metadata columns, and misspelled columns PR 1323 0ed0e8f2
fix: Incorrect return value for bytes [128-255] in stream.read PR 1349 325e63b4
fix: as of v12 recovery.conf is no longer used for standby recovery. … PR 1355 c4656b32
Update pull_request_template.md PR 1367 be23262b
Update README.md 2a639fd6
Fix formatting c0f6b9bd
Update README.md PR 1404 65f7ea6f
add matrix including master to test PR 1408 5965f399
Fix:save points causing server to run out of resources PR 1409 af8f8836
use postgres column type name in error message PR 1422 fe7eda3d
fix: Test Case HostSpecTest , tests testShouldResolveWithEmptySocksProxyHost and testShouldResolveWithWhiteSpaceSocksProxyHost PR 1424 0c5cf475
Update checkstyle to 8.18 PR 1447 ed5f750b
fix javadoc for defaultAutoCommit to default to true PR 1465 0a4f078e
autocommit true turns on autocommit by default 31bc6e59
remove reference to unknown google group PR 1429 129960ea
Update backend_protocol_v4_wanted_features.md 95ba7b26
some fixbugs cleanup PR 1486 8bd9062f
change IS_GENERATED to IS_GENERATEDCOLUMN as per spec PR 1485 17c4bcfb
undo part of fixbugs pull request that set returned NULL mistakenly PR 1489 27b8fcae
fix: Error messages cannot be formatted PR 1492 12ef697a
fix PR 1499 rounding for timestamps truncated to dates before 1970 (#1502) c9a70782
Fix maven coordinates PR 1479 45ce14fd

Dmitriy Tseyler (1):

fix: return Double. NaN for ‘NaN’::numeric PR 1304 265f22b2

Doug Mayer (1):

Add core type delimiters into cache for array type OIDs. PR 1416 6a0960a6

Harry Chan (1):

Optimize toArray PR 1395 (#1396) 2341623b

Ivan Leskin (1):

Support custom ‘options’ connection property PR 1356 7be21fc3

Jorge Solorzano (2):

feat: return info on create slot of replication PR 1335 84e8d90b
test: fix misspelled secondaryPort2 build property PR 1284 2c0f692b

Kamal Kumlien (1):

docs: cosmetic fixes on sample settings PR 1379 d0453b75

Kevin Wooten (1):

Fixes LocalDateTime handling of BC dates PR 1388 ebada4af

Krzysztof Szafrański (1):

Fix logging level PR 1446 f8c112cb

Marc Dean (1):

Add DEADLOCK_DETECTED Enumeration PR 1380 a7f63bff

Mark Nguyen (1):

docs: Add DEM format details for sslkey PR 1376 10945e34

Mykola Nikishov (2):

Fix link to Test Suite Howto PR 1369 33ac76d1
refactor: remove unused method encode3to4 from Base64 PR 1370 bac4bc1a

Nikolai Ivanov (1):

fix: improper relative cursor movement PR 1462 b6ab27c1

Philip Sanetra (1):

feat: Extend ReplicationCreateSlotBuilder DSL to support temporary replications slots PR 1306 d514ceb5

Sehrope Sarkuni (4):

Fix TestUtil.dropXyz(…) object not exists errors PR 1359 0999bb78
refactor: Clean up loading of reading of keydata file in LazyKeyManager PR 1372 9b45e709
Fix metadata test to use explicit PK/FK names PR 1442 42d6bfa5
Cleanup encoding PR 1441 73ec8173

Sualeh Fatehi (2):

Fix: getFunctionColumns used to return ProcedureColumns, now returns function columns b8a86807
Update testing documents, and point to jackdb/pgjdbc-test-vm PR 1363 2a715a98

Tyson Andre (1):