"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