title: SQL server "Lock request time out period exceeded" .. again
body: <p>I'm having a problem trying to extend the lock timeout in a sql server SP. No matter  what I try it keeps throwing "Lock request time out period exceeded".
  I'm using java + jtds 1.2.2, c3p0 0.9.1 and sql server 2008.
  The settings I tried:</p>
  
  <p><code>SET LOCK_TIMEOUT 10000 inside the SP and with con.createStatement().execute("SET LOCK_TIMEOUT 10000 ")</code> before calling the SP.
  and in the SP statement :  statement.setQueryTimeout( 10 );</p>
  
  <p>The SP is called by : s<code>tatement = con.prepareCall("dbo.store_procedure ?,?,?", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);</code>
  and it sets "SET TRANSACTION ISOLATION LEVEL REPEATABLE READ" inside</p>
  
  <p>any sugestions? anyone with similar problems? 
  thanks in advance</p>