Re: Postgres JDBC, WS and commit - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: Postgres JDBC, WS and commit
Date
Msg-id 4FB9FB15.3000406@ringerc.id.au
Whole thread Raw
In response to Postgres JDBC, WS and commit  (mephysto <mephystoonhell@gmail.com>)
List pgsql-jdbc
On 05/09/2012 11:06 PM, mephysto wrote:
> Hi there,
> I'm using postgres-JDBC ina GlassFish application server to develop a web
> service application. I made several tries with either XA and standard
> driver. I use JDBC connection pool of GlassFish.
> I found that transaction started into a web service operation, are closed at
> the end of operation, not when in the code the connection are closed.
>
> I am searching a solution to close transaction that permit me to close
> trasaction when I want it, before end of web service operation.
>
> Is there a way to achieve this goal?

If you're using XA transactions in a Java EE context, what you want is
probably an EJB3 with

   @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)

which will force the EJB business method(s) so annotated to run in their
own independent transactions. Note that these transactions will *NOT* be
able to see any uncommitted changes from your main transaction, they're
completely independent and behind the scenes with PostgreSQL are
actually new connections to the server.

--
Craig Ringer

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Patch: Add support for hstore extension - and map it to/from java.util.Map
Next
From: Mikko Tiihonen
Date:
Subject: Re: json type