|
Home > Archive > PostgreSQL Discussion > September 2005 > Re: Questions about Rollback - after insert, update,
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Questions about Rollback - after insert, update,
|
|
| Scott Marlowe 2005-09-22, 8:24 pm |
| On Thu, 2005-09-22 at 14:59, Emi Lu wrote:
> We are using (struts) ibates to run the transaction. We already setup
> autocommitte = false, and put insert, update, delete into one
> transaction. However, we found data were not rollback successfully.
> Moreover, in our atomic transaction, some operations are not finished
> successfull, but the data are not rollback.
>
> Your inputs are very welcomed!
I would tend to think it's either a bug in struts or jdbc or you're
making some mistake somewhere. I'm not familiar with struts and
postgresql together.
You might try logging ALL your SQL statements and seeing what is
actually being sent back and forth between struts / java and postgresql.
Not sure what else to do, as I use libpq to access postgresql, meaning
no layer between my app and pgsql, like with jdbc / struts.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|