aspose file tools*
The moose likes JDBC and the fly likes How to check if an oracle table has a lock on it from a java application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to check if an oracle table has a lock on it from a java application" Watch "How to check if an oracle table has a lock on it from a java application" New topic
Author

How to check if an oracle table has a lock on it from a java application

Pratibha Malhotra
Ranch Hand

Joined: Dec 21, 2003
Posts: 199
Hi

I have an application on which oracle procedure would run every day to replicate data. I will be locking these tables during procedure is being executed.

During my procedure is being executed, user may try to update/delete records in locked table

How can i intimate a user that the table he is trying to update/delete through java application is locked.

kindly help


~ Pratibha Malhotra<br /> <br />Sun Certified Java Programmer<br />SCEA 1.4 (In Progress)<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />"Many of life's failures are people who did not realize how close they were to success when they gave up!!"
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30299
    
150

Rewa,
You can set some sort of flag in your application when the procedure starts/stops. There isn't a way to tell that the table is locked from Java.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
look for some statistic view of your database. hope you would find one giving you the desired info.

And ofcourse, you can always do it by implementing some logic of your own.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to check if an oracle table has a lock on it from a java application