IBM Support

PI81260: OPENJPA DOESNOT PASSTHROUGH SSL CONNECTION PROPERTIES THAT SET USING OPENJPA.CONNECTIONPROPERTIES WHEN CREATING DB2 CONNECTION.

Fixes are available

9.0.0.5: WebSphere Application Server traditional V9.0 Fix Pack 5
9.0.0.6: WebSphere Application Server traditional V9.0 Fix Pack 6
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
9.0.0.7: WebSphere Application Server traditional V9.0 Fix Pack 7
17.0.0.3: WebSphere Application Server Liberty 17.0.0.3
17.0.0.4: WebSphere Application Server Liberty 17.0.0.4
18.0.0.1: WebSphere Application Server Liberty 18.0.0.1
18.0.0.2: WebSphere Application Server Liberty 18.0.0.2
9.0.0.8: WebSphere Application Server traditional V9.0 Fix Pack 8
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
9.0.0.9: WebSphere Application Server traditional V9.0 Fix Pack 9
18.0.0.3: WebSphere Application Server Liberty 18.0.0.3
9.0.0.10: WebSphere Application Server traditional V9.0 Fix Pack 10
18.0.0.4: WebSphere Application Server Liberty 18.0.0.4
19.0.0.1: WebSphere Application Server Liberty 19.0.0.1
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
19.0.0.2: WebSphere Application Server Liberty 19.0.0.2
19.0.0.3: WebSphere Application Server Liberty 19.0.0.3
9.0.0.11: WebSphere Application Server traditional V9.0 Fix Pack 11
19.0.0.4: WebSphere Application Server Liberty 19.0.0.4
19.0.0.5: WebSphere Application Server Liberty 19.0.0.5
9.0.5.0: WebSphere Application Server traditional Version 9.0.5 Refresh Pack
19.0.0.6: WebSphere Application Server Liberty 19.0.0.6
19.0.0.7: WebSphere Application Server Liberty 19.0.0.7
19.0.0.8: WebSphere Application Server Liberty 19.0.0.8
9.0.5.1: WebSphere Application Server traditional Version 9.0.5 Fix Pack 1
19.0.0.9: WebSphere Application Server Liberty 19.0.0.9
19.0.0.10: WebSphere Application Server Liberty 19.0.0.10
19.0.0.11: WebSphere Application Server Liberty 19.0.0.11
9.0.5.2: WebSphere Application Server traditional Version 9.0.5 Fix Pack 2
19.0.0.12: WebSphere Application Server Liberty 19.0.0.12
20.0.0.1: WebSphere Application Server Liberty 20.0.0.1
20.0.0.2: WebSphere Application Server Liberty 20.0.0.2
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3
20.0.0.3: WebSphere Application Server Liberty 20.0.0.3
20.0.0.4: WebSphere Application Server Liberty 20.0.0.4
20.0.0.5: WebSphere Application Server Liberty 20.0.0.5
20.0.0.6: WebSphere Application Server Liberty 20.0.0.6
9.0.5.4: WebSphere Application Server traditional Version 9.0.5 Fix Pack 4
20.0.0.7: WebSphere Application Server Liberty 20.0.0.7
20.0.0.8: WebSphere Application Server Liberty 20.0.0.8
9.0.5.5: WebSphere Application Server traditional Version 9.0.5 Fix Pack 5
20.0.0.9: WebSphere Application Server Liberty 20.0.0.9
20.0.0.10: WebSphere Application Server Liberty 20.0.0.10
20.0.0.11: WebSphere Application Server Liberty 20.0.0.11
20.0.0.12: WebSphere Application Server Liberty 20.0.0.12
9.0.5.6: WebSphere Application Server traditional Version 9.0.5 Fix Pack 6

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • OpenJPA does not currently passthrough SSL connection
    properties, that are set using the
    "openjpa.ConnectionProperties" persistence property, when
    creating a connection to a DB2 instance. Attempting to use
    something like <property name="openjpa.ConnectionProperties"
    value="sslConnection=true"/>, will result in the below
    exception.
    
    Exception in thread "main" <openjpa-2.2.2-r422266:1468616
    nonfatal general error>
    org.apache.openjpa.persistence.PersistenceException:
    There were errors initializing your configuration:
    <openjpa-2.2.2-r422266:1468616 fatal user error>
    org.apache.openjpa.util.UserException: A connection could not be
    obtained for driver class "com.ibm.db2.jcc.DB2Driver" and URL
    "jdbc:db2://watsondbpxx.rch.stglabs.ibm.com:51002/wtsnapi".  You
    may have specified an invalid URL.
        at
    org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectExcep
    tion(Dat
    aSourceFactory.java:255)
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server using the OpenJPA JPA provider       *
    ****************************************************************
    * PROBLEM DESCRIPTION: OpenJPA cannot establish a database     *
    *                      connection using SSL. The connection    *
    *                      is refused because the                  *
    *                      code attempts to connect to the SSL     *
    *                      port for the DB2 instance, but          *
    *                      OpenJPA does not add the SSL related    *
    *                      parameters to the JDBC connection       *
    *                      request.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    OpenJPA cannot establish a database connection using SSL.
    The following exception is seen if SSL configuration is used:
    <openjpa-2.2.2-r422266:1468616 fatal user error>
    org.apache.openjpa.util.UserException: A connection could not
    be
    obtained for driver class "com.ibm.db2.jcc.DB2Driver" and URL
    "jdbc:db2://XXX".
    You may have specified an invalid URL.
    at
    org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectExcep
    tion(Dat
    aSourceFactory.java:255)
    at
    org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictio
    nary(Dat
    aSourceFactory.java:241)
    at
    org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnection
    Factory(
    JDBCConfigurationImpl.java:733)
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI81260

  • Reported component name

    WEBSPHERE APP S

  • Reported component ID

    5724J0800

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-05-08

  • Closed date

    2017-07-19

  • Last modified date

    2017-07-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

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

  • R850 PSY

       UP

  • R900 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850"}]

Document Information

Modified date:
17 June 2021