aspose file tools*
The moose likes JDBC and the fly likes Log Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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

 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Log