PQ93910: SELECT not allowed in this JDBC usage | |||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description Websphere Application Server throws the following exception processing an SQL statement in an application when a. PMI is active AND b. WebSphere statement caching is disabled. Trace: 2004/08/20 18:50:40.334 01 t=9D4188 c=1.2 key=P8 (13007002) FunctionName: com.ibm.websphere.rsadapter.GenericDataStoreHelper SourceId: com.ibm.websphere.rsadapter.GenericDataStoreHelper Category: ENTRY ExtendedMessage: findMappingClass for exception; java.sql.SQLException: DB2JDBCSQLCompiler Received Error in Meth od compileSQL -> SELECT not allowed in this JDBC usage at COM.ibm.db2os390.sqlj.jdbc.DB2JDBCSQLCompiler.compileSQL(DB2 at COM.ibm.db2os390.sqlj.jdbc.DB2JDBCSQLCompiler.compileSQL(DB2 at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection.prepareCall(DB2 at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection.prepareCall(DB2 at com.ibm.db2.jcc.DB2LogicalConnection.prepareCall(DB2LogicalC at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareCall(WS at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement( at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(Local fix Disable PMI or Enable WebSphere Statement caching.Problem summary **************************************************************** * USERS AFFECTED: All users of WebSphere Application Server * * V5.0 for z/OS * **************************************************************** * PROBLEM DESCRIPTION: When JDBC statement caching is disabled * * and PMI monitoring is enabled for the * * JDBC module, an SQLException (such as * * one indicating: "SELECT not allowed in * * this JDBC usage", for example) may be * * thrown when the application does a * * connection.prepareStatement(). * **************************************************************** * RECOMMENDATION: * **************************************************************** When JDBC statement caching is disabled and PMI monitoring is enabled for the JDBC module, and when an application invokes the JDBC method: connection.prepareStatement, the Relational Resource Adapter (RRA) incorrectly forwards a connection.prepareCall() to the JDBC Connection wrappered by the RRA, rather than forwarding the connection.prepareStatement() invocation. This may cause the JDBC driver's implementation to throw an SQLException when the prepareCall() is incorrectly issued. As an example, when using the DB2 JDBC legacy driver via the "DB2 for zOS Local JDBC Provider (RRS)", the following exception stack trace could be seen. ./bborjtr.cpp+820 ... BBOO0223I Servlet Error - DB2JDBCSQLCompi Received Error in Method compileSQL -> SELECT not allowed in JDBC usage : java.sql.SQLException: DB2JDBCSQLCompiler Received in Method compileSQL -> SELECT not allowed in this JDBC usage at COM.ibm.db2os390.sqlj.jdbc.DB2JDBCSQLCompiler.compileSQL at COM.ibm.db2os390.sqlj.jdbc.DB2JDBCSQLCompiler.compileSQL at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection.prepareCall at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection.prepareCall at com.ibm.db2.jcc.DB2LogicalConnection.prepareCall at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareCall at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement ... traceback continues with user's application code here ...Problem conclusion RRA fixed to correctly forward application connection.prepareStatement() calls onto the wrappered JDBC connection, in the case in which JDBC statement caching is disabled and PMI monitoring is enabled for the JDBC module. APAR PQ93910 is associated with SERVICE LEVEL W502016 of Sphere Application Server V5.0 for z/OS.Temporary fix Comments
APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: PQ93911 Modules/Macros
Publications Referenced
|
Document Information |
Current web document: swg1PQ93910.html
Product categories: Software > Application Servers >
Distributed Application & Web Servers > WebSphere Application
Server for z/OS
Operating system(s):
Software version: 500
Software edition:
Reference #: PQ93910
IBM Group: Software Group
Modified date: Nov 1, 2004
(C) Copyright IBM Corporation 2000, 2009. All Rights Reserved.