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

• Next in forum: Re: Replication of several satellites into one central db: adding location key ?
• Prev in forum: Re: Need Material for "Sybase to Sql Server Migration"
• Thread view: Lock table problem

[Reply to this message]