> I'm new to the list, and I'm not really a developer. The Firebird
> we're using seems to pile up a lot of uncommited transactions. I
> went through our application code, and I can see that they use
> salmonllc's sophia framework, which I suppose provides database
> abstraction among other things. I have however seen code like
> conn.beginTransaction() and conn.commit(), without any additional
> option/parameters. Would commit here be a hard commit, or commit
> retain (or any other?).

I cannot tell you what is required in that framework, but JDBC specifies
only one commit. At present time it uses, what you probably call "hard"
commit.

Roman