Kbase P154952: The bi threshold for the database keeps getting reached when a JDBC user is running queries against
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/10/2009 |
|
Status: Unverified
SYMPTOM(s):
The bi threshold for the database keeps getting reached when a JDBC user is running queries against a database.
promon showing 2 million record get locks in the Activity screen for the period when the JDBC application is being ran against the database.
FACT(s) (Environment):
Auto commit is being used for the JDBC connection.
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Transaction isolation level was not being set.
FIX:
Set the transaction isolation level to READ_UNCOMMITTED