# JDBC Sink Connector fails

**URL:** <https://forum.confluent.io/t/jdbc-sink-connector-fails/9514>\
**Category:** Kafka Streams\
**Created:** [14 December 2023 11:04 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails/9514 "2023-12-14T11:04:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Praveena](https://avatars.discourse-cdn.com/v4/letter/p/49beb7/32.png) [@Praveena](https://forum.confluent.io/u/Praveena)\
**Post date:** [14 December 2023 11:04 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails/9514/1 "2023-12-14T11:04:46Z")

</div>

I am trying to write a free from text from Kafka to Teradata database using JDBC connector. It fails with error java.sql.SQLException: [Teradata Database] [TeraJDBC 17.00.00.02] [Error 3798] [SQLState 42000] A column or character expression is larger than the max size.

I tried to change the teradata column to varchar max, long varchar, clob max but the input stream has length more that what teradata allows. Is it possible to chop this field or any workarounds?

---

<div class="post-metadata">

**Author:** ![mmuehlbeyer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/mmuehlbeyer/32/1088_2.png) [@mmuehlbeyer](https://forum.confluent.io/u/mmuehlbeyer)\
**Post date:** [14 December 2023 15:58 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails/9514/2 "2023-12-14T15:58:27Z")

</div>

Hi @Praveena

maybe an SMT might be helpful.

> **[Get started with Single Message Transforms for self-managed connectors |...](https://docs.confluent.io/platform/current/connect/transforms/overview.html)**
>
> Learn how to use Single Message Transforms with Kafka connectors you manage yourself.

best,  
michael