db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Query regarding derby
Date Thu, 30 Nov 2006 06:31:01 GMT
> "A lock could not be obtained within the time requested " this exception.
> 
> My queries are as follows
> 
> 1. Why I am getting this exception?
> 2. What I should do to avoid this error?
> 3. How the locking mechanism working in Derby Database?

This is a completely normal exception, and indicates that you are
experiencing contention for database resources by multiple active
transactions.

You'll want to spend some time reading through the various subsections of
http://db.apache.org/derby/docs/dev/devguide/cdevconcepts30291.html

There are many suggestions in that section of the manual for ways to
minimize data contention problems.

http://java.sun.com/docs/books/tutorial/jdbc/basics/transactions.html
also has some very good material on these topics.

Hope this helps!

thanks,

bryan



Mime
View raw message