# Ltree Support for kafka connect JDBC Sink Connector

**URL:** <https://forum.confluent.io/t/ltree-support-for-kafka-connect-jdbc-sink-connector/10255>\
**Category:** Kafka Connect\
**Created:** [26 February 2024 06:43 UTC](https://forum.confluent.io/t/ltree-support-for-kafka-connect-jdbc-sink-connector/10255 "2024-02-26T06:43:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abdugani](https://avatars.discourse-cdn.com/v4/letter/a/c0e974/32.png) [@Abdugani](https://forum.confluent.io/u/Abdugani)\
**Post date:** [26 February 2024 06:43 UTC](https://forum.confluent.io/t/ltree-support-for-kafka-connect-jdbc-sink-connector/10255/1 "2024-02-26T06:43:30Z")

</div>

Hello! I encountered a problem with field type not being supported ltee, how can I fix this?

Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Hint: You will need to rewrite or cast the expression.  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Position: 584 Call getNextException to see other errors in the batch.  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: org.postgresql.util.PSQLException: ERROR: column “parent\_hiera” is of type ltree but expression is of type character varying  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Hint: You will need to rewrite or cast the expression.  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Position: 584  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: org.postgresql.util.PSQLException: ERROR: column “parent\_hi” is of type ltree but expression is of type character varying  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Hint: You will need to rewrite or cast the expression.  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Position: 584  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at io.confluent.connect.jdbc.sink.JdbcSinkTask.put(JdbcSinkTask.java:118)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.deliverMessages(WorkerSinkTask.java:601)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.poll(WorkerSinkTask.java:350)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.iteration(WorkerSinkTask.java:250)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.execute(WorkerSinkTask.java:219)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:204)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:259)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.isolation.Plugins.lambda$withClassLoader$1(Plugins.java:236)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)  
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [27 March 2024 06:43 UTC](https://forum.confluent.io/t/ltree-support-for-kafka-connect-jdbc-sink-connector/10255/2 "2024-03-27T06:43:44Z")

</div>

Closed on 27 March 2024 06:43 UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.