exclusive lock

[Kalpesh Soni]

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!"

[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..

[Kalpesh Soni]

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..