PQ93910: SELECT not allowed in this JDBC usage

 A fix is available

Obtain the fix for this APAR



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 information
APAR number PQ93910
Reported component name WEBSPHERE FOR Z
Reported component ID 5655I3500
Reported release 500
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2004-09-08
Closed date 2004-10-07
Last modified date 2004-11-01

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:
PQ93911

Modules/Macros
BBOUBINF          

Publications Referenced

Fix information
Fixed component name WEBSPHERE FOR Z
Fixed component ID 5655I3500

Applicable component levels
R500 PSY UQ93769    UP04/10/15 P F410

  Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.


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