PQ66791: WEBSPHERE 3.5 STYLE "JDBC/MYDS" JDBC CONNECTION LOOKUPS FAIL WHEN PORTED ONTO WEBSPHERE 4.01

 A fix may be available

Obtain the fix for this APAR



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)  at
Local 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 information
APAR number PQ66791
Reported component name WASKBASE
Reported component ID 5655A9801
Reported release 401
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-10-01
Closed date 2002-10-24
Last modified date 2002-11-03

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
BBOUBINF          

Fix information
Fixed component name WASKBASE
Fixed component ID 5655A9801

Applicable component levels
R401 PSY UQ71162    UP02/10/31 P F210

  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


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