Thread: Transaction not working.

Transaction not working.

From
"Nadeem Akhtar"
Date:
I'm using the C++ classes and call "Begin Work" followed by few inserts and
I end it by a "commit".  But when I check the database the records I just
inserted don't show up.

Any idea ?

Thanks in advance.




Re: Transaction not working.

From
Martijn van Oosterhout
Date:
On Mon, Oct 15, 2001 at 06:44:44PM -0400, Nadeem Akhtar wrote:
> I'm using the C++ classes and call "Begin Work" followed by few inserts and
> I end it by a "commit".  But when I check the database the records I just
> inserted don't show up.

Maybe the inserts failed?

If any error occurred during the transaction, the whole transaction would be
rolled back.

Look at the server logs.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.