[pgjdbc/pgjdbc] f28a57: Introduce AutoSave = SERVER functionality

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [pgjdbc/pgjdbc] f28a57: Introduce AutoSave = SERVER functionality
Date: 2018-08-03 14:56:06
Message-ID: 5b646d071cf_18dd22ab590e76f8819841@hookshot-fe-dfcc362.cp1-iad.github.net.mail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Branch: refs/heads/sql07-autosave-statement-rollback
Home: https://github.com/pgjdbc/pgjdbc
Commit: f28a5726d5c25701cf4743a1a6adde12c2796d3e
https://github.com/pgjdbc/pgjdbc/commit/f28a5726d5c25701cf4743a1a6adde12c2796d3e
Author: Nikhil Sontakke <nikhils(at)2ndQuadrant(dot)com>
Date: 2018-05-31 (Thu, 31 May 2018)

Changed paths:
M README.md
M docs/documentation/head/connect.md
M pgjdbc/src/main/java/org/postgresql/core/ServerVersion.java
M pgjdbc/src/main/java/org/postgresql/core/v3/ConnectionFactoryImpl.java
M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java
M pgjdbc/src/main/java/org/postgresql/jdbc/AutoSave.java
M pgjdbc/src/main/java/org/postgresql/jdbc/BatchResultHandler.java
M pgjdbc/src/test/java/org/postgresql/test/jdbc2/AutoRollbackTestSuite.java
A pgjdbc/src/test/java/org/postgresql/test/jdbc2/BatchAutoSaveTest.java
M pgjdbc/src/test/java/org/postgresql/test/jdbc2/Jdbc2TestSuite.java

Log Message:
-----------
Introduce AutoSave = SERVER functionality

If the Postgres server (11.0 and above) supports transaction
level rollback functionality, then instead of using JDBC side
manual savepoints in AutoSave=ALWAYS mode, use the server
side implementation. This patch introduces a new option for
AutoSave: SERVER for the same. Patch also includes relevant
test cases (BatchAutoSaveTest.java) and documentation changes

Commit: 448b981ff1676bd8f204c612d4e98106c5850196
https://github.com/pgjdbc/pgjdbc/commit/448b981ff1676bd8f204c612d4e98106c5850196
Author: Craig Ringer <craig(at)2ndquadrant(dot)com>
Date: 2018-07-30 (Mon, 30 Jul 2018)

Changed paths:
M pgjdbc/src/main/java/org/postgresql/PGProperty.java

Log Message:
-----------
Autosave patch failed to amend PGProperty.AUTOSAVE

Commit: 1de16b56aecd10b609b729b073c7a5edfb80892f
https://github.com/pgjdbc/pgjdbc/commit/1de16b56aecd10b609b729b073c7a5edfb80892f
Author: Craig Ringer <craig(at)2ndquadrant(dot)com>
Date: 2018-07-30 (Mon, 30 Jul 2018)

Changed paths:
M pgjdbc/src/main/java/org/postgresql/core/v3/ConnectionFactoryImpl.java

Log Message:
-----------
Make autosave=server missing server support error more specific

autosave=server would report "Transaction rollback statements are not supported"
even for completely unrelated connection errors like

org.postgresql.util.PSQLException: Transaction rollback statements are not supported
...
Caused by: org.postgresql.util.PSQLException: FATAL: role "test" does not exist
...

Now it'll properly re-throw for other cases.

Commit: ed9634830338487c661f56a7d38ba240801a5343
https://github.com/pgjdbc/pgjdbc/commit/ed9634830338487c661f56a7d38ba240801a5343
Author: Craig Ringer <craig(at)2ndquadrant(dot)com>
Date: 2018-08-03 (Fri, 03 Aug 2018)

Changed paths:
M pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java

Log Message:
-----------
Allow autosave=server to pipeline batches, avoiding round trips

Craig Ringer and Muhammad Altaf

Compare: https://github.com/pgjdbc/pgjdbc/compare/f28a5726d5c2^...ed9634830338
**NOTE:** This service has been marked for deprecation: https://developer.github.com/changes/2018-04-25-github-services-deprecation/

Functionality will be removed from GitHub.com on January 31st, 2019.

Browse pgsql-jdbc by date

  From Date Subject
Next Message ringerc 2018-08-03 14:56:34 [pgjdbc/pgjdbc]
Previous Message Sehrope Sarkuni 2018-08-02 18:59:10 [pgjdbc/pgjdbc] 203a10: fix: Correct typo in CopyManager comment (#1285)