Re: [hibernate-dev] lock timeout support

2012-06-04 Thread Steve Ebersole
On Fri 01 Jun 2012 07:21:32 AM CDT, Strong Liu wrote: > when using connection pool or datasource, there is not a way to set > the connection level settings for each query, is it? Sure you can. Psuedo-code: dialect.setLockTimeout( theConnection ); try { executeTheStatement(); } finally {

Re: [hibernate-dev] lock timeout support

2012-06-01 Thread Strong Liu
On Jun 1, 2012, at 7:44 PM, Steve Ebersole wrote: > > On Fri 01 Jun 2012 05:27:12 AM CDT, Strong Liu wrote: >> Hi there, >> >> I'm working on this >> org.hibernate.ejb.test.lock.LockTest#testFindWithPessimisticWriteLockTimeoutException >> test, it failed on lots of DBs >> >> for now, I found

Re: [hibernate-dev] lock timeout support

2012-06-01 Thread Steve Ebersole
On Fri 01 Jun 2012 05:27:12 AM CDT, Strong Liu wrote: > Hi there, > > I'm working on this > org.hibernate.ejb.test.lock.LockTest#testFindWithPessimisticWriteLockTimeoutException > test, it failed on lots of DBs > > for now, I found: > > sql server : supports nowait, but not other lock timeout va