IBM Support

PM08812: TEST CONNECTION FAILS WHEN A WEBSPHERE VARIABLE IS USED IN THE DATA SOURCE URL VALUE

Fixes are available

7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for AIX
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for HP-UX
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for IBM i
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Linux
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Solaris
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Windows
7.0.0.13: Java SDK 1.6 SR8FP1 Cumulative Fix for WebSphere Application Server
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for AIX
7.0.0.15: Java SDK 1.6 SR9 Cumulative Fix for WebSphere Application Server
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for HP-UX
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for IBM i
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Linux
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Solaris
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Windows
7.0.0.17: WebSphere Application Server V7.0 Fix Pack 17
7.0.0.17: Java SDK 1.6 SR9 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.19: WebSphere Application Server V7.0 Fix Pack 19
7.0.0.21: WebSphere Application Server V7.0 Fix Pack 21
7.0.0.23: WebSphere Application Server V7.0 Fix Pack 23
7.0.0.25: WebSphere Application Server V7.0 Fix Pack 25
7.0.0.27: WebSphere Application Server V7.0 Fix Pack 27
7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
7.0.0.19: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.21: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere
7.0.0.23: Java SDK 1.6 SR10 FP1 Cumulative Fix for WebSphere
7.0.0.25: Java SDK 1.6 SR11 Cumulative Fix for WebSphere Application Server
7.0.0.27: Java SDK 1.6 SR12 Cumulative Fix for WebSphere Application Server
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Test Connection will fail when a WebSphere variable is
    included in the URL field of a data source.  For example,
    suppose a WebSphere variable is defined as follows:
    
    Name:  ORACLE_DB
    Value:  WASHost1:1521:WASdatabase
    
    
    If the URL value on a data source includes the above variable,
    the Test Connection will fail because the variable will not be
    expanded:
    
    jdbc:oracle:thin:@${ORACLE_DB}
    
    
    The failure may generate the following Unknown Host error:
    
    [2/22/10 14:28:23:905 EST] 00000018 DSConfigurati 3   Exception
    java.sql.SQLException: Unknown host specified DSRA0010E: SQL
    State = 62000, Error Code = 118
    at
    oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappi
    ng.java:70)
    at
    oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.j
    ava:133)
    at
    oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
    .java:199)
    at
    oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
    .java:480)
    at
    oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
    at
    oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.
    java:508)
    at
    oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
    at
    oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExt
    ension.java:33)
    at
    oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
    

Local fix

  • Replace the variable in the URL with the actual value
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V7.0 who use WebSphere variables as  *
    *                  part of an Oracle URL                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Test Connection would fail when a       *
    *                      WebSphere variable is used in a         *
    *                      datasource URL                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    For example, suppose a WebSphere variable is defined as follows:
    
     Name:  ORACLE_DB
     Value:  WASHost1:1521:WASdatabase
    
    If the URL value on a data source includes this variable, the
    Test Connection will fail because the variable will not be
    expanded:
    
    jdbc:oracle:thin:@${ORACLE_DB}.
    
    The failure may generate the following Unknown Host error:
    [2/22/10 14:28:23:905 EST] 00000018 DSConfigurati 3   Exception
    java.sql.SQLException: Unknown host specified DSRA0010E: SQL
    State = 62000, Error Code = 118
    at
    oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappi
    ng.java:70)
    at
    oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.j
    ava:133)
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM08812

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-03-02

  • Closed date

    2010-03-30

  • Last modified date

    2010-05-19

  • APAR is sysrouted FROM one or more of the following:

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

Fix information

  • Fixed component name

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R700 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PM08812

Modified date: 19 May 2010