PM81716: Using the connection wizard with IBM Data Server Driver for JDBC and SQLJ drivers fails with a syntax error popup

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Abstract:
    
    Attempts to select driver 'IBM Data Server Driver for JDBC and
    SQLJ' results in popup window showing 'Invalid database URL
    syntax'.
    
    Problem:
    
    You create a New Connection Profile in Data Source Explorer,
    with Database Manager: Informix and JDBC Driver: IBM Data Server
    Driver for JDBC and SQLJ (any).
    You observe the connection string reads similar to the
    following:
    jdbc:ids://localhost:50000/SAMPLE:retrieveMessagesFromServerOnGe
    tMessage=true;DELIMIDENT=true;SAMPLE
    You click next and see the error message: Invalid database URL
    syntax
    
    Local fix:
    
    To workaround this problem, you need to manually add a semicolon
    (';') to the driver definition:
    
    1. Go to the Preference Window?Preferences?Data
    Management?Connectivity?Driver Definition
    2. Double click on the appropriate Driver (eg. Informix 11.7 -
    IBM Data Server Driver for JDBC and SQLJ Default)
    3. In the new dialog box, select the tab 'Properties'
    4. Click on the 'Connection URL' field
    5. Change the existing value of
    jdbc:ids://localhost:50000/SAMPLE
    to
    jdbc:ids://localhost:50000/SAMPLE;
    (Note the semicolon on the end)
    6. Press Enter and then press OK to save
    7. Create a new connection.
    8. Note that the connection URL is different (does not end with
    'SAMPLE') and does not cause a syntax error.
    

Local fix

Problem summary

  • Selecting the driver 'IBM Data Server Driver for JDBC and SQLJ'
    results in popup window showing "Invalid database URL syntax".
    

Problem conclusion

  • The fix for this APAR is included in Rational Application
    Developer v8.0.4.3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM81716

  • Reported component name

    RATL APP DEV WI

  • Reported component ID

    5724J1901

  • Reported release

    851

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-30

  • Closed date

    2013-10-28

  • Last modified date

    2013-10-28

  • 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 APP DEV WI

  • Fixed component ID

    5724J1901

Applicable component levels

  • R804 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Application Developer for WebSphere Software

Software version:

8.5.1

Reference #:

PM81716

Modified date:

2013-10-28

Translate my page

Machine Translation

Content navigation