db-derby-user mailing list archives

Hi all,

I'm testing Derby with 100 clients replaying a trace of TPC-W  
transactions and I'm having this problem after some time:

org.apache.derby.client.am.SqlException: A lock could not be obtained  
within the time requested
         at org.apache.derby.client.am.ResultSet.completeSqlca 
(Unknown Source)
         at  
org.apache.derby.client.net.NetResultSetReply.parseFetchError(Unknown  
Source)
         at  
org.apache.derby.client.net.NetResultSetReply.parseCNTQRYreply 
(Unknown Source)
         at org.apache.derby.client.net.NetResultSetReply.readFetch 
(Unknown Source)
         at org.apache.derby.client.net.ResultSetReply.readFetch 
(Unknown Source)
         at org.apache.derby.client.net.NetResultSet.readFetch_ 
(Unknown Source)
         at org.apache.derby.client.am.ResultSet.flowFetch(Unknown  
Source)
         at org.apache.derby.client.net.NetCursor.getMoreData_ 
(Unknown Source)
         at org.apache.derby.client.am.Cursor.next(Unknown Source)
         at org.apache.derby.client.am.ResultSet.nextX(Unknown Source)
         at org.apache.derby.client.am.ResultSet.next(Unknown Source)
         at TracePlayer.playTransaction(TraceReplay.java:379)
         at TracePlayer.run(TraceReplay.java:461)

Any ideas for how to increase the wait time for obtaining locks and/ 
or avoiding this problem some how?

Thanks,
--
Nuno Carvalho
University of Lisbon, Portugal
http://dialnp.di.fc.ul.pt