Locking in SQL 6.5

From: SK Leung (skleung_at_intexcorp.com.hk)
Date: 07/06/04 

Date: Mon, 5 Jul 2004 18:55:56 -0700

We have created a database link on Oracle 9i Database
Server and query the table from a remote SQL Server 6.5
via this database link on Oracle. Upon the execution of
the query on Oracle Server, the connection to SQL Server
created by the database link will lock up the database on
SQL Server. In order to release this locking, we need to
issue the COMMIT after the execution of query.
Per Oracle's technical personnel, SQL Server probably
works on readers block writers in other words exclusive
lock for writers cannot be obtained while readers have
read lock on them.
Please advise how this problem can be solved. Thanks.

SK

Relevant Pages