Kbase P185955: Getting error 13742 when attempting to change transaction isolation level of SQL statements to OpenE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/04/2011 |
|
Status: Unverified
SYMPTOM(s):
Getting error 13742 when attempting to change transaction isolation level of SQL statements to OpenEdge database made from IBM WebSphere.
Cannot change the transaction isolation level while in a transaction. (13742)
IBM WebSphere 6.1.0.35
FACT(s) (Environment):
UNIX
OpenEdge 10.x
CAUSE:
WebSphere uses a query called PreTest to verify the connectivity state to a database. The SQL statement of the PreTest can only be one line long. This prohibits the ability to define transaction isolation in the PreTest.
All statements other than SET statements begin a transaction within the OpenEdge database.
Since the PreTest has established a transaction to the database the transaction isolation level can not be changed within the session because the PreTest transaction is already active.
FIX:
Do not use the PreTest option from WebSphere to test the connected state of the OpenEdge database when there will be a need to change the transaction isolation level later during the session.