PQ87211: Connection requests with different isolation levels are sharing the same physical connection to Cloudscape. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() 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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
Publications Referenced
|
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
(C) Copyright IBM Corporation 2000, 2008. All Rights Reserved.