[hibernate-dev] lock timeout support

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 value DB2 : doesn't support either sybase: doesn't support either by "doesn't support" I mean, can't set this timeout from sql statement level, but they do support set it as a DB global config. so, I'm wondering if we could choose this way: 1. if DB supports both, then good 2. if DB supports nowait only, and lock timeout is set to nowait, then good 2.1 if lock timeout is set to 5 milliseconds, for example, then we setQueryTimeout(1) // (locktimeout +500)/1000+1 3. if DB doesn't supports either, then same as 2.1, use java.sql.Statement#setQueryTimeout does this acceptable? or we just ignore lock timeout if the underlying Db doesn't support it? ------------------------- Best Regards, Strong Liu <stliu at hibernate.org> http://about.me/stliu/bio