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)
JDBC Connector- View Data Error
Moderators: chulett, rschirm, roy
JDBC Connector- View Data Error
Venkata Srini