PostgreSQL JDBC Driver 42.1.2 Released


  • 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


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


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

Commits by author

AlexElin (1):

Dave Cramer (8):

  • Initial support of partitioned tables via JDBC metadata API PR 823 9c3471f2
  • fix javadoc complaints and some small edits to replication comments PR 832 2d0bfceb
  • fix issue #834 setting statusIntervalUpdate causes high CPU load \ PR 835 59236b74
  • fix issue #838 make sure we don’t get columns that are dropped PR 840 464a2d43
  • add missing connection documentation, fix spelling PR 846 cd400f6f
  • more spelling mistakes for preferQueryMode PR 850 73bc3c1b
  • fix formatting of section on failover, still not perfect but better PR 852 9f722014
  • small reformat to clarify read and write connections PR 854 551d71b6

Jorge Solorzano (3):

Robert ‘Bobby’ Zenz (1):

  • fix: Add fallback to setObject(int, Object) for Number PR 812 5b9edb7d

Vladimir Gordiychuk (1):

Vladimir Sitnikov (7):

  • chore: implement a script to stage pgjdbc, pgdjbc-jre7, pgjdbc-jre6 artifacts 15d78839
  • doc: fix 42.1.0.jre8->jre6 typo PR 42 88942b58
  • fix: use server-prepared statements for batch inserts when prepareThreshold>0 abc3d9d7
  • fix: better parsing for returning keyword PR 824 201daf1d
  • docs: build index, changelog pages from _posts/… to reduce release overhead d6fe07d7
  • chore: make ./ create docs/_posts/$DATE_YMD-$ file e00d4571
  • docs: add 42.1.2 release notes 6f127a61

Contributors to this release

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


Dave Cramer

Jorge Solorzano

Robert ‘Bobby’ Zenz

Vladimir Gordiychuk

Vladimir Sitnikov