JR50229: JDBC CONNECTOR FAILS WITH METHOD NOT SUPPORTED ERROR

APAR status

• Closed as program error.

Error description

• When JDBC Connector is used in a DataStage job to fetch data
  from the database or in InfoSphere Metadata Asset Manager to
  import table metadata from the database, it reports error
  indicating that a method is not supported by the driver.
  

Local fix

Problem summary

• The error was due to a limitation in the JDBC Connector code.
  When fetching data, the connector would assume that the JDBC
  driver is always capable of providing metadata from the prepared
   statement object. Similarly, when importing metadata assets,
  the connector would assume that the driver is always capable of
  providing metadata information about available indexes. In both
  cases, if the driver did not support the operation expected by
  the connector, the connector would not attempt to perform
  alternative operation and would instead report error
  java.sql.SQLException: Method not supported.
  

Problem conclusion

• The JDBC Connector was updated to fall back to alternate
  operations when the operation it invoked on the driver was not
  supported. When fetching data and the driver cannot provide
  metadata from the prepared statement, the connector now falls
  back to running and describing a static statement object. When
  importing metadata assets and the driver cannot provide index
  information, the connector now assumes that no index information
   is available and proceeds with the import.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R912 PSY

     UP