|
| Problem | After applying the Connection Manager (CM) cumulative fix, WAS_CM_07-02-2003_3.5.x, you receive the following exception:
java.sql.SQLException: Missing IN or OUT parameter at index:: 1 | | Cause | In the Connection Manager (CM) cumulative fix, WAS_CM_07-02-2003_3.5.x, a call to clearParameters() is added to the connection manager code when connection manger put the prepared statement back to the cache. This is done in response to an APAR and to ensure statements coming out of the cache are the same as newly prepared statements. | | Solution | There are two possible reasons why the connection manager clearParameter() call produces the exception"java.sql.SQLException: Missing IN or OUT parameter at index:: 1":
- Application code is missing a setXXX method call somewhere.
Prior to this CM cumulative fix, the previous parameter would still be set, resulting in a successful execute. However, with the new clearParameter() call, the parameter is left empty, resulting in the Oracle exception. While the bug might be in the application code, it is exposed by the WebSphere® Application Server fix.
- There might be a problem in the Oracle® JDBC™ driver code.
When the executeBatch is called, a large number of statements (as many as 4000) succeed. However, during the close of the statement, the connection manager calls the clearParameters() method on the statement, and gets an Oracle SQLException: Internal Error. This statement is then thrown away and not cached.
Subsequent prepares of this SQL string result in a new prepare call to the JDBC driver, and all should continue normally. However, the second time executeBatch is called, Oracle throws the above exception. While these two errors might not be related, it seems very coincidental. This behavior can happen if Oracle statement caching is enabled and the internal error somehow corrupted these Oracle statements.
| |
| | |
| |
|
Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Java 2 Connectivity (J2C) Operating system(s): Multi-Platform Software version: 3.5 Software edition: Standard Reference #: 1163246 IBM Group: Software Group Modified date: 2004-03-15
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|