PQ65492: THE PREPAREDSTATEMENT FOR DB2 SHALL NOT BE USED FOR SQLSERVER AND INFORMIX DATABASE. FOR READONLY IS APPLICABLE FOR DB2 ONLY. | |||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description DURING NON AFFINITY MODE AND USING SQLSERVER OR INFORMIX, THE PREPARED STATEMENT THAT IS BEING USED IS NOT SUPPORTED. THIS STATEMENT USES READONLY AND READONLY IS SUPPORTED ONLY IN DB2. The exception is thrown at BackedHashtable.getvalue. The abstarct of exception is "FOR READ ONLY clause allowed only for DECLARE CURSOR".Local fix Problem summary **************************************************************** * USERS AFFECTED: WebSphere Application Server -- Session * * Manager Users * **************************************************************** * PROBLEM DESCRIPTION: Session Object cannot be read in with * * Oracle and SQLServer as the databases. * **************************************************************** * RECOMMENDATION: * **************************************************************** In 4.0, with persistence enabled the session object gets read in whenever affinity breaks and the latest copy of the session object needs to be retrieved from the database. The sql query for reading in the session object with Informix and SQLServer as the databases was incorrectly constructed leading to a read failure.Problem conclusion This fix uses the correct sql query to read in the session object from these two databases.Temporary fix PQ65492Comments
APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
SRLS
|
Document Information |
Product categories: Software > Application Servers >
Distributed Application & Web Servers > WebSphere Application
Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ65492
IBM Group: Software Group
Modified date: Oct 22, 2002
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.