From: Amar Dhole <adhole@tibco.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: use of savepoint in containter managed transaction
Date: Fri, 23 Sep 2011 06:32:13 +0000
Message-ID: <B056671652AA4D418763981054BCEAB4092CDF@PA-MBX04.na.tibco.com> (raw)
In-Reply-To: <201109222140.16949.johnf@jfcomputer.com>
References: <201109221949.20671.johnf@jfcomputer.com>
<5EABD4DE-5CB8-4C65-A1FF-3166A683EE3F@yahoo.com>
<201109222140.16949.johnf@jfcomputer.com>
HI All,
I have requirement to use save point. But I am using session bean whose transaction is managed by container. While executing sql insert I got unique key constraint because of this my other command following this exception got ignored. I want 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adhole@tibco.com
Subject: Re: use of savepoint in containter managed transaction
In-Reply-To: <B056671652AA4D418763981054BCEAB4092CDF@PA-MBX04.na.tibco.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox