PQ55413: JTS DATASOURCE CONNECTION'S ISOLATION LEVEL IS CHANGED BY WAS AFTER USER SERVLET SETS IT.

A fix is available
3.5.4-3.5.7, 4.0.2-4.0.7: Component cumulative Connection Manager fix

APAR

APAR status
Closed as program error.

Error description
In user servlet, JTS connection's isolation level is set as 2
(TRANSACTION_READ_COMMITTED) before transaction. But it
is changed to 4 (TRANSACTION_REPEATABLE_READ) after
Connection.executeUpdate(). WAS changes Isolation level
during user transaction even if user sets it.
Local fix
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of        *
*                 Connection Manager who wish to set the       *
*                 Isoaltion Level on a servlet's datasource.   *
****************************************************************
* PROBLEM DESCRIPTION: Previously, in 3.5 there was no way to  *
*                      set the Isolation level for a           *
*                      transaction in a servlet.               *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Users needed a work-around to be able to set the
Isolation Level.   This was not supported in 3.5.
Problem conclusion
Code was changed to provide a means by which they can set the
Isolation level via a property "WAS35IsolationLevelOverride" in
the datasources.xml file.
Temporary fix
Comments
APAR information
APAR numberPQ55413
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2001-12-05
Closed date2002-01-22
Last modified date2002-01-22

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:


Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS ADVANCED AI
Fixed component ID5648C8400

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ55413
IBM Group: Software Group
Modified date: 2002-01-22