You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-04-04 21:29:19

abray027
Member
7 posts

abray027 said:

SQL JDBC Error

Tags: [bug, database, error, perl]

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 

Offline

#2 2017-04-05 04:31:27

xdshi
Talend Team


xdshi said:

Re: SQL JDBC Error

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2017-04-05 15:29:30

abray027
Member
7 posts

abray027 said:

Re: SQL JDBC Error

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 sad
I am pasting a screenshot of the connection.


Thanks,
Abhijit 

Offline

#4 2017-04-06 08:15:30

xdshi
Talend Team


xdshi said:

Re: SQL JDBC Error

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


What we can do is to make sure that Talend will be your best choice!

Offline

#5 2017-04-06 15:54:04

abray027
Member
7 posts

abray027 said:

Re: SQL JDBC Error

See Below

Offline

#6 2017-04-07 07:39:41

xdshi
Talend Team


xdshi said:

Re: SQL JDBC Error

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


mini_pastedImage.png_20170406-2339.png


What we can do is to make sure that Talend will be your best choice!

Offline

#7 2017-04-07 15:34:13

abray027
Member
7 posts

abray027 said:

Re: SQL JDBC Error

I have done so

mini_blob_20170405-0729.png


mini_blob_20170407-0735.png

Last edited by abray027 (2017-04-07 15:36:00)

Offline

#8 2017-04-07 15:38:51

abray027
Member
7 posts

abray027 said:

Re: SQL JDBC Error

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy