Hi, In my application I need to lock ( using a flag ) a set of rows, so that another thread is not allowed to access the same rows for processing.
I plan to use a flag for locking the rows, which my thread is accessing for processing and releasing the lock once the processing is done. I plan to put a unique Id of the request( session bean ) which started the processing as the lock flag. My problem is about the releasing the lock flag. if one of the servers which locked the rows goes down, How will i release the lock. I cant put all the processing ( around 1 million rows) in the same transaction. I need to know of a strategy which can be used in a Clustered environment. I cant risk processing being done on same row by two different threads at the same time. Is there a way I will know when a server which is part of the cluster goes down. I'am using Weblogic 6.1 , ejb2.0 and Oracle. I will prefer If i dont have to use any feature which will tie down my application to any of these. Can I give an id to the servers which participates in the cluster ?. If yes how will I get this Id in my session beans. Can I access the properties which are passed to the application server at startup?. -- Cherry __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
