The moose likes Oracle/OAS and the fly likes simulteneouse update on same table? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "simulteneouse update on same table?" Watch "simulteneouse update on same table?" New topic

simulteneouse update on same table?

Sona Patel
Ranch Hand

Joined: Mar 30, 2009
Posts: 75
Hii All...

I need to perform simulteneouse updates on the same table. I want to do something like one application instance will update some set of rows and other application instace will update another set of rows. But i am not sure how to do that?

I think i can use row id like one instace will update first 1000 row ids and another instace will update 1001 -2000 rowids. But as i need to delete rows so row id may not be constant always.

Please suggest better way of doing this. I hope i am able to explain requirement clearly.

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Can I ask why you need to do this? It sounds quite like you are trying to hand craft behaviour that Oracle will provide without you needing to know how its done. Assuming you are identifying your data to update using primary keys there won't be a clash.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: simulteneouse update on same table?
It's not a secret anymore!