> hi remy,
> It does look like some DB's would start in auto-commit true .
> I heard from somebody that even oracle does not allow
setAutoCommit(false)
> when dealing with a global trabsaction though i have not tested it yet.I
> will do some testing with oracle database and let you know the result.
> I think setAutoCommit(false) can be in seperate try catch block and any
> expection ignored if there is no possibility
> of SQLException being raised because of other problem or may be the
> setAutoCommit(false) can be removed all together
> if the behavior is the same for all the databases.
I'm sure that sentence would make Assaf have a good laugh :)
Maybe you should go ask him about what we should expect databases to do with
the auto-commit mode by default ...
Remy
