Kbase P12158: Avoiding error "Failure to get record lock on a record from table <tablename>" when running Select q
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/9/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Error running Select query via ODBC.
ODBC Error Code = S1000 (General error)
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Failure getting record lock on a record from table PUB.tablename
CAUSE:
Select statements are being run while connected with Repeatable Read/Read Committed/Serializable set as Isolation Level. These isolation levels will place a share lock on the record while it is being read.
FIX:
Change the Isolation Level from default setting, Repeatable Read/Read Committed/Serializable to Read Uncommitted. Setting the Isolation Level to Read Uncommitted insures that when a record is read, no record locks are acquired. If using a J2EE server (Like Websphere) you should use Read Committed and not use Read Uncommitted.