I'm sorry for the inconveniences. I wasn't aware about my emails
formats. I hope now they are plain text formated.

Here is a repost of my last message:

Why should I always set autoCommit(false) if most of the database
accesses are just one SQL statement?

Reusable code means that every database access sets its transaction
mode, so they all are completelly independent. That's why I set the
particular autoCommit mode, in most cases to true.

So, my main questions are:

Is there any performance penalty if I set autoCommit(true) repeated
times, even knowing that autocommit is already switched on in most
cases?

Should it be better to switch autocommit off, even if most database
accesses are just one SQL statement?

If I switch autoCommit off, does a new transaction start inmediately
either after executing that opertation or after performing a
commit/rollback?

Thank you in advance.

Juan Pedro

On Fri, 2003-06-06 at 09:10, Helen Borrie wrote:
> Robert di Falco and Juan Pedro Lopez:
>
> Please STOP using HTML for your list messages.
>
> ^heLen
> (resident Witch)
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> Click Here!
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.