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

 Fixes are available

4.0.5: WebSphere Application Server Version 4.0 Fix Pack 5 (Version 4.0.5)
4.0.2-4.0.7: Component cumulative Connection Manager fix



APAR status
Closed as program error.

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 number PQ66566
Reported component name WEBSPHERE AE AI
Reported component ID 5630A2200
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-09-25
Closed date 2002-10-16
Last modified date 2002-10-17

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:
PQ61408

Modules/Macros
JDBC          

SRLS

Fix information
Fixed component name WEBSPHERE AE AI
Fixed component ID 5630A2200

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 #: PQ66566
IBM Group: Software Group
Modified date: Oct 17, 2002