```Database.connect(datasource = HikariDataSource(poolConfig), manager = { ThreadLocalTr...

# exposed

[bitkid]

Database.connect(datasource = HikariDataSource(poolConfig),
            manager = { ThreadLocalTransactionManager(it, Connection.TRANSACTION_REPEATABLE_READ, 0) })

[bitkid]

what i am doing (which i have no idea if it's sane) is the follwing. i have a small helper method which moves the transaction the IO Dispatcher

[bitkid]

suspend fun <T> dbTransaction(database: Database, block: () -> T): TransactionResult<T> =
    suspendedTransactionAsync(<http://Dispatchers.IO|Dispatchers.IO>, database, false) {
        block()
    }

[bitkid]

and in my route handlers look like this

[bitkid]

fun Route.logIn(database: Database, sessionHandler: SessionHandler) {
    post<Login> {
        val response = dbTransaction(database) {
            sessionHandler.login(data)
        }.await()
        call.respond(response)
    }
}

[bitkid]

so i can either wait for the db stuff to return with await() or i don't (fire and forget)

[bitkid]

i am wondering if it actually makes sense to use Dispatchers.IO .. as it will most probably use the current thread from DefaultDispatcher

[bitkid]

@tapac this is how i am using it now with ktor

[bitkid]

btw my code fails when i pass true to suspendedTransactionAsync .. with a connection closed exception

[tapac]

@bitkid Could you please share a little sample which I could run to test your case?