snpesnpe wrote:
Page 158 - note FAQ
sentence : "Note that some database systems enable auto commit by default
for each new connection, but others don't"
This is correct for some clients, but don't for JDBC. JDBC specification request that auto commit is enabled when opnenew connection
(jdbc spec 2.1 chapter 10.1.1)
Not sure all JDBC driver follow the specs
Quote:
assertion (same page) : for multiple database you can't achieve atomicity using JDBC alone
It isn't correct - Oracle have two phase commit and with using database link and jdbc driver You can achieve atomicity (adminitsration database + jdbc driver alone) - two phase commit work in database side
regards
This is not really JDBC alone.