This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "simulteneouse update on same table?" Watch "simulteneouse update on same table?" New topic
Author

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.

Regards...
Paul Sturrock
Bartender

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: http://aspose.com/file-tools
 
subject: simulteneouse update on same table?