PQ76632: THE DEFAULT ISOLATION LEVEL FOR SERVLETS CONNECTING TO DB2 TRANSACTION_REPEATABLE_READ NEEDS TO BE CLARIFIED.

APAR status
Closed as documentation error.

Error description
In Assembling J2EE Applications
Isolating transactions that access persistent data
lists the default descriptor value of TRANSACTION_NONE which
results in the JDBC isolation level of
TRANSACTION_REPEATABLE_READ for session and bmp entity beans.
Since servlets do not have a descriptor value for isolation
level the documentation needs to be clarified to indicate that
servlets that connect to db2 will also get a default JDBC
isolation level of TRANSACTION_REPEATABLE_READ.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 version 4.0.1 for z/OS and OS/390            *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
The default isolation level for servlets connecting to DB2
TRANSACTION_REPEATABLE_READ needs to be clarified.
Problem conclusion
The note following the isolation level default value
in Chapter 4, section "Isolating transactions that access
persistent data" of "WebSphere Application Server V4.0.1 for
z/OS and OS/390: Assembling J2EE Applications",SA22-7836-06,
will be changed to the following:

Notes:

1. For beans assembled and deployed with the default descriptor
   value TRANSACTION_NONE, WebSphere for z/OS actually uses the
   JDBC isolation level TRANSACTION_REPEATABLE_READ on
   connections that the EJB container acquires and uses to
   manage CMP persistent state in DB2.
2. Servlets do not have a descriptor value for isolation
   levels. Therefore, servlets that connect to DB2 will also
   get a default JDBC isolation level of
   TRANSACTION_REPEATABLE_READ.

NOTE: Periodically, we refresh the documentation on our Web site
so these changes might have been made before you read this text.
To access the latest on-line documentation, go to the product
library page at URL:

www.ibm.com/software/webservers/appserv/zos_os390/library
Temporary fix Comments
APAR information
APAR number PQ76632
Reported component name WASKBASE
Reported component ID 5655A9801
Reported release 401
Status CLOSED DOC
PE NoPE
HIPER NoHIPER
Submitted date 2003-07-22
Closed date 2003-09-02
Last modified date 2003-09-02

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Fix information

Applicable component levels


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS
Operating system(s):
Software version: 401
Software edition:
Reference #: PQ76632
IBM Group: Software Group
Modified date: Sep 2, 2003