LockModeTest executes the following SQL for Sybase and SQL Server:
UPDATE T_LOCK_A WITH(NOWAIT) SET a_value = :value where id = :id";
This fails on Sybase, because it doesn't recognize WITH(NOWAIT).
If I remove WITH(NOWAIT), the statement blocks until Junit times out.
I'm having trouble finding some equivalent to WITH(NOWAIT) for Sybase. Does
anyone know if there is one?
Should I just skip this test for Sybase?
Thanks,
Gail