COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY cannot be found.

Technote (FAQ)
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.












Document Information

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