dirty read problem

[raj esh]

i have a jdbc code, which is fetching data from a table consists of lakhs of records and we are manipulating some values in table and these are posting into some other database(sap) and updating the record in our database as it is posted. but the problem is if we are running application from different servers(by mistake) the same reocrd is fetched in both applications, and manipulating and posting into sap database(this time posting twice)
i guess we have to set record level locking for this.how to set record level locking ?
can someone help me in this?

[John Bengler]

Hi Banthi,

I'm not sure if this works for every database, but in Oracle you can use a "select for update", like described here:

Row Level Locking in JDBC

Just be sure to release your locks by commit/rollback when you're done..



John