Posted by Sandy on 12/06/05 16:27

Hi

I want to lock a table using JDBC as I want to perform some query's (read
and write) in exclusive mode. Different threads will be executing the same
code simultaneously. I am using the following statements

Statement stmt = connection.createStatement();
stmt.executeUpdate("lock table STATUS_TBL in EXCLUSIVE mode");

but am getting the following error
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect
syntax near 'STATUS_TBL'.


can somebody tell the correct syntax for the lock table statement.

Thanks

[Back to original message]