Postgres Pro
Downloads
Home   >   mailing lists

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ... - Mailing list pgsql-general

From David G. Johnston
Subject Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...
Date
Msg-id CAKFQuwbe_xrVreDs5HY4pMJUxt+LPuyV1ejVopy8FrNYSE87fA@mail.gmail.com
Whole thread Raw
In response to "Server versions prior to 8.0 do not support savepoints" when using JDBC ...  (Martin Goodson <kaemaril@googlemail.com>)
Responses Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...  (Martin Goodson <kaemaril@googlemail.com>)
List pgsql-general
Tree view
On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson <kaemaril@googlemail.com> wrote:
Hello.

I wonder if anyone can assist with this?

Some of my developers are reporting that they are getting the following
message when attempting to connect to the database using jdbc:

Caused by: org.postgresql.util.PSQLException: Server versions prior to
8.0 do not support savepoints

at

org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95)

Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc
driver version they're employing is postgresl-42.2.9.

My best guess is that they are not actually running 42.2.9, they are running an older version that was released before PostgreSQL v10 came out and the version detection code doesn't recognize the new version format since 10.

I didn't dig into this too deeply but I did download the zip for 42.2.9 and those classes don't even exist at that point since the build was re-done using pre-processors.

David J.

pgsql-general by date:

Previous
From: Martin Goodson
Date:
Subject: Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...
Next
From: Martin Goodson
Date:
Subject: Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...