|
| Problem | Applications using PreparedStatement connection to DB2, in which the PreparedStatement contains the "FETCH FIRST <n> ROWS ONLY" clause where <n> is a valid literal value for the number of rows to be fetched, receive the following error:
COM.ibm.db2.jdbc.DB2Exception:
[IBM][CLI Driver][DB2/NT] SQL0405N The numeric literal "0" is not valid
because its value is out of range. SQLSTATE=42820 | | Cause | When problem occurs in DB2 version 7.2 fix pack 8, or earlier, solution is to upgrade to DB2 fix pack 9, which contains the fix IY34909. (IY34909 is not available as a separate fix but is mentioned here for explanatory reasons. )For details on the defect and fix, see http://www-1.ibm.com/support/docview.wss?uid=swg1IY34909. | | Solution | Upgrade the DB2 client installation to fix pack 9 or later. The fix is in the DB2 client code. If the instance of DB2 is remote, it is necessary to upgrade the DB2 client on the server that WebSphere Application Server is installed only, although it is a good practice to upgrade the DB2 server to the same fix pack level as well.Note: DB2 Client must be bound after the upgrade, for the fix to take effect. Instructions are in the DB2 fix pack readme file. | |
| | | |
| |
|
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, 4.0, 5.0, 5.1, 6.0 Software edition: Edition Independent Reference #: 1114166 IBM Group: Software Group Modified date: 2003-07-03
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|