Check for inconsistency in mysql DB. 1

[eracha]

Hi all,

I have been assigned with the task of developing a java class to check for inconsistency in a DB in our firm. I was thinking I could rush over this using a trigger, but honestly, my whole idea flopped.

So I will greatly appreciate any tips on how to go about it. Just enlightening me on how I could face the task will be highly appreciated.

many thanks.

Eric

 

[obadare]

import java.util.*;
import java.sql.*;
 
public class DbChecker extends TimerTask{
   public DbCheck(){ //initialize the connection to database
   }

   public void run(){
     // your algorithm for checking for inconsistency
     //if inconsistency found, write in to a log file
     //using java.util.Logger
   }
}
 
//class to perform task.
Timer.schedule(DbChecker,intervals)

Check this article about how to check for consistency.

http://www.google.co.uk/url?sa=t&ct...Felu5ZXTVDDYUFw3g&sig2=HLMTMxmju3-N4PL77TaJbQ

 

[eracha]

Many thanks Obadare.
Your post gave me a rich starting point and things seems lot more easier now.
Cheers