|
| Problem | Using DB2's statement "SET SCHEMA ..." causes the exception: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY cannot be found. | | | | Solution | In DB2 UDB Version 7.2 FixPack 5 and higher (because of J2EE compliance), the method executeQuery must be used for query statements (SELECT) and executeUpdate should be used for non-query (INSERT, UPDATE, DDL, etc.) statements.The SET SCHEMA statement changes the value of the CURRENT SCHEMA special register (for more information, please see DB2's SQL Reference manual). It is a non-query statement, so the executeUpdate method must be used. | |
| | |
| |
|
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 Software edition: Edition Independent Reference #: 1066402 IBM Group: Software Group Modified date: 2003-09-09
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|