aspose file tools*
The moose likes Java in General and the fly likes how to create a java program which tracks the database operations like insertion and updatation etc. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "how to create a java program which tracks the database operations like insertion and updatation etc." Watch "how to create a java program which tracks the database operations like insertion and updatation etc." New topic
Author

how to create a java program which tracks the database operations like insertion and updatation etc.

srinivas urs
Greenhorn

Joined: Apr 06, 2011
Posts: 12
Friends,

I need to create basic java program which will not use threads or anything else, which has to track the operations (insertion, update and etc., ) on the DB tables.

Please let know if anybody knows.... it is very urgent.

Thanks in advance.

Regards,
Srinivas
Bert Bates
author
Sheriff

Joined: Oct 14, 2002
Posts: 8883
    
    5
Eh oh,

Let's move this over to Java in General, but remember, we don't hand out solutions here - show us what you've already done and we'll help you go from there.

Bert


Spot false dilemmas now, ask me how!
(If you're not on the edge, you're taking up too much room.)
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1873
    
  16

Could you use log4j to log these operations when they are called from your Java DB interface?

Or you could do this via triggers on the database tables, if your RDBMS (and DBAs) will permit this. Then you can be sure these operations will be recorded, no matter where they are called from.


No more Blub for me, thank you, Vicar.
srinivas urs
Greenhorn

Joined: Apr 06, 2011
Posts: 12
Thanks chris... for giving the valuable info... will try
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to create a java program which tracks the database operations like insertion and updatation etc.