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

On Sun, 29 Nov 2020 at 14:09, Martin Goodson <kaemaril(at)googlemail(dot)com>
wrote:

> On 29/11/2020 18:46, David G. Johnston wrote:
> > 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.
> >
> Oh. That's very interesting. Thank you, David. I will chase up with the
> developers tomorrow to confirm with them the version of the postgres
> jdbc driver they are using.
>
> I'm no coder, it didn't occur to me to actually check with the source.
> Nice one :)
>
> Many thanks.
>
> Regards,
>
> Martin.
>
> --
> Martin Goodson
>
> Whatever you've got planned, forget it. I'm the Doctor.
> I'm 904 years old. I'm from the planet Gallifrey in the
> constellation of Kasterborous. I am The Oncoming Storm,
> the Bringer of Darkness and you are ... basically just a
> rabbit, aren't you? OK, carry on, just a general ...
> warning.
>
>
I'm guessing this is now resolved ?

Dave Cramer
www.postgres.rocks