Hi all, I’m trying to return values as described in the wiki ( https://github.com/JetBrains/Exposed/wiki/Transactions#accessing-returned-values ), but I’m having trouble The following code successfully prints 10 rows:

transaction(Connection.TRANSACTION_SERIALIZABLE, 1) {
    Message
        .slice(Message.text)
        .selectAll()
        .limit(10)
        .forEach { println(it) }
}

But when I try to return the rows and use them outside of the transaction, it doesn’t seem to work:

val messages = transaction(Connection.TRANSACTION_SERIALIZABLE, 1) {
    Message
        .slice(Message.text)
        .selectAll()
        .limit(10)
        .toList()
}

messages.forEach { println(it) }

I’m getting

java.lang.IllegalStateException: No transaction in context

. When I set a breakpoint after the transaction,

messages

has length 10, but trying to access any elements throws an exception. I’m pretty new to this and wasn’t able to find anything by googling. Could someone help me figure out what I have wrong?

You problem is into

text

(along with

blob

) field as whose kind of fields don't loaded eager (to not consume whole available memory) and that's why they are require transaction to be loaded. In your case it could be fixed by:

Message
        .slice(Message.text)
        .selectAll()
        .limit(10)
        .map { it[Message.text] }

That works, thank you very much!