Checking when database was last changed

[Smoke3723]

Hi team. I'm currently developing tests for an application that will migrate some XML into a database. Obviously, if the XML is malformed or the wrong arguments are given, we have to make sure nothing is written to the database.

Is it possible to somehow check when the database was last edited, or mark when edits have occured?

The code has to be 1.5 enterprise, and we're connecting using an Oracle Thin JDBC connector. Hibernate is being used to ensure the tables and objects map correctly, although the tests themselves are simple java.sql statements.

[masijade]

Use a transaction and you can simply "rollback" when an error occurs. Otherwise, add an "autoupdated" timestamp field to the tables involved.