You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Brian Abbott <br...@dommoni.com> on 2004/08/29 07:55:48 UTC

Rollbacks

Does Derby support rollbacks? And, if not, does anyone have any suggestions for both working around it as well as a plan as to weather it will be implemented or not?

Thanks,

Brian Abbott

Re: Rollbacks

Posted by Jan Hlavatý <hl...@code.cz>.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jeffrey Lichtman wrote:
|> Does Derby support rollbacks? And, if not, does anyone have any

You may be hit by the fact that JDBC connection has autocommit on by default,
so rollback does not seem to work (bacause commit() is called automatically
after each statement, so theres nothing to rollback).
Turn it off using Connection.setAutoCommit(false) and cuse commit() and rollback().

Jan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iQEVAwUBQTItbXFDePgyse5HAQLlNAf+J1hi+mofgvpbSawVLXdpDKddh/KFdJmG
HT2LapD+etQDpFPGO8G7PJmBXgEaWUqZovizmqvAew8Fo5VF9rATtqitFVGFbCW8
rjItI6DOpzeUh/7mFa2rPSEGIUhCu9Lvo6K61ZCl0ggcbTtXXeKx/H0jjqrfH9oJ
/NHvsdqNprN2xHaBwKmUZBQJ6GxJ9gr1ly6sKbkLJ/HNxdT1xpoApqEuEJi7fL0w
EwHqb9VrT9nRlqmUkvLO4a5WPCOLMK2EzlrZFHuLunuuc5DaP1vGW+dvS4KXaRPn
t93seH4JjTLElPLIxxDhxvy1Bh3umXFyTdzDu7Z3HRobsYoV0brLGw==
=9iAz
-----END PGP SIGNATURE-----