Results 1 to 2 of 2
  1. #1
    Smoke3723 is offline Member
    Join Date
    Feb 2010
    Posts
    1
    Rep Power
    0

    Question Checking when database was last changed

    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.

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

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

Similar Threads

  1. Replies: 1
    Last Post: 03-08-2010, 01:34 PM
  2. Replies: 0
    Last Post: 12-01-2009, 10:01 PM
  3. Event for jTtextField changed
    By itaipee in forum AWT / Swing
    Replies: 3
    Last Post: 03-03-2009, 07:55 PM
  4. Why the panel text changed?
    By ottawalyli in forum AWT / Swing
    Replies: 1
    Last Post: 12-17-2007, 05:56 AM
  5. Why the panel text changed?
    By ottawalyli in forum SWT / JFace
    Replies: 0
    Last Post: 12-16-2007, 04:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •