I am getting same error. Did anyone get any resolution.
Exception in component tOracleOutput_2
java.sql.SQLException: Invalid column type: sqlType=2003
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?
What we can do is to make sure that Talend will be your best choice!
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.
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.