Re: Pg JDBC3 driver and savepoints - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Pg JDBC3 driver and savepoints
Date
Msg-id Pine.BSO.4.64.0802011535030.5384@leary.csoft.net
Whole thread Raw
In response to Pg JDBC3 driver and savepoints  (Matt Chambers <chambers@imageworks.com>)
List pgsql-jdbc

On Fri, 1 Feb 2008, Matt Chambers wrote:

> Has anyone here used the Spring Framework and JDBC template and nested
> transactions?  The documentation for Spring claims that if the JDBC driver
> supports save points then it would use them in particular situations, for
> example when you marked a method as a nested transaction.   I know postgres
> supports save points and that I can manually save point, but the spring
> framework is not detecting the driver supports save points. Is there some
> savepoint interface that has to be implemented?
>

I would guess Spring would use DatabaseMetaData.supportsSavepoints() to
determine if it can use savepoints.  Our implementation of that says,
"return connection.haveMinimumServerVersion("8.0");", so as long as you've
got a 8.0+ server it should work.  For more details you'd have to ask the
Spring people.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Matt Chambers
Date:
Subject: Pg JDBC3 driver and savepoints
Next
From: Kris Jurka
Date:
Subject: Re: Any examples for Postgresql 8.0 using jdbc type 2/3 driver with blobs?