# Lenses sink postgresql - "No suitable driver found" error

**URL:** <https://ask.lenses.io/t/lenses-sink-postgresql-no-suitable-driver-found-error/54>\
**Category:** Apache Kafka Connectors\
**Created:** [May 1, 2023, 9:07pm UTC](https://ask.lenses.io/t/lenses-sink-postgresql-no-suitable-driver-found-error/54 "2023-05-01T21:07:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![blanpa](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/blanpa/32/48_2.png) [@blanpa](https://ask.lenses.io/u/blanpa)\
**Post date:** [May 1, 2023, 9:07pm UTC](https://ask.lenses.io/t/lenses-sink-postgresql-no-suitable-driver-found-error/54/1 "2023-05-01T21:07:11Z")

</div>

Hi all,

I try to create a postgresql(timescaldb) sink with the JDBC Connector. But i only get an error message:

`Caused by: org.apache.kafka.connect.errors.ConnectException: java.sql.SQLException: No suitable driver found`

I use the Lenses Box. Is this possible? Is there any good description?

---

<div class="post-metadata">

**Author:** ![andrewstevenson](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/andrewstevenson/32/15_2.png) [@andrewstevenson](https://ask.lenses.io/u/andrewstevenson)\
**Post date:** [May 2, 2023, 8:40am UTC](https://ask.lenses.io/t/lenses-sink-postgresql-no-suitable-driver-found-error/54/2 "2023-05-02T08:40:47Z")

</div>

@blanpa The timescaledb jdbc driver will need to be added to the classpath of the Connect workers inside of the Lenses Box. You will need to mount it in the `/connectors` folder.

For example:

```auto
docker run --rm -it --net=host \
           -v my-jdbc-driver.jar:/connectors/my-jdbc-driver.jar \
           lensesio/box

```

---

<div class="post-metadata">

**Author:** ![Marios](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/marios/32/8_2.png) [@Marios](https://ask.lenses.io/u/Marios)\
**Post date:** [May 5, 2023, 8:44am UTC](https://ask.lenses.io/t/lenses-sink-postgresql-no-suitable-driver-found-error/54/3 "2023-05-05T08:44:55Z")

</div>

Hello blanpa! In Lenses Box, we include the PostgreSQL JDBC driver to both the Confluent JDBC and Debezium Postgres connectors. For Confluent JDBC the driver currently is at version 42.3.3, for Debezium Postgres the driver is at version 42.4.1.

So your error seems a little funny. If you can share your connector configuration we might be able to deduct why it isn’t working.

In any case, if you need to add a custom JDBC driver to Box, you have to add them to each connector’s directory. This happens because Kafka Connect uses classpath isolation for connectors.

As an example, if you have `my-jdbc.jar` and want to add it to both Confluent JDBC and Debezium Postgres:

```auto
docker run ... \
  -v /path/to/my-jdbc.jar:/opt/landoop/connectors/third-party/kafka-connect-jdbc/my-jdbc.jar \
  -v /path/to/my-jdbc.jar:/opt/landoop/connectors/third-party/kafka-connect-debezium-postgres/my-jdbc.jar \
  ... lensesio/box

```