Multiple threads of same process is going after one table - How to avoid retrieving the same record?
posted 5 years ago
We need a java batch process of multiple instances running in websphere v6.1 clustered environment going after the UDB table to retrieve the next oldest order to be processed. These threads should be constantly polling on the table to retrieve next order and process.
Do we have a way to run these threads by using Spring and Hibernate and avoid retrieving the same record by multiple concurrent processes?
We are also using WebSphere Process Server short running processes for other work in this environment.
Please let me know your thoughts on handling this situation.