row level locking
i want to do a row level locking facility.... I am sending a sms from table. i have two threads when it selects a records from table it displays all the records of the table and it sends a sms 2 times. but i want to do when first thread is accessing a first row. the second thread automatically should go to the second row .... how i have to do ......... pls help me.....
Thanks in advance......
more information needed
this is very much do-able, we need more information but first guess would be to go through a static synchronized accessor method, incrementing a row or postiion counter in some manner. How are the table rows persisted? Is this a database connection? Is it a study project? All in Java?