At 04:55 PM 16/12/2004 +0800, you wrote:

>We use Jaybird as the JDBC/ODBC driver. I've gone through some of the
>source code, and almost all of them uses something like
>conn.beginTransaction(), conn.commit(), with no other options. I don't
>wee why it can possibly do a commit retain. There are however cases
>where there aren't any conn.commit() at all.

Go into the firebird-java list and check with Roman exactly what's going on
when the commit() method gets called - don't assume that it's a hard
commit on the server. There are sometimes good arguments for implementing
commit as commit retaining, as long as a hard commit is getting called at
reasonable intervals to clear out the re-used resources. The etiology of
your problems is the classic one where commit retaining is used exclusively...

./heLen