Kbase P25299: More record locks are noticed when running queries from SQL Explorer than from Actuate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/07/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
Queries run from SQL Explorer generates more locks than from Actuate
Actuate is connecting in READ UNCOMMITTED.
Default isolation level is used for the SQL Explorer
Using SQL-92
CAUSE:
The default transaction isolation level is COMMITTED READ for the SQL Explorer. Unlike UNCOMMITTED READ , this isolation level locks record indeed.
FIX:
Change the transaction isolation level in the SQL Explorer from the menu Options, and set it to UNCOMMITTED READ.