Two Laptop Bag*
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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Log" Watch "Log" New topic


Giuseppa Cefalu
Ranch Hand

Joined: Jul 15, 2011
Posts: 121

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

I agree. Here's the link:
subject: Log
Similar Threads
creating image using AJAX and displaying on web page
Java and Crystal Reports XI: Dynamic Changing of Data Source
Data Access Object Design Questions
problem on JTable
Stateless Or Pojo?