use of savepoint in containter managed transaction - Mailing list pgsql-jdbc

From Amar Dhole
Subject use of savepoint in containter managed transaction
Date
Msg-id B056671652AA4D418763981054BCEAB4092CCE@PA-MBX04.na.tibco.com
Whole thread Raw
In response to Re: PGXAConnection and autocommit problem  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: use of savepoint in containter managed transaction  (Radosław Smogura <rsmogura@softperience.eu>)
List pgsql-jdbc
HI All,

I have requirement to use save point. But I am using session bean whose transaction is managed by container. While
executingsql insert I got unique key constraint because of this my other command following this exception got ignored.
Iwant to continue my transaction even after this as we ignore this insert and make an entry in other table for this
error.And proceed head. with Postgres this is not possible. I cant user plsql block as behaviour is spread in all my
application. Need some suggestion to achieve this with savepoint.  

I have some question.
1) Can I use savepoint in Container Managed transaction ?
2) Can I make some custom change to jdbc driver to ignore duplicate key exception or to raise warning instead ERROR.

Thanks
Amar

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: JVM & JDBC Upgrade --- Help !!
Next
From: Radosław Smogura
Date:
Subject: Re: use of savepoint in containter managed transaction