Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson <kaemaril(at)googlemail(dot)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.