Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: XA rollback problem
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Niels Beekman <n(dot)beekman(at)wis(dot)nl>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: XA rollback problem
- Date: Fri, 21 Apr 2006 15:11:11 -0500 (EST)
On Fri, 21 Apr 2006, Niels Beekman wrote:
All inserts or updates I do using PGXADatasource get rolled back silently (no exceptions). I reproduced the problem using a simple test table with a single int2-column.
Could you show us the java test code you are using as well?
As you can see in the driver logging it uses one-phase commit. I think the problem is in the part that states *CommandStatus(ROLLBACK)*, the driver just proceeds to ending and committing the transaction.
The log alone isn't really enough to see what's going on here, because it doesn't show the Parse for the S_2 statement. It is unclear whether the driver is issuing a commit or a rollback here.
Kris Jurka
- References:
- XA rollback problem
- From: Niels Beekman
- XA rollback problem
- Prev by Date: Re: Problems with Timestamp and Function Calls in JDBC/Prepared
- Next by Date: Re: Question about ResultSetMetaData
- Previous by thread: XA rollback problem
- Next by thread: Re: XA rollback problem
- Indexes: