Connected to this...does anyone know what happens when you turn
autocommit off on a connection retrieved through JDBC driver,
execute some sql statements, and then do a commit?

Is a new transaction started automatically? Is it outside of a
transaction? If the commit is never issued because something went
wrong, what will happen to the statements that were issued?

Many thanks,

David

--- In firebird-support@yahoogroups.com, Aage Johansen
<aagjohan@o...> wrote:

> On Wed, 24 Sep 2003 19:46:58 +0000 (UTC), hay77772000 wrote:
>
> >...
> > A question though - if I add a record to a table, along with

multiple

> > associated records in tables with foreign keys, do I need to do

any kind

> > of locking?
> > ...
>
> I don't think so. Other users won't even see the inserted records

until

> you commit. The commit will enable other users to see all the

records, but

> they may have to start a new transaction (depending on

their 'transaction

> isolation' setting).
>
> --
> Aage J.