PM21097: Exract Data functionality not working for Sybase Database in Rational Application Developer

Rational Application Developer for WebSphere Software, Version 7.5.5.3
Rational Software Architect Standard Edition, Version 7.5.5.3

APAR status

• Closed as program error.

Error description

• When the Extract Data functionality is invoked for Sybase
  Database in Rational Application Developer, the wizard fails to
  finish.
  
  In data explorer view customer has data connections set up with
  DB2, Oracle and Sybase. With DB2 .
  - When he right clicks on a data source and selects ?Extract
  Data? it works for DB2, Derby and Oracle.
  But for Sybase vASC 12.5 it doesn?t work.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The problem was reported for Rational Application Developer
  (RAD) 7.5.2 - ?Extract Data functionality not working for
  Sybase Database in Rational Application Developer?
  
  Root Cause of the Problem: The problem occurs because the
  Product tries to call the methods getDatabaseMajorVersion()
  and getDatabaseMinorVersion() both of which were not
  supported in the older JDBC Drivers of Sybase (jconn2.jar),
  but their latest driver (jconn3.jar) addresses these
  methods.
  

Problem conclusion

• In connection profiles for Sybase 12.0, 12.5 and 12.x we
  provide for the use of the older driver which resulted in
  the problem. We now use the classname to connect as
  "com.sybase.jdbc2.jdbc.SybDriver". The Sybase 15.0 already
  uses the jconn3 profile which is
  "com.sybase.jdbc3.jdbc.SybDriver" and hence no issue with
  it. Hence this is upgraded.
  
  This issue is fixed in Rational Application Developer
  7.5.5.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

  BUILD FORGE EE

• Fixed component ID

  5724S2701

Applicable component levels

• R701 PSN

     UP