IBM Support

JR45848: JAVA.SQL.SQLEXCEPTION MAY OCCUR WHEN STARTING BPM VERSION 8.0.1 ND ON ORACLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a Business Process Manager Version 8.0.1 network
    deployment environment with Oracle as the database is started,
    an exception similar to the following may be logged in the
    deployment manager profile SystemOut.log file:
    
    FFDC Exception:java.sql.SQLException
    SourceId:com.ibm.bpm.db.jdbc.tasks.JdbcDriverTask ProbeId:188
    Reporter:com.ibm.bpm.db.jdbc.tasks.JdbcDriverTask@cc835ac6
    java.sql.SQLException: Invalid connection string format, a valid
    format is: "//host[:port][/service_name]"
    at
    oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
    at
    oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection
    .java:531)
    at
    oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
    at
    oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverEx
    tension.java:32)
    at
    oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
    at
    com.ibm.bpm.db.jdbc.tasks.JdbcDriverTask.getConnection(JdbcDriv
    erTask.java:196)
    at
    com.ibm.bpm.config.procsvr.tasks.BPMSecurityUnlockComponent.inv
    okeBPMUnlock(BPMSecurityUnlockComponent.java:119)
    at
    com.ibm.bpm.config.procsvr.tasks.BPMSecurityUnlockComponent.sta
    rt(BPMSecurityUnlockComponent.java:61)
    at
    com.ibm.ws.runtime.component.ContainerHelper.startComponents(Co
    ntainerHelper.java:539)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  Users of Business Process Manager.          *
    ****************************************************************
    * PROBLEM DESCRIPTION: When a Business Process Manager         *
    *                      Version 8.0.1 network deployment        *
    *                      environment with Oracle as the          *
    *                      database is started, a                  *
    *                      java.sql.SQLException error may be      *
    *                      logged in the deployment manager        *
    *                      profile SystemOut.log file.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The code does not properly retrieve the connection string
    (defined in the data source) for an Oracle database (the
    format differs from those of DB2 and Microsoft SQL Server).
    

Problem conclusion

  • The code was corrected to properly retrieve the connection
    string from the data source for an Oracle database (in
    addition to DB2 and Microsoft SQL Server, by detecting the
    type of database being used).
    
    An interim fix for Business Process Manager Version 8.0.1.0 has
    been published to Fix Central.  Please refer to the separate
    file that is automatically downloaded with the interim fix
    for prerequisite information and installation/uninstallation
    instructions.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45848

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-26

  • Closed date

    2013-06-13

  • Last modified date

    2013-06-13

  • 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

    BPM ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
13 June 2013