v42.2.10

What's Changed

• Fix test case by changing executeQuery to execute by @mahmoudbahaa in #1642
• Test case and documentation for calling stored procedures with transaction control. by @draderaws in #1645
• Add disallow multiple empty lines by @sehrope in #1427
• fix: Unable to register out parameter Issue #1646 by @davecramer in #1648
• remove more currentTimeMillis in order to get tests to be more reliable by @davecramer in #1647
• fix: unstable test. Originally this would loop creating many statements, now it should timeout properly by @davecramer in #1650
• remove receiving EOF from backend after cancel … by @mahmoudbahaa in #1641
• fix: issue 1482 where the port was being added to the GSSAPI service name by @davecramer in #1651
• style: Preparing for upcoming Checkstyle release 8.28 by @gmshake in #1654
• Fix interval overflow by @reibitto in #1658
• feat: add caller push of binary data (rebase of #953) by @paplorinc in #1659
• chore: upgrade checkstyle to 8.28 by @gmshake in #1660
• feat: Add maxResultBuffer property by @adrklos in #1657
• Utf 8 encoding optimizations by @bokken in #1444
• Metadata queries improvements. by @bjanczak in #1673
• be explicit about which JDK by @davecramer in #1672
• fix: actually use milliseconds instead of microseconds for timeouts by @davecramer in #1653
• fix: #1677 NumberFormatException when fetching PGInterval with small value by @baardsen in #1678
• minor: fix checkstyle violation of unused import by @romani in #1683
• fix streaming error with a unstable network connection by @hyunkshinft in #1681
• fix: Issue #1680 updating a boolean field requires special handling to set it to t or f instead of true or false by @davecramer in #1682
• Fix Network Performance of PgDatabaseMetaData.getTypeInfo() method by @dupski in #1668
• add DatabaseMetaDataCacheTest to test suite to run it by @davecramer in #1685
• clean up 1648 - sync error message value with tested value by @draderaws in #1664
• Fixing LocalTime rounding (losing precision) by @franetw in #1570
• fix: Fixes issue #1592 where one thread is reading the copy and another thread closes the connection by @davecramer in #1594
• Cleanup PGProperty, sort values, and add some missing to docs by @sehrope in #1686
• chore(deps): bump checkstyle from 8.28 to 8.29 in /pgjdbc by @dependabot in #1691
• WIP release notes for 42.2.10 by @davecramer in #1688
• Metadata queries improvment by @bjanczak in #1694

New Contributors

• @gmshake made their first contribution in #1654
• @reibitto made their first contribution in #1658
• @bjanczak made their first contribution in #1673
• @baardsen made their first contribution in #1678
• @hyunkshinft made their first contribution in #1681
• @dupski made their first contribution in #1668
• @franetw made their first contribution in #1570
• @dependabot made their first contribution in #1691

Full Changelog: REL42.2.9...REL42.2.10

v42.2.9

What's Changed

• upgrade maven-checkstyle-plugin to 3.1.0 by @rnveach in #1573
• attempt at fixing DataSources broken by connection failover urls (#1039) by @teicher in #1457
• feat: support for large update counts (JDBC 4.2) by @jorsol in #935
• Fix Markdown formatting issue by @knutwannheden in #1576
• fix documentation on generating the pk8 key. closes: #1585 by @magwas in #1586
• fix: camel case writing of 'cleanupSavepoints' by @tbrodbeck-adc in #1587
• Clean up some tests and fix IsValidTest race condition by @sehrope in #1581
• Add simple test to make sure we can load a key by @davecramer in #1588
• Fix test suite order by @sehrope in #1593
• fix: add release save point into execute with batch by @junixar in #1583
• Perform ssl handshake after socket timeout and buffer size settings by @michail-nikolaev in #1584
• Update authentication methods supported to include gss by @davecramer in #1601
• security notice and clarifications by @magwas in #1591
• fix: issue 716 getTypeInfo() may not return data in the order specified in Oracle documentation by @davecramer in #1506
• Fix exception on PGCopyOutputStream.close() after endCopy() (#1574) by @virtual-machinist in #1575
• fix: Update error message for COPY commands executed using JDBC API by @sehrope in #1300
• Add connection property to limit server error detail in exception exceptions by @sehrope in #1579
• chore: Document how to use unix domain sockets. by @davecramer in #1607
• fix: PgSQLXML setCharacterStream() results in null value by @davecramer in #1608
• add test for table name with values in it by @davecramer in #1609
• fix: get correct column length for simple domains by @davecramer in #1605
• fix: NPE as a result of calling executeQuery twice on a statement by @davecramer in #1610
• fix:handle numeric domain types by @davecramer in #1611
• add checks for null results by @davecramer in #1616
• feat: read only transactions by @bokken in #1252
• fix: pginterval to take iso8601 strings by @davecramer in #1612
• New "escapeSyntaxCallMode" connection property by @gregn123 in #1560
• fix: allow OUT parameter registration when using CallableStatement na… by @gregn123 in #1561
• Adjust the default port to 5432. by @ldming in #1619
• fix: remove currentTimeMillis from code, tests are OK by @davecramer in #1617
• fix: NPE when calling setNull on a PreparedStatement with no parameters by @davecramer in #1620
• doc: correct documentation about last applied message fixes #760 by @davecramer in #1621
• feat: Add cancelQuery() to PGConnection public interface by @sehrope in #1157
• docs: fix documentation about oids by @davecramer in #1624
• fix: javadoc requires throws annotation by @davecramer in #1625
• fix: Add pkcs12 key functionality by @davecramer in #1599
• Actually test cleanSavePoints by @davecramer in #1509
• fix: DatabaseMetaData.getFunctions should not limit the search to the search_path if the schema is provided by @davecramer in #1633
• feat: WIP Filter DatabaseMetaData using privileges for the user by @davecramer in #1630
• fix: null pointer exception from PgResultSetMetaData when there's no column metadata by @IvyDev0 in #1615
• Add Binary Support for Oid.NUMERIC and Oid.NUMERIC_ARRAY by @mahmoudbahaa in #1636
• Only allow binary transfer for those Oids that the pgjdbc currently s… by @mahmoudbahaa in #1637
• Prevent use of extended query protocol for BEGIN before COPY by @ringerc in #1639
• new pr for release notes by @davecramer in #1640
• use TestUtil to find path of certdir by @davecramer in #1643

New Contributors

• @teicher made their first contribution in #1457
• @knutwannheden made their first contribution in #1576
• @magwas made their first contribution in #1586
• @tbrodbeck-adc made their first contribution in #1587
• @junixar made their first contribution in #1583
• @michail-nikolaev made their first contribution in #1584
• @virtual-machinist made their first contribution in #1575
• @gregn123 made their first contribution in #1560
• @ldming made their first contribution in #1619
• @IvyDev0 made their first contribution in #1615

Full Changelog: REL42.2.8...REL42.2.9

v42.2.8

What's Changed

• fix release notes for jekyll by @davecramer in #1566
• fix: Revert inet to return as a string and handle values with net masks by @sehrope in #1568
• release notes for 42.2.8 by @davecramer in #1571

Full Changelog: REL42.2.7...REL42.2.8

v42.2.7

What's Changed

• Add more info about currentSchema property by @vskaiman in #1481
• fix parent version in pgjdbc/pom.xml as well by @praiskup in #1522
• Expose parameter status messages (GUC_REPORT) to the user by @ringerc in #1435
• Make ConnectTimeout test accept NoRouteToHostException by @ringerc in #1526
• docs: Add note to GitHub PR templates about test suites by @sehrope in #1531
• Sort test suites and enable missed tests by @sehrope in #1530
• docs: add note on behavior of ResultSet.getString() (#1286) by @mshajarrazip in #1528
• Issue 1134 Map inet type to InetAddress by @myowaithant9 in #1527
• Updated scram to version 2.0 by @teoincontatto in #1532
• docs: update resultset.md in head to reflect 94 (#1528) by @mshajarrazip in #1536
• add automatic module name to manifest for jdk9+ by @davecramer in #1538
• fix issue 1547, as long as peek returns some bytes do not reset the t… by @davecramer in #1548
• fix: proleptic java.time support by @marschall in #1539
• fix: In logical decoding the if the backend was requesting a reply we… by @davecramer in #1467
• Log ignoring rollback when no transaction in progress by @davecramer in #1549
• Check that JDBC Connections that are closed by the server do not repo… by @timothyjward in #1533
• fix assertion message by @davecramer in #1553
• try trusty with 8.3 by @davecramer in #1550
• Add an apache karaf feature for the PostgreSQL JDBC driver to fix #1552 by @steinarb in #1554
• Ensure isValid() will not last more than timeout seconds by @arobert-delfingen in #1557
• Release/master by @davecramer in #1565

New Contributors

• @vskaiman made their first contribution in #1481
• @mshajarrazip made their first contribution in #1528
• @myowaithant9 made their first contribution in #1527
• @teoincontatto made their first contribution in #1532
• @timothyjward made their first contribution in #1533
• @steinarb made their first contribution in #1554
• @arobert-delfingen made their first contribution in #1557

Full Changelog: REL42.2.6...REL42.2.7

v42.2.6

What's Changed

• docs: update README.md for SSL tests by @davecramer in #1294
• Let ResultSet.getObject() return Float.NaN in case of numeric NaN by @tseylerd in #1304
• feat: Extend ReplicationCreateSlotBuilder DSL to support temporary replications slots by @PSanetra in #1306
• fix: autosave being overwritten in BaseDataSource by setUrl by @davecramer in #1309
• perf: ignore tables for PgDatabaseMetaData.getTypeInfo by @davecramer in #1302
• perf: fix 1ms per async CopyAPI (regression since 42.2.5) by @vlsi in #1314
• Remove tests that use oids fixes #1347 by @davecramer in #1348
• docs: fix link to the pull request in 42.2.3 changelog by @itchyny in #1345
• Fix setURL in BaseDataSource by @davecramer in #1341
• Add support for version 11 and version 12 by @davecramer in #1332
• feat: return info on create slot of replication by @jorsol in #1335
• fix missing metadata columns, and misspelled columns by @davecramer in #1323
• fix: Incorrect return value for bytes [128-255] in stream.read by @davecramer in #1349
• Issue 1106 by @sualeh in #1350
• fix: as of v12 recovery.conf is no longer used for standby recovery. … by @davecramer in #1355
• Allow setFlushedLSN(lsn) and setAppliedLSN(lsn) from outside main loop by @pbillen in #1329
• test: fix wrong secondaryPort2 build property by @jorsol in #1284
• Fix typos in docs/ by @TysonAndre in #1361
• Fix TestUtil.dropXyz(...) object not exists errors by @sehrope in #1359
• Support custom 'options' connection property by @leskin-in in #1356
• chore: use openjdk7 to boostrap Travis CI images for JDK 6 by @vlsi in #1366
• Fix NPE in PGXAConnection$ConnectionHandler.invoke() of .equals(null) by @ringerc in #1365
• Update pull_request_template.md by @davecramer in #1367
• Update testing documents, and point to jackdb/pgjdbc-test-vm by @sualeh in #1363
• Fix link to Test Suite Howto by @manandbytes in #1369
• refactor: remove unused method encode3to4 from Base64 by @manandbytes in #1370
• refactor: Clean up loading of reading of keydata file in LazyKeyManager by @sehrope in #1372
• docs: Add DEM format details for sslkey by @Mrk-Nguyen in #1376
• Update waffle-jna to new artifact coordinates by @ringerc in #1383
• docs/chore: Add DEADLOCK_DETECTED Enumeration by @deanmarc25 in #1380
• Fixes LocalDateTime handling of BC dates by @kdubb in #1388
• Optimize toArray (#1395) by @re-thc in #1396
• pgJDBC - StatementTest hangs in Windows 7 / 2012 / 2016 by @jajalvipul in #1406
• add appveyor build status badg by @davecramer in #1404
• add matrix including master to test by @davecramer in #1408
• chore: add .editorconfig by @AlexElin in #1410
• style: enable checkstyle modules for name checking by @AlexElin in #1411
• test: add tests for Driver and PgConnection by @AlexElin in #1402
• chore: add EmptyStatement checkstyle rule by @AlexElin in #1400
• chore: add StaticVariableName checkstyle rule by @AlexElin in #1414
• Add core type delimiters into cache for array type OIDs. by @doxavore in #1416
• chore: enable AtclauseOrder checkstyle rule by @AlexElin in #1417
• Fix:save points causing server to run out of resources by @davecramer in #1409
• use PostgreSQL column type name in error message by @davecramer in #1422
• fix:Test Case HostSpecTest , tests testShouldResolveWithEmptySocksPro… by @davecramer in #1424
• fix: improper indentation for javadoc by @rnveach in #1434
• test: fix metadata test to use explicit PK/FK names by @sehrope in #1442
• Fix logging level by @kszafran in #1446
• Update checkstyle to 8.18 by @davecramer in #1447
• style: remove extra empty lines by @kazachka in #1452
• fix: improper relative cursor movement by @nicktorwald in #1462
• Fix execution with big decimal in simple query mode. by @kaiwangchen in #1463
• fix: fix javadoc for defaultAutoCommit to default to true by @davecramer in #1465
• Cleanup encoding by @sehrope in #1441
• remove reference to unknown google group by @davecramer in #1429
• Add method alias's for each property which didn't use the conventiona… by @Tostino in #1436
• Fix inconsistent javadoc for setDefaultAutoCommit by @aguibert in #1472
• style: remove extra empty lines by @kazachka in #1454
• docs: cosmetic fixes on sample logging settings by @kkumlien in #1379
• some fixbugs cleanup by @davecramer in #1486
• change IS_GENERATED to IS_GENERATEDCOLUMN as per spec by @davecramer in #1485
• undo part of fixbugs pull request that set returned NULL mistakenly by @davecramer in #1489
• fix: Error messages cannot be formatted by @davecramer in #1492
• Make LogSequenceNumber implement Comparable by @maltalex in #1494
• fix #1499 rounding for timestamps truncated to dates before 1970 by @davecramer in #1502
• Fix maven coordinates by @davecramer in #1479
• Revert "Fix maven coordinates" by @davecramer in #1507
• Release notes for 42.2.6 by @vlsi in #1511

New Contributors

• @tseylerd made their first contribution in #1304
• @PSanetra made their first contribution in #1306
• @itchyny made their first contribution in #1345
• @sualeh made their first contribution in #1350
• @pbillen made their first contribution in #1329
• @TysonAndre made their first contribution in #1361
• @leskin-in made their first contribution in #1356
• @manandbytes made their first contribution in #1369
• @Mrk-Nguyen made their first contribution in #1376
• @deanmarc25 made their first contribution in #1380
• @kdubb made their first contribution in #1388
• @re-thc made their first contribution in #1396
• @jajalvipul made their first contribution in #1406
• @doxavore made their first contribution in #1416
• @kszafran made their first contribution in #1446
• @kazachka made their first contribution in #1452
• @nicktorwald made their first contribution in #1462
• @kaiwangchen made their first contribution in #1463
• @Tostino made their first contribution in #1436
• @aguibert made their first contribution in #1472
• @kkumlien made their first contribution in #1379
• @maltalex made their first contribution in #1494

Full Changelog: REL42.2.5...REL42.2.6

v42.2.5

What's Changed

• refactor: remove unused PgPreparedStatement.adjustIndex by @vlsi in #1253
• chore: remove editor backup files by @df7cb in #1255
• Update Contributing.md by @davecramer in #1262
• test: run testShortQueryTimeout in PG_VERSION=HEAD Travis job only by @vlsi in #1270
• fix: remove POT-Creation-Date from generated .po and .pot files by @vlsi in #1269
• fix: use UTF-8 encoding in generated translation/messages_*.java files by @vlsi in #1271
• Fix Japanese translation by @horiguti in #1275
• Add issue templates by @davecramer in #1263
• move issue template and pull request template into github specific di… by @davecramer in #1283
• fix: Correct typo in CopyManager comment by @sehrope in #1285
• Fix typos detected by github.com/client9/misspell by @seratch in #1287

New Contributors

• @df7cb made their first contribution in #1255
• @horiguti made their first contribution in #1275
• @seratch made their first contribution in #1287

Full Changelog: REL42.2.4...REL42.2.5

v42.2.4

What's Changed

• Fixed typo in CHANGELOG.md by @ckotzbauer in #1249
• fix: setNull for types not in java.sql.Types (e.g. uuid) by @davecramer in #1160
• fix: treatment of SQL_TSI_YEAR, SQL_TSI_WEEK, SQL_TSI_MINUTE by @vlsi in #1250
• fix: map integrity constraint violation to XA_RBINTEGRITY instead of XAER_RMFAIL by @janvdbergh in #1175
• docs: update site for 42.2.4 by @vlsi in #1251

New Contributors

• @ckotzbauer made their first contribution in #1249
• @janvdbergh made their first contribution in #1175

Full Changelog: REL42.2.3...REL42.2.4

v42.2.3

What's Changed

• fix: getString for PGObject columns returns null by @KimBisgaardDmi in #1154
• Fix typos in java8-date-time.md by @elaatifi in #1174
• refactor: deprecate Fastpath API by @AlexElin in #903
• spelling mistake correction by @kommiharibabu in #1181
• fix: allow disabling field metadata cache by @znep in #1052
• fix: error on travis build head postgres by @jorsol in #1186
• set the loggerName of the locally generated LogRecords (#1167) by @kommiharibabu in #1188
• docs: fix link to GitHub documentation by @bersace in #1191
• test: add coverage for extendedCacheEverything by @jorsol in #1062
• chore: update after_n_builds to 10 by @jorsol in #1193
• test: drop openj9 unstable build by @jorsol in #1196
• refactor: migrate MultiHostsConnectionTest to JUnit4 by @AlexElin in #886
• fixed spelling mistake in PostgreSQL by @davecramer in #1202
• fix: support parenthesis in {oj ...} JDBC escape syntax #865 by @AlBundy33 in #1204
• chore: update gettext plugin by @vlsi in #1209
• fix: adjust date, hour, minute, second when rounding timestamp by @vlsi in #1212
• chore: remove ubenchmark module due to licensing issues by @vlsi in #1215
• fix: support query timeouts exceeding 2147483 seconds (~25 days) by @vlsi in #1224
• perf: improve performance of replacing JDBC {...} escapes by @vlsi in #1230
• chore: add missing javadoc tags to avoid warnings by @lordnelson in #1164
• style: rephrase comment on named portals by @bpd0018 in #1129
• Encode url parameters by @bazzargh in #1201
• refactor: simplify PgConnection.java by @AlexElin in #1047
• perf: guard logging statements by @jesperpedersen in #1112
• fix javadocs by @davecramer in #792
• Update CONTRIBUTING.md by @michele-mancioppi in #859
• refactor: remove obsolete outParmBeforeFunc by @benbenw in #1234
• perf: improve parsing performance of JDBC-style { call ...} calls by @benbenw in #1233
• fix: logger should be generally quiet by @jorsol in #1187
• docs: improve CONTRIBUTING.md by @jorsol in #951
• docs: use "PR 42" references instead of "PR#42" in the changelog by @vlsi in #1239
• minor language updates by @davecramer in #1241
• test: close of replication connection has not been fixed at backend side, so disable the test till 12.1 by @vlsi in #1243
• chore: Correct the Javadoc and enforce with Checkstyle by @lordnelson in #1236
• perf: avoid string allocation for oid/rows parsing in command tag by @vlsi in #1232
• chore: update parent versions to 1.1.4 to enforce Javadoc warnings as errors by @vlsi in #1248

New Contributors

• @KimBisgaardDmi made their first contribution in #1154
• @elaatifi made their first contribution in #1174
• @kommiharibabu made their first contribution in #1181
• @znep made their first contribution in #1052
• @bersace made their first contribution in #1191
• @AlBundy33 made their first contribution in #1204
• @bazzargh made their first contribution in #1201
• @michele-mancioppi made their first contribution in #859
• @benbenw made their first contribution in #1234

Full Changelog: REL42.2.2...REL42.2.3

v42.2.2

What's Changed

• Fixes #1096 by @veselov in #1097
• docs: fix spelling and chapter, update sample code by @bpd0018 in #1098
• Use Locale.Category.DISPLAY when selecting resource bundle. by @trtrmitya in #1115
• fix: handle Timestamp values with fractional seconds < 1 microsecond correctly in PreparedStatement arguments by @stellingsimon in #1119
• style: spelling in comment by @bpd0018 in #1121
• docs: fix JavaDoc for getPreferQueryMode() by @bpd0018 in #1122
• fix: ArrayIndexOutOfBoundsException when using the same SQL for regular and updateable resultset by @vlsi in #1123
• fix: support insert ... on conflict...update for reWriteBatchedInserts=true by @vlsi in #1130
• fix: allowEncodingChanges should allow set client_encoding=... by @vlsi in #1125
• fix: wrong data from Blob/Clob when mark/reset is used by @sfeigl in #971
• Adjust XAException return codes for better compatibility with XA specification by @ochaloup in #782
• fix: wrong results when a single statement is used with UNSPECIFIED types by @vlsi in #1137
• test: add Travis configuration to test SSL by @davecramer in #1095
• docs: improve documentation and tests for server-side prepared statements by @vlsi in #1135
• fix: improve DatabaseMetaData.getSQLKeywords() by @jorsol in #940
• test: make testAlternatingBindType Java 6-compatible by @vlsi in #1139
• fix: support generated keys for WITH queries by @vlsi in #1138
• docs: release notes for 42.2.2 by @vlsi in #1142

New Contributors

• @veselov made their first contribution in #1097
• @trtrmitya made their first contribution in #1115
• @stellingsimon made their first contribution in #1119
• @sfeigl made their first contribution in #971
• @ochaloup made their first contribution in #782

Full Changelog: REL42.2.1...REL42.2.2

42.2.1

What's Changed

• chore: remove braces for LeftCurlyCheck issue checkstyle by @vaano94 in #1075
• chore: remove additional braces for LeftCurlyCheck checkstyle by @vaano94 in #1076
• test: check if url is not for PostgreSQL by @AlexElin in #1077
• Fixes issue #1078 by @JCzogalla in #1079
• fix: avoid connection failure when DateStyle is set to ISO by @vlsi in #1081
• add support for fetching 'TIMESTAMP(6) WITHOUT TIME ZONE' as LocalDate by @alexanderkjall in #1083
• Fix style changelog by @jorsol in #1089
• fix: reWriteBatchedInserts=true causes syntax error with on conflict by @vlsi in #1082
• fix: package scram:client classes, so scram works when using a shaded jar by @davecramer in #1091
• fix: getPGArrayType fails in when stringType=unspecified by @JamiePullar in #1036
• docs: prepare release notes for 42.2.1 by @vlsi in #1093

New Contributors

• @vaano94 made their first contribution in #1075
• @JCzogalla made their first contribution in #1079
• @JamiePullar made their first contribution in #1036

Full Changelog: REL42.2.0...REL42.2.1