Hi,

Perhaps ensure that the transaction you are using to view the data in the
database is re-started also after the insert was commited otherwise it may
not be able to see the results of the insert - depending on its isolation
level.

Just a thought.

Ryan

-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: 15 August 2003 16:01
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Strange problem: inserts failing

> I built a class called Database wich encapsulates a JBird
> Connection. When I call database.connect(), it is created an
> auto-committed Connection. The method used for updates is called
> execUpdate and is synchorinzed. So, I create an Database object,
> call the method connect and start the threads. Each thread will then
> call the execUpdate method.

Sounds good to me.

> I made a step-by-step execution and the output of executeUpdate is 1
> just as you said. The connection is auto-committed, as I said
> before. Do you know if an auto-committed transaction can be rolled
> back? If yes, is there any way of discovering if it occurred and
> why?

No, you should get exception then. If server says that it was
committed, then it was committed. Check if no exception is ignored.

Roman



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/