File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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?
 
Similar Threads
retrieve values specific to a row
Hql delete syntax?
Is there a way to get an absolute row id for a JTable model
access rows from html table
Get the current updating row, to be inserted into another table using trigger