Hey guys. I am looking for some best practices / t...

# ktor

[Dennis Schröder]

Hey guys. I am looking for some best practices / tuts ,/ etc. for Ktor in combination with Kotlin exposed especially about using transactions in coroutines! Would appreciate any suggestions.

[Robert Jaros]

Take a look: https://ryanharrison.co.uk/2018/04/14/kotlin-ktor-exposed-starter.html

[Dennis Schröder]

Yeah I already stumbled across this one! My problem is that when I use withContext() { transaction{}} I get an no transaction context found error when working with the DAO and many to many relations.

[Robert Jaros]

Unfortunately I haven't used Exposed with this types of relations. Only very simple foreign keys.

[Dico]

Exposed does not support coroutines. The reasoning is that it wraps jdbc which is a blocking api. It intends to add coroutine support though.
For the time being, your best bet is not to change thread in the context of a transaction.