I need to get the underlying java.sql.Connection from Vert.x's SQLConnection

Question

I'm using vert.x's JDBCClient to get my database connections and it only gives me io.vertx.ext.sql.SQLConnection or io.vertx.reactivex.ext.sql.SQLConnection and none of them extends java.sql.Connection.

In order to call Liquibase from a verticle I need a java.sql.Connection.

I know that Vert.x uses C3Po on behind but I was not able to find any method that could give me the underlying connection.

How can I achieve that ?

score 4 · Accepted Answer · edited Jun 20 '20 at 09:12

4

If you're on a recent version, SQLConnection has an unwrap method. As indicated in the docs:

default <N> N unwrap()

Return the underlying Connection object if available. This is not mandated to be implemented by the clients.

The JDBCClient should return a java.sql.Connection. Don't forget to call close on the original SQLConnection after usage.

edited Jun 20 '20 at 09:12

Community

1
1

answered Apr 05 '18 at 07:43

tsegismont

8,591
1
17
27

score -1 · Answer 2 · answered Apr 04 '18 at 13:08

-1

Have you tried with:

final JDBCClient dbClient = JDBCClient.createShared(vertx, new JsonObject()
            .put("url", dbUrl)
            .put("user", user)
            .put("password", pass)
            .put("driver_class", "you.driver")
            .put("max_pool_size", 30)
    );

answered Apr 04 '18 at 13:08

Nikolay Petkov

41
1
6

1

sure, the vert.x jdbc API only returns io.vertx.ext.sql.SQLConnection that do not extends java.sql.Connection – Cristiano Apr 04 '18 at 14:41
But why do you need java.sql.Connection ? It is blocking. – Nikolay Petkov Apr 04 '18 at 15:12
1

As he mentioned in the question, Liquibase requires a `java.sql.Connection` – SteveDonie Apr 04 '18 at 15:22

I need to get the underlying java.sql.Connection from Vert.x's SQLConnection

2 Answers2

Linked