PQ66791: WEBSPHERE 3.5 STYLE "JDBC/MYDS" JDBC CONNECTION LOOKUPS FAIL WHEN PORTED ONTO WEBSPHERE 4.01 | |||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description A simple servlet tries to connect using a datasource and execute a select query. The JDBC fails with the error message below: com.ibm.db2.jcc.DB2SQLException: DB2JDBCCursor Received Error in Method prepare:SQLCODE==> -204 SQLSTATE ==> 42704 Error Tokens ==><<DB2 7.1 SQLJ/JDBC>> S.VCBMTRX at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJJDBCCursor.setError( DB2SQLJJDBCCursor. java:1139) atLocal fix Recode the JDBC lookup(s) to use the J2EE style of connection, java:comp/env/jdbc/myds in the application.Problem summary **************************************************************** * USERS AFFECTED: All users of WebSphere Application Server * * V4.0.1 for z/OS and OS/390 * **************************************************************** * PROBLEM DESCRIPTION: Datasource objects returned via the * * jdbc/ <resource_name> JNDI lookup * * convention do not get successfully * * configured. * **************************************************************** * RECOMMENDATION: * **************************************************************** Datasource properties set while creating a J2EE resource (via the SM EUI) are not propagated to the datasource object returned on JNDI lookup up via the jdbc/<resource_name> convention. Consequently, operations on the DataSource object can fail because of this. The DataSource object needs to be configured with the set properties correctly.Problem conclusion Support has been modified to configure the Datasource object returned from a JNDI lookup (jdbc/<resource_name>) appropriately. APAR PQ66791 is associated with SERVICE LEVEL W401403 of WebSphere Application Server V4.0.1 for z/OS and OS/390.Temporary fix Comments
APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
|
Document Information |
Product categories: Software > Application Servers >
Distributed Application & Web Servers > WebSphere Application
Server for z/OS
Operating system(s):
Software version: 401
Software edition:
Reference #: PQ66791
IBM Group: Software Group
Modified date: Nov 3, 2002
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.