| 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: 26496
|
|
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.
|
|
 |
|
|
subject: How to check if an oracle table has a lock on it from a java application
|
|
|
0
