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 number
JR50229
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
912
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-05-13
Closed date
2014-06-23
Last modified date
2014-06-23
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"912","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
23 June 2014