PQ61408: NOWAIT KEYWORD ON A PREPARED STATEMENT CAN CAUSE "UNSUFFICIENT PARAMETERS" MSG

A fix is available
WebSphere Application Server Version 3.5 Fix Pack 7 (3.5.7)

APAR

APAR status
Closed with unknown close code.

Error description
Setting WebSphere's preparedStatementCache to a non-zero value
causes exceptions.
Local fix
Set WebSphere's prepared statement cache to zero.
Oracle's JDBC driver has it's own PreparedStatementCache, which
may be used if so desired.
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of        *
*                 prepared statements in Oracle with the       *
*                 NOWAIT keyword.                              *
****************************************************************
* PROBLEM DESCRIPTION: When running an Oracle prepared         *
*                      statement with the NOWAIT keyword, an   *
*                      SQL Exception may be thrown with the    *
*                      message text "Unsufficient number of    *
*                      parameter were set before execution"    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When running an Oracle prepared statement with the NOWAIT
keyword, if the first execute fails because of locks, and
the statement is retried successfully without re-preparing,
the statement was cached incorrectly, resulting in failures
each time the cached statement was executed.
Problem conclusion
Fixed WebSphere prepared statement caching to appropriately
handle this scenario.
Temporary fix
Comments
APAR information
APAR numberPQ61408
Reported component nameWEBSPHERE AE AI
Reported component ID5648C8400
Reported release350
StatusCLOSED
PENoPE
HIPERNoHIPER
Submitted date2003-03-03
Closed date2003-03-03
Last modified date2003-03-17

APAR is sysrouted FROM one or more of the following:
PQ66566

APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:PQ66566


Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWEBSPHERE AE AI
Fixed component ID5648C8400

Applicable component levels
R400 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ61408
IBM Group: Software Group
Modified date: 2003-03-17