This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Log Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Log" Watch "Log" New topic
Author

Log

Giuseppa Cefalu
Ranch Hand

Joined: Jul 15, 2011
Posts: 121
Hi,

I would like to be able to keep a log of all the modifications that are done in the database. For example, some one makes a change to a value from 4 to 5. I would like to write a table that reads the original value, saves it to a table and reads the value replaced with and saves it to the same table together with the time and date and which the change was done. Are there any other items I should be aware off that need to be kept in a log table? My program is an interface that allows the user to insert, update and delete records from the database. Is there any reading that you would recommend?

Thank you
Giuseppa Cefalu
Ranch Hand

Joined: Jul 15, 2011
Posts: 121
I wonder if I can create part of the log by saving the output of the table below to a database table

 
 
subject: Log