PQ62295: UNABLE TO START ADMIN SERVER USING WEBSPHERE 4.0.3 AND PQ60281 OR PQ61735 LEVELS OF CM CODE AND SQLSERVER REPOSITORY

 A fix is available

4.0.2-4.0.7: Component cumulative Connection Manager fix



APAR status
Closed as program error.

Error description
When running WebSphere Application Server 4.0.3 using SQLServer
database as the admin repository, and using the Merant SequeLink
JDBC driver to connect to the repository, unable to start the
admin server if Connection Manager e-fixes (
PQ60281 or 
PQ61735)
are installed.
.
When 
PQ60281 is installed, this message appears in tracefile:
DBMgr         W SMTL0039W: An exception occurred during database
query: select * from dbo.WLMBOOT_TABLE where GROUP_NAME = ?
java.sql.SQLException: [MERANT][SequeLink JDBC Driver]Method
setMaxFieldSize() cannot be called when the statement is
executed.
.
When 
PQ61735 is installed, this message appears in tracefile:
ExceptionUtil X CNTR0019E: Non-application exception occurred
while processing method find: java.rmi.RemoteException:
SECJ0008E: Exception while querying database; nested exception
is:
 java.sql.SQLException: [MERANT][SequeLink JDBC Driver]Method
Statement.setMaxRows() cannot be called when a result set is
open.
java.sql.SQLException: [MERANT][SequeLink JDBC Driver]Method
Statement.setMaxRows() cannot be called when a result set is
open.
.
Keywords: websphere was 4.0.3 4.0 PTF3 connection pooling admin
server
Local fix Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of        *
*                 Merant driver for JDBC data access.          *
****************************************************************
* PROBLEM DESCRIPTION: SQL Exception when using Merant         *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When using Merant driver, receive error that Method
Statement.setMaxRows() cannot be called when a result
set is open.  A case has been opened with Merant.
Problem conclusion
WebSphere made some changes to work-around the Merant bug.

*****************************************************

This eFix is a Cumulative Connection Manager eFix:
Please see the readme for all of the APAR's included in
this eFix.
Temporary fix Comments
APAR information
APAR number PQ62295
Reported component name WEBSPHERE AE NT
Reported component ID 5630A2201
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-06-14
Closed date 2002-06-25
Last modified date 2002-06-25

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

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 #: PQ62295
IBM Group: Software Group
Modified date: Jun 25, 2002