JR43526: [IBM][ORACLE JDBC DRIVER]THIS COLUMN TYPE IS NOT CURRENTLY SUPPORTED BY THIS DRIVER.

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• The below error is encountered while attempting to start
  'engmonapp' via:
  $ cd /opt/IBM/InformationServer/Server/DSODB/bin
  $ ./DSAppWatcher.sh -start EngMonApp
  
  2012-06-19 09:41:14,138 ERROR
  com.ibm.datastage.runtime.common.db.DBManager.selectAll(DBManage
  r.java:600) - Error executing Query statement: SELECT
  CONFIGID,NodeList FROM DSODB.ParallelConfig WHERE HOSTID = ? AND
  NodeListHash = ?. Values: [-2160008945165738165, 1562278868]
  java.sql.SQLException: [IBM][Oracle JDBC Driver]This column type
  is not currently supported by this driver.
  
  Ops Console was developed and tested against 11.2.0.1.
  It is caused by a change in behaviour in Oracle between 11.2.0.1
  and 11.2.0.2.
  At 11.2.0.2, Oracle changed the default storage type for XML
  objects, and that is not compatible with the way we handle them.
  
  Use the below command to get the exact oracle version
  SELECT * FROM V$VERSION;
  

Local fix

Problem summary

• User affected
    EngMonApp error: This column type is not currently supported
  by this driver
  
  Problem Description
    EngMonApp failed with the error below when connecting to
  Oracle database 11.2.0.2:
    ERROR
  com.ibm.datastage.runtime.common.db.DBManager.selectAll(DBManage
  r.java:
    600)  - Error executing Query statement: SELECT
  CONFIGID,NodeList FROM
    DSODB.ParallelConfig WHERE HOSTID = ? AND NodeListHash = ?.
  Values: [...]
    java.sql.SQLException: [IBM][Oracle JDBC Driver]This column
  type is not
    currently supported by this driver.
  
    Oracle 11.2.0.2 changed default XMLTYPE storage type from CLOB
  to binary.
    The branded Progress DataDirect JDBC driver does not support
  XMLTYPE binary
    storage.
    http://knowledgebase.datadirect.com/articles/Article/000027848
  

Problem conclusion

• Fixed the issue by changing the XMLTYPE column storage type from
  binary to CLOB.
  

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

• R870 PSY

     UP