IBM Support

LI74704: SQLCODE -805 RETURNED BY IBM DB2 DRIVER FOR JDBC AND SQLJ IF BOTH CURRENTPACKAGEPATH AND CURRENTFUNCTIONPATH SET

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using the IBM DB2 Driver for JDBC and SQLJ, the driver will
    not function correctly if the datasource properties
    currentFunctionPath and currentPackagePath are used in
    conjunction with each other.
    
    The driver currently flows currentFunctionPath before
    currentPackagePath.  If the packages used by set
    currentFunctionPath are unbound, an SQLCODE -805 error is thrown
    while executing the SET CURRENT PATH special register.
    
    Seting currentPackagePath will not fix the -805 problem because
    it is set after currentFunctionPath.
    
    This issue will also lead to SQLCODE -440 on calling stored
    procedures with unspecified (implicit) schema.
    
    To fix this problem, the driver will, in future releases, flow
    currentPackagePath first, so that the package path will apply to
    the following currentFunctionPath.
    

Local fix

Problem summary

  • When using the IBM DB2 Driver for JDBC and SQLJ, the driver will
    not function correctly if the datasource properties
    currentFunctionPath and currentPackagePath are used in
    conjunction with each other.
    
    The driver currently flows currentFunctionPath before
    currentPackagePath.  If the packages used by set
    currentFunctionPath are unbound, an SQLCODE -805 error is thrown
    while executing the SET CURRENT PATH special register.
    
    Seting currentPackagePath will not fix the -805 problem because
    it is set after currentFunctionPath.
    
    This issue will also lead to SQLCODE -440 on calling stored
    procedures with unspecified (implicit) schema.
    

Problem conclusion

  • To fix this problem, the driver will, in future releases, flow
    currentPackagePath first, so that the package path will apply to
    the following currentFunctionPath.
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74704

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-23

  • Closed date

    2010-05-07

  • Last modified date

    2010-05-07

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

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

    LI74705

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021