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

Rational Application Developer for WebSphere Software 9.0
Rational Software Architect 9.0
Rational Software Architect for WebSphere Software 9.0
Rational Application Developer for WebSphere Software Fix Pack 3 (8.0.4.3) for 8.0.4
Rational Application Developer Standard Edition Fix Pack 3 (8.0.4.3) for 8.0.4

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