Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    24

    Unanswered: Track changes, Audit and rollback

    Hey, does any one can give me some references or advices on how to control on changes in the DB, audit them and have the ability to rollback.
    My application is in Java

    Thank you

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    So long as you maintain a connection to the DB and are using transactions then you can do the following :

    1. Begin transaction
    2. Make changes to your data
    3. Select from tables that have changed data
    4. If correct commit, else rollback.

  3. #3
    Join Date
    Jul 2003
    Posts
    24

    The problem is that i am talking about long period

    I mean that the client can do changes, temporary save.
    and after a week can do cancel or apply changes

  4. #4
    Join Date
    Mar 2004
    Posts
    480
    THis article will give you some ideas on Point in Time database architecture.

  5. #5
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    After a week
    What happens if two people make a change to the same data then try to commit that information after a week? Which one gets priority? The person who submits first will have their information overwritten by the person who submits second.

  6. #6
    Join Date
    Jul 2003
    Posts
    24

    The same answer like transaction

    Let say user a and user b open a transaction to the DB.
    They dont see each other changes. (in the default behavior).
    at the end they both ask for commit.

    The same behavior in this case will be in my case.

    the client open a " transaction " write in some temporal workspace (he dosnt overide the data , i dont know how to do this).
    The other users can see his changes.
    At the end he will ask for apply changes.

    If the data has already changed the user will get a message on conflict and he will need to do a merge.

Posting Permissions

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