File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes exclusive lock Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "exclusive lock" Watch "exclusive lock" New topic
Author

exclusive lock

Kalpesh Soni
Ranch Hand

Joined: Jan 02, 2001
Posts: 312
I want to have exclusive lock on my row when i am updating it
If i am writing to a particular row no one should be able to even read it!
So i dont think that it is related to transactions
because in transactions, either u can read commited data or uncommited data
i am using jdbc with oracle 8
in VB they use some property in result set
please tell me soon

------------------
"Sun Certified Java Programmer"
KS
"Failing to plan is like plannig to fail!"


Test 094, IBM WID 6.0 cert
SCJP 1.2
SCBCD 1.3 Beta
SCWCD 1.4 Beta
SCMAD Beta
SCDJWS Beta

KS
Raja Shekhar
Ranch Hand

Joined: Apr 02, 2001
Posts: 49
Hi !!
The ORACLE handles this for u...

If u r Writing the EJB..

then u have to set the TRASCATION TYPE..ASin VB..
Kalpesh Soni
Ranch Hand

Joined: Jan 02, 2001
Posts: 312
thanks
but what if i am not using ejbs
and the database is shared
meaning
one java and one vb application is accessing the database
?!!
Originally posted by Raja Shekhar:
Hi !!
The ORACLE handles this for u...

If u r Writing the EJB..

then u have to set the TRASCATION TYPE..ASin VB..

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: exclusive lock