PQ66566: NOWAIT KEYWORD ON A PREPARED STATEMENT CAN CAUSE "UNSUFFICIENT PARAMETERS" MSG | |||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||
![]() 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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: PQ61408 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 #: PQ66566
IBM Group: Software Group
Modified date: Oct 17, 2002
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.