my dog learned polymorphism*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
Similar Threads
row-level locking
Data Caching in EJB application
Deadlock problems with Hibernate/Spring/MS-SQL
Row locks and transaction levels
Shaired Reading Locks??