when i call this code, i get an `IllegalStateException: No transaction in context`. anyone know what...

# exposed

[John Pena]

when i call this code, i get an IllegalStateException: No transaction in context. anyone know what i’m doing wrong here?

val breakdownDimensions = transaction {
                Dimension.find {
                    Dimensions.id inList breakdownIds
                }
            }

            for (dimension in breakdownDimensions) {
                println(dimension.id)
            }

[Endre Deak]

did you wrap this into transaction { }?

[John Pena]

there’s a transaction in the code i posted

[John Pena]

i’m not entirely clear on what the issue was, but wrapping all of the code that uses my database types in a transaction did fix my problem

[Endre Deak]

yeah in order to be able to use them, you must be inside a transaction

[Joel]

@John Pena I believe Dimension.find returns a SizedIterable which hasn't actually queried yet. The reason is that you could be asking for count, or existence, something that doesn't require the query to be completed in full. The query is actually occurring when you access the iterator using dimension in breakdownDimensions . The fix would be to use:

Dimension.find { Dimensions.id inList breakdownIds }.toList()

[John Pena]

helpful, thanks @Joel!