# JDBC Sink Connector ConnectException - Table "schema"."table" is missing and auto-creation is disabled for oracle

**URL:** <https://forum.confluent.io/t/jdbc-sink-connector-connectexception-table-schema-table-is-missing-and-auto-creation-is-disabled-for-oracle/7454>\
**Category:** Kafka Connect\
**Created:** [20 March 2023 13:32 UTC](https://forum.confluent.io/t/jdbc-sink-connector-connectexception-table-schema-table-is-missing-and-auto-creation-is-disabled-for-oracle/7454 "2023-03-20T13:32:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SandipGawale](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/sandipgawale/32/2812_2.png) [@SandipGawale](https://forum.confluent.io/u/SandipGawale)\
**Post date:** [20 March 2023 13:32 UTC](https://forum.confluent.io/t/jdbc-sink-connector-connectexception-table-schema-table-is-missing-and-auto-creation-is-disabled-for-oracle/7454/1 "2023-03-20T13:32:31Z")

</div>

I am trying to sink data from kafka topic “kafka2. **INVENTORY**.PRODUCT” to table “product\_target” under different schema having schema name “ **tinventory** ” with Oracle DB. This sink I am trying with the DB connection user “jdbcsinkuser”.

Doing this I am getting error as

```auto
ERROR [sink-to-target|task-0] WorkerSinkTask{id=sink-to-target-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted. Error: Table "tinventory"."PRODUCT_TARGET" is missing and auto-creation is disabled (org.apache.kafka.connect.runtime.WorkerSinkTask:609)
org.apache.kafka.connect.errors.ConnectException: Table "tinventory"."PRODUCT_TARGET" is missing and auto-creation is disabled

```

```auto
{
    "name": "sink-to-target",
    "config": {
        "connector.class": "io.confluent.connect.jdbc.JdbcSinkConnector",
        "tasks.max": "1",
        "topics": "kafka2.INVENTORY.PRODUCT",
        "table.name.format": "PRODUCT_TARGET",
        "connection.url": "jdbc:oracle:thin:@localhost:1521/orclpdb1",
        "connection.user": "jdbcsinkuser",
        "connection.password": "jdbc",
        "transforms": "unwrap,InsertField",
        "transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState",
        "pk.fields": "PRODUCTID",
        "insert.mode":"upsert",
        "delete.enabled":true,
        "delete.retention.ms":100,
        "pk.mode": "record_key",
        "transforms.InsertField.type": "org.apache.kafka.connect.transforms.InsertField$Value",
        "transforms.InsertField.static.field": "SOURCE",
        "transforms.InsertField.static.value": "LEGACY-SYS"
    }
}

```

---

<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:** [19 April 2023 13:33 UTC](https://forum.confluent.io/t/jdbc-sink-connector-connectexception-table-schema-table-is-missing-and-auto-creation-is-disabled-for-oracle/7454/2 "2023-04-19T13:33:25Z")

</div>

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