Can I use java.sql.Connection?

[KenjiOhtsuka]

Can I use java.sql.Connection to connect the database?

like as follows

val connection = (java.sql.Connection instance)
Database.connect(connection)

[Tapac]

Database.connect({ connection })

[KenjiOhtsuka]

@Tapac Thank you

[andreas-mausch]

I've tried this, but the connection is closed by a transaction.

Debugging led me here:

Exposed/exposed-core/src/main/kotlin/org/jetbrains/exposed/sql/transactions/ThreadLocalTransactionManager.kt

Line 85 in a0e5eb2

if (connectionLazy.isInitialized()) connection.close()

The connection should stay open, the TransactionManager shouldn't close a connection it hasn't established.

[Tapac]

@andreas-mausch it's not expected that you manage connections manually.
What the use-case?

[andreas-mausch]

I experimented with some database migration tools and flyway provides a java.sql.Connection in their context object (see an example here: https://flywaydb.org/getstarted/java). And they expect the migration to not close the connection, which is reasonable.

This is related to #165.

If it's not possible to use the connection they provide, I think I cannot use flyway and will have a look at harmonica.

Edit: I've also tried to use their DataSource to create a new connection, but when I do this I run into locking problems with my sqlite database.