JDBC Connector- View Data Error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sriven786
Participant
Posts: 37
Joined: Wed Nov 08, 2017 1:36 pm

JDBC Connector- View Data Error

Post by sriven786 »

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)
Venkata Srini
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
sriven786
Participant
Posts: 37
Joined: Wed Nov 08, 2017 1:36 pm

Post by sriven786 »

Thanks chulett. I am contacting the Datastage Admins. Is the Error message something to do with Datastage or with Java Drivers?.
Venkata Srini
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply