# JDBC sink connector fails immediately with no errors in log

**URL:** <https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585>\
**Category:** Self-Managed Connectors\
**Created:** [25 March 2022 15:17 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585 "2022-03-25T15:17:12Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![robcam73](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/robcam73/32/1651_2.png) [@robcam73](https://forum.confluent.io/u/robcam73)\
**Post date:** [25 March 2022 15:17 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/1 "2022-03-25T15:17:12Z")

</div>

I am trying to use the JDBC MySql sink connector to output a topic (AVRO format).  
I installed the JDBC MS Sql driver in the folder with the connector jar.  
When I follow these instructions

> **[demo-scene/kafka-to-database at master · confluentinc/demo-scene](https://github.com/confluentinc/demo-scene/tree/master/kafka-to-database)**
>
> master/kafka-to-database

The connector immediately goes to a failed state and there are no errors in the connector log  
Where can I look to find the error?

---

<div class="post-metadata">

**Author:** ![rmoff](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/rmoff/32/3_2.png) [@rmoff](https://forum.confluent.io/u/rmoff)\
**Post date:** [26 March 2022 10:03 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/2 "2022-03-26T10:03:44Z")

</div>

The Kafka Connect worker log will have the reason for the failure.  
Are you using the docker-compose.yml from that link? `docker-compose logs kafka-connect` should provide the logs.

---

<div class="post-metadata">

**Author:** ![robcam73](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/robcam73/32/1651_2.png) [@robcam73](https://forum.confluent.io/u/robcam73)\
**Post date:** [26 March 2022 10:09 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/3 "2022-03-26T10:09:37Z")

</div>

This is all that is logged

```auto
[2022-03-26 09:32:12,571] INFO Setting connector sink-jdbc-mysql-01 state to STARTED (org.apache.kafka.connect.runtime.Worker)
[2022-03-26 09:32:12,572] INFO SinkConnectorConfig values:
        config.action.reload = restart
        connector.class = io.confluent.connect.jdbc.JdbcSinkConnector
        errors.deadletterqueue.context.headers.enable = false
        errors.deadletterqueue.topic.name =
        errors.deadletterqueue.topic.replication.factor = 3
        errors.log.enable = false
        errors.log.include.messages = false
        errors.retry.delay.max.ms = 60000
        errors.retry.timeout = 0
        errors.tolerance = none
        header.converter = null
        key.converter = class org.apache.kafka.connect.storage.StringConverter
        name = sink-jdbc-mysql-01
        predicates = []
        tasks.max = 1
        topics = [test01]
        topics.regex =
        transforms = []
        value.converter = class io.confluent.connect.avro.AvroConverter
 (org.apache.kafka.connect.runtime.SinkConnectorConfig)
[2022-03-26 09:32:12,573] INFO EnrichedConnectorConfig values:
        config.action.reload = restart
        connector.class = io.confluent.connect.jdbc.JdbcSinkConnector
        errors.deadletterqueue.context.headers.enable = false
        errors.deadletterqueue.topic.name =
        errors.deadletterqueue.topic.replication.factor = 3
        errors.log.enable = false
        errors.log.include.messages = false
        errors.retry.delay.max.ms = 60000
        errors.retry.timeout = 0
        errors.tolerance = none
        header.converter = null
        key.converter = class org.apache.kafka.connect.storage.StringConverter
        name = sink-jdbc-mysql-01
        predicates = []
        tasks.max = 1
        topics = [test01]
        topics.regex =
        transforms = []
        value.converter = class io.confluent.connect.avro.AvroConverter
 (org.apache.kafka.connect.runtime.ConnectorConfig$EnrichedConnectorConfig)
[2022-03-26 09:32:12,573] INFO Setting task configurations for 1 workers. (io.confluent.connect.jdbc.JdbcSinkConnector)

```

---

<div class="post-metadata">

**Author:** ![robcam73](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/robcam73/32/1651_2.png) [@robcam73](https://forum.confluent.io/u/robcam73)\
**Post date:** [28 March 2022 07:33 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/4 "2022-03-28T07:33:02Z")

</div>

I will try the docker yaml from the link. I am using the one from the confluent intaller page here [Quick Start for Confluent Platform | Confluent Documentation](https://docs.confluent.io/platform/current/quickstart/ce-docker-quickstart.html#cp-quickstart-step-1)

Is there a difference?

Thanks

---

<div class="post-metadata">

**Author:** ![rmoff](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/rmoff/32/3_2.png) [@rmoff](https://forum.confluent.io/u/rmoff)\
**Post date:** [28 March 2022 08:06 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/5 "2022-03-28T08:06:02Z")

</div>

> [@robcam73](#):
>
> This is all that is logged

Is there literally nothing else in the entire log?

---

<div class="post-metadata">

**Author:** ![rmoff](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/rmoff/32/3_2.png) [@rmoff](https://forum.confluent.io/u/rmoff)\
**Post date:** [28 March 2022 08:11 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/6 "2022-03-28T08:11:04Z")

</div>

> [@robcam73](#):
>
> I will try the docker yaml from the link. I am using the one from the confluent intaller page here [Quick Start for Confluent Platform | Confluent Documentation](https://docs.confluent.io/platform/current/quickstart/ce-docker-quickstart.html#cp-quickstart-step-1)
> 
> Is there a difference?

They load different components, for example I don’t know if the quick start includes the JDBC connector.

---

<div class="post-metadata">

**Author:** ![robcam73](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/robcam73/32/1651_2.png) [@robcam73](https://forum.confluent.io/u/robcam73)\
**Post date:** [28 March 2022 08:17 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/7 "2022-03-28T08:17:05Z")

</div>

Hi

No it didn’t contain the JDBC connector, so I installed it using

`confluent-hub install confluentinc/kafka-connect-jdbc:latest`

On the connect container. I then added the JDBC MySql driver jar file into the folder where the JAR for the JDBC connector installed. If I look at my available connectors it appears and lets me add my sink connector.

---

<div class="post-metadata">

**Author:** ![robcam73](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/robcam73/32/1651_2.png) [@robcam73](https://forum.confluent.io/u/robcam73)\
**Post date:** [28 March 2022 08:18 UTC](https://forum.confluent.io/t/jdbc-sink-connector-fails-immediately-with-no-errors-in-log/4585/8 "2022-03-28T08:18:16Z")

</div>

There are a lot of logs, but related to my Cosmos Source connector (which is working correctly). I will try with your Yaml file later and get back to you with full logs if it is still not working.

Thanks