Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Have an error java.sql.SQLException: Unable to convert between net.sourceforge.jtds.jdbc.ClobImpl and INTEGER.

Highlighted
Four Stars

Have an error java.sql.SQLException: Unable to convert between net.sourceforge.jtds.jdbc.ClobImpl and INTEGER.

I have an error

 

java.sql.SQLException: Unable to convert between net.sourceforge.jtds.jdbc.ClobImpl and INTEGER.

 

How do I solve this?  

Highlighted
Moderator

Re: Have an error java.sql.SQLException: Unable to convert between net.sourceforge.jtds.jdbc.ClobImpl and INTEGER.

@gfred ,there could be column datatypes are not matching with source and the component where you were getting error.I would suggest you to use tConvertType component and be consistent with the metadata.

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now

Talend Cloud Developer Series – Fetching Studio License

This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License

Watch Now

Talend Cloud Developer Series - Introduction

The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform

Watch Now