PM95797: WORKLIGHT INSTALLER DOES NOT SUPPORT JDBC URLS FOR ORACLE OTHER THAN THE "THIN" DRIVER WITH A SID STYLE

APAR status

• Closed as fixed if next.

Error description

• When installing Worklight using an Oracle database, there are 4
  styles of JDBC URLs that Oracle supports:
  
  Oracle JDBC Thin using an SID:
  jdbc:oracle:thin:@<host>:<port>:<SID>
  Example: jdbc:oracle:thin:192.168.2.1:1521:X01A
  Note: Support for SID is being phased out. Oracle recommends
  that users switch over to using service names.
  
  Oracle JDBC Thin using a Service Name:
  jdbc:oracle:thin:@//<host>:<port>/<service_name>
  Example: jdbc:oracle:thin:@//192.168.2.1:1521/XE
  
  Oracle JDBC Thin using a TNSName:
  jdbc:oracle:thin:@<TNSName>
  Example: jdbc:oracle:thin:@GL
  Note: Support for TNSNames was added in the driver release
  10.2.0.1
  
  Generic Oracle JDBC Thin URL:
  For Oracle RAC, one customer reports that he is using the JDBC
  URL
  jdbc:oracle:thin:@(Description = (Failover=ON) (Address_List=
  (Load_Balance=ON) (address = (protocol = tcp) (host =
  $HOSTNAME1) (port = 1521)) (address = (protocol = tcp)(host =
  $HOSTNAME2) (port = 1521)) ) (Connect_data=(service_name =
  $SERVICENAME.domain.ext) ) )
  
  The Worklight installer currently only supports the SID syntax
  and is unable to connect to the database.
  

Local fix

• A dummy databse may be specified during the installation to
  overcome this limitation:
       - Prepare an empty database (later steps are easier if it's
  Oracle, but it can also be DB2 or MySQL).
       - Install Worklight Server, specifying this database.
       - In the WAS console, if the dummy database is not Oracle,
  create a JDBC provider for Oracle, as described in step 1 of
  
  http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topi
  c=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Ft_configuring_webspher
  e_application_server_for_oracle_manually.html
         and update the worklight.properties file, as described in
  
  http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topi
  c=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Ft_setting_up_your_orac
  le_database_manually.html
       - In the WAS console, delete the dummy datasources, and
  create a JDBC  datasource for WRKLGHT and one for WLREPORT, with
  the
  JNDI names 'jdbc/WorklightDS' and 'jdbc/WorklightReportsDS',
  respectively, as described in
  http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topi
  c=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Ft_configuring_webspher
  e_application_server_for_oracle_manually.html
         Here you can specify any URL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Administrators of  Worklight 5.0.x or Worklight 6.0.0.0, who *
  * attempt to install Worklight Server with reference to an     *
  * Oracle database which is not just a simple database with a   *
  * SID.                                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When installing Worklight using an Oracle database, there    *
  * are 4                                                        *
  * styles of JDBC URLs that Oracle supports:                    *
  *                                                              *
  * Oracle JDBC Thin using an SID:                               *
  * jdbc:oracle:thin:@<host>:<port>:<SID>                        *
  * Example: jdbc:oracle:thin:192.168.2.1:1521:X01A              *
  * Note: Support for SID is being phased out. Oracle recommends *
  * that users switch over to using service names.               *
  *                                                              *
  * Oracle JDBC Thin using a Service Name:                       *
  * jdbc:oracle:thin:@//<host>:<port>/<service_name>             *
  * Example: jdbc:oracle:thin:@//192.168.2.1:1521/XE             *
  *                                                              *
  * Oracle JDBC Thin using a TNSName:                            *
  * jdbc:oracle:thin:@<TNSName>                                  *
  * Example: jdbc:oracle:thin:@GL                                *
  * Note: Support for TNSNames was added in the driver release   *
  * 10.2.0.1                                                     *
  *                                                              *
  * Generic Oracle JDBC Thin URL:                                *
  * For Oracle RAC, one customer reports that he is using the    *
  * JDBC                                                         *
  * URL                                                          *
  * jdbc:oracle:thin:@(Description = (Failover=ON)               *
  * (Address_List=                                               *
  * (Load_Balance=ON) (address = (protocol = tcp) (host =        *
  * $HOSTNAME1) (port = 1521)) (address = (protocol = tcp)(host  *
  * =                                                            *
  * $HOSTNAME2) (port = 1521)) ) (Connect_data=(service_name =   *
  * $SERVICENAME.domain.ext) ) )                                 *
  *                                                              *
  * The Worklight installer currently only supports the SID      *
  * syntax                                                       *
  * and is unable to connect to the database.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * -                                                            *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• The product supports references to Oracle databases through JDBC
  URLs other than the simple
  ones for SIDs in fixpack 6.0.0.1 and later.
  

APAR Information

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

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

Fix information

Applicable component levels

• R506 PSY

     UP