Kristian Waagan <[email protected]> writes: > Hello, > > Has anyone considered the case of using try-with-resources (Java SE 7) > with Derby connections with auto-commit off?
Presumably, this would happen only if the app code received an *statement level SQLException* which isn't caught (with retry or rollback), leading to an (auto)close. If the SQLException is transaction or connection level error, the auto-close wouldn't throw. I agree it seems to defeat the purpose somewhat..
