Kbase P81727: When a sql-92 client connects to a database, what type of lock does it hold?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/28/2004 |
|
Status: Unverified
GOAL:
When a sql-92 client connects to a database, what type of lock does it hold?
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
OpenEdge 10.0A
FIX:
In Progress 9.1x, upon connection to the database, our SQL Server obtained a schema shared lock. Thus, even though a connection had no transaction active, the SQL server held a schema shared lock, preventing other connections from making schema changes.
In OE 10.0A, this no longer exists. Upon connection to the database, the schema shared lock has been lowered down to the transaction level.