Allow to perform queries outside a db.transaction{ } block about exposed HOT 6 CLOSED

Yes, it's possible with spring-transaction or exposed-spring-boot modules.

from exposed.

Implemented SpringTransactionManager class (subclass of spring DataSourceTransactionManager).
Please look at ExposedTransactionManagerTest.kt for example and feel free to report any problems.

from exposed.

Thanks for adding such support.

I tried to update Geospatial Messenger project but I got a blocking error: IllegalStateException: Already value [org.jetbrains.exposed.sql.Transaction@3672276] for key [org.jetbrains.exposed.spring.SpringTransactionManager@255e5e2] bound to thread [main]. Maybe there is something to fix in SpringTransactionManager. See sdeleuze/geospatial-messenger@transactional

Please also make sure that spring-transaction will be deployed with the right groupId and version since I had to tweak Exposed build.gradle to be able to use org.jetbrains.exposed:spring-transaction:0.5.0-SNAPSHOT dependency.

from exposed.

What about multiplatform?

from exposed.

@dragossusi , how is it related to that issue?

from exposed.

My goal is to be able, potentially with some extensions, to be able to annotate service functions with @transactional and just rely on our regular JDBC based transaction management (more details here).

I thought he wants to use @transactional with exposed methods

from exposed.