File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes DB Locks Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DB Locks" Watch "DB Locks" New topic

DB Locks

raj joe
Ranch Hand

Joined: Mar 17, 2005
Posts: 99
I have the below archieture

Action - Session Bean - DAO -DB
I have configured transcation,"NOT REQUIRED" in the session bean.
I am using MS SQL Server DB. (By Default the isolcation Level is READ COMMITED)

Problem : 1. I get lots of problem with DB locks and dead locks while accessing the application concurrently
2. Get "no data available to read" exception
Note : I user only stored procedures I use only callable statements.

can u help me out of these problems?
I agree. Here's the link:
subject: DB Locks
It's not a secret anymore!