• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Multiple threads of same process is going after one table - How to avoid retrieving the same record?

 
Venkat Kancharla
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
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.

Thanks in advance.

Venkat
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic