IBM Support

PM96528: Validate SQL function does not return applicable errors if database password is not specified

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Environment: windows 7
    Product name: IBM? Rational? Business Developer
    
    Program Version    :  8.5.1
    Description.
    The Validate SQL function does not indicate any appropriate
    errors if the database password is not specified within the JDBC
    connection properties.
    A dialog box is presented to enter the applicable password but
    thereafter the result always specifies the Validate operation as
    successful regardless of if any errors are actually present.
    
    Example steps to reproduce the scenario.
    a) Implementing a validate operation on a simple SQL statement
    referring to the Employee sample table with the following
    columns where an error related to the MYTIME2 column is
    included:
                         #sql{
        select
         EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO,
         HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY, BONUS,
         COMM, MYTIME2
        from EMPLOYEE
       };
    
    After adding the application data source connection and saving
    the associated credentials implementing the validate will work
    as expected showing an appropriate error in the SQL Errors view.
    b) Uncheck the save password option on the datasource connection
    properties to illicit the enter credentials dialog box when
    implementing the validate option.
    c) The validate will then incorrectly still indicate this as
    successful, with no errors recorded, even though the column
    MYTIME2 is invalid.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The Validate SQL function does not work correctly when the
    database password is not specified within the JDBC
    connection properties.
    A dialog box is presented to enter the applicable password
    but thereafter the result always specifies the Validate
    operation as successful regardless of if any errors are
    actually present.
    

Problem conclusion

  • The problem is fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM96528

  • Reported component name

    RATL BUS DEV

  • Reported component ID

    5724S5000

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-06

  • Closed date

    2014-09-25

  • Last modified date

    2014-09-25

  • 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

    RATL BUS DEV

  • Fixed component ID

    5724S5000

Applicable component levels

  • R850 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
25 September 2014