DSXchange

I am using the jdbc connector stage for the First Time. Established the isjdbc.config and the Tested the Connection Successfully using the URL and Id and password.

Wrote a simple query to fetch the SELECT COUNT(*) from the Table to check the Query if its running fine. Defined the Count as Integer in the Columns.

When try to view the data, getting below error message.

Appreciate if anyone has faced similar Issue.
Connection is success but view data giving error

View Data gives below error message

The connector failed to add missing columns to the output link. The Reported error is :java.lang.NullPointerException

RCP is not checked
Below is the log from Director when try to run the DS Job

JDBC_Connector_0: java.lang.NullPointerException
at com.ssc.eis.helium.jdbc.SSCPreparedStatement.getMetaData (SSCPreparedStatement.java: 87)
at com.ibm.is.cc.jdbc.CC_JDBCRecordDataSetProducer.setupOperation (CC_JDBCRecordDataSetProducer.java: 814)
at com.ibm.is.cc.jdbc.CC_JDBCAdapter.preRun (CC_JDBCAdapter.java: 662)

In your shoes I would involve your official support provider as a "null pointer exception" is generally a coding error / bug in my experience.

Thanks chulett. I am contacting the Datastage Admins. Is the Error message something to do with Datastage or with Java Drivers?.

DataStage would be my guess... and IBM should be to confirm or deny that.