Subject Re: Transaction question
Author Roman Rokytskyy
Hi,

> I've always used the commit method from connection, but in my
> application I have 2 different threads importing data into firebird.
> It will run over a slow network and I don't want one thread
> commiting other's thread work. I found this message but doesn't work
> with firebird:

First, you cannot use multiple threads with the same connection.
Current version of JayBird is _not_ thread-safe.

> More difficult, but not impossible. You can always revert to
> whatever SQL the DBMS supports, such as for Sybase You can do:
>
> stmt.executeUpdate("BEGIN TRAN myTran");
>
> stmt.executeUpdate("SAVE TRANSACTION");

You can use savepoints in Firebird 1.5. Ask in IB-Support list.

Roman