In CUBRIDConnection class, some questions confused me:
1. SetLockTimeout() and SetLockTimeout(int value) must be used togather. Open method does not set the lock timeout value to the server. and I have to set lock timeout value with SetLockTimeout(int value) before open a connection and call SetLockTimeout() after open a connection.
2. The value I set for lock timeout is not used. I set lockTimeout as 60 s, but the lock timeout exception is thrown in about 2 seconds.
Please have a look at the attached test case for details.
The exception I get in the test case is the same as what I get directly in csql (does not use the interface), just the waiting time is not the same as the time I wait in csql.
The exception is:
Your transaction (index 2, PUBLIC@user-PC|528) timed out waiting on IX_LOCK lock on class t. You are waiting for user(s) PUBLIC@user-PC|cub_cas(312) to finish.