PQ65492: THE PREPAREDSTATEMENT FOR DB2 SHALL NOT BE USED FOR SQLSERVER AND INFORMIX DATABASE. FOR READONLY IS APPLICABLE FOR DB2 ONLY.

 A fix is available

4.0.5: WebSphere Application Server Version 4.0 Fix Pack 5 (Version 4.0.5)



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
PQ65492
Comments
APAR information
APAR number PQ65492
Reported component name WEBSPHERE AE NT
Reported component ID 5630A2201
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-08-21
Closed date 2002-09-24
Last modified date 2002-10-22

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
SESSIONS          

SRLS

Fix information
Fixed component name WEBSPHERE AE NT
Fixed component ID 5630A2201

Applicable component levels
R400 PSY    UP


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