PQ87211: Connection requests with different isolation levels are sharing the same physical connection to Cloudscape.

 A fix is available

5.1.0.5: WebSphere Application Server V5.1.0 Cumulative Fix 5



APAR status
Closed as program error.

Error description
Connection requests with different isolation levels are sharing
the same physical connection to Cloudscape.
.
Global Transactions with different isolation levels on the XA
Sharable connections configuration
are sharing a connection on Cloudscape database. This is a new
problem and they should not be sharing. below is the testcase
output and SystemOut.log output.
Connections are shared!
   at
fvt.tests.ConnectionSharingTest.testNotSharingInGlobalTran1(Conn
ectionSharingTest.java:1836)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
   at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
Impl.java:79)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
AccessorImpl.java(Compiled Code))
   at
org.apache.commons.cactus.AbstractTestCase.runServerTest(Abstrac
tTestCase.java:328)
   at
org.apache.commons.cactus.AbstractTestCase.runBareServerTest(Abs
tractTestCase.java:299)
   at
org.apache.commons.cactus.server.ServletTestCaller.callTestMetho
d(ServletTestCaller.java:148)
   at
org.apache.commons.cactus.server.ServletTestCaller.doTest(Servle
tTestCaller.java:200)
   at
org.apache.commons.cactus.server.ServletTestRedirector.doPost(Se
rvletTestRedirector.java:149)
   at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
   at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[4/2/04 18:04:56:698 EST] 1632a2a5 SystemOut     O   **
Transaction started
[4/2/04 18:04:56:718 EST] 1632a2a5 SystemOut     O  **  driver
name = Cloudscape Embedded JDBC Driver, driver version = 5.1,
database type = DBMS:db2j, database version = 5.1.45
[4/2/04 18:04:56:720 EST] 1632a2a5 SystemOut     O No record
found
.
This is caused by the fix made for 
PQ83623.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere application server users       *
*                 of Cloudscape Database                       *
****************************************************************
* PROBLEM DESCRIPTION: Connection Sharing mail fail. Global    *
*                      Transactions with different isolation   *
*                      levels on the XA Sharable config        *
*                      are sharing a connection on             *
*                      Cloudscape datatbase.                   *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
We always passed 'true' for supportsisolation level
switching, which caused the isolation level to be ignored
when matching connections, which caused the same managed
connection to be returned.
Problem conclusion
Fixed supportsisolation level.
Temporary fix Comments
APAR information
APAR number PQ87211
Reported component name WAS BASE 5.0
Reported component ID 5630A3600
Reported release 10I
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2004-04-06
Closed date 2004-04-22
Last modified date 2006-02-07

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
adapter          

Publications Referenced

Fix information

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00P PSY    UP
R00S PSY    UP
R00W PSY    UP
R103 PSY    UP
R10A PSY    UP
R10H PSY    UP
R10I PSY    UP
R10P PSY    UP
R10S PSY    UP
R10W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 10I
Software edition:
Reference #: PQ87211
IBM Group: Software Group
Modified date: Feb 7, 2006