SQL JDBC Error

[Anonymous]

I am getting same error. Did anyone get any resolution.
Exception in component tOracleOutput_2
java.sql.SQLException: Invalid column type: sqlType=2003
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4405)
at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4293)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1280)
at local_project.ods_distributor_master_0_1.ODS_Distributor_Master.tOracleInput_2Process(ODS_Distributor_Master.java:16863)
at local_project.ods_distributor_master_0_1.ODS_Distributor_Master.runJobInTOS(ODS_Distributor_Master.java:35368)
at local_project.ods_distributor_master_0_1.ODS_Distributor_Master.main(ODS_Distributor_Master.java:35182)

Thanks,
Abhijit 

[Anonymous]

Hi,
Could you please post your DB connection setting screenshot into forum which will be helpful for us to address your issue?
Can you connect to your oracle DB successfully using client without using talend tool?
Best regards
Sabrina

[Anonymous]

Hello Sarbina, 
Thanks for your response. 
I have no issues with the connection set up. I say this as I have many other jobs running on the same connection. I believe this specific error is occurring dues to some type mismatch or may be some null pointer handling issue. I don't know how to fix it
I am pasting a screenshot of the connection.

Thanks,
Abhijit 

[Anonymous]

Hi,
We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
Best regards
Sabrina

[Anonymous]

See Below

[Anonymous]

Hi,
Screenshots works only if you drag&drop the image directly in the editor window. 
Best regards
Sabrina                                                                                                                                    

[Anonymous]

I have done so

[Anonymous]

I believe the error occured due to null value insertion to a data type  "byte[]"  
Once I changed the data type it didn't throw any error.
My next question to you is How do I propagate this data type change to all my mappings?  I have 20 + mappings in one job and I don't want to manually change the data type for that field by going to each and every map.  
I greatly appreciate your help.
Thanks!
Abhijit