Allow to perform queries outside a db.transaction{ } block

[sdeleuze]

In geospatial-messenger, I am currently forced to use db.transaction { } (see MessageRepository).

It would be nice if Exposed could make it possible to support existing transaction management system like the one provided by Spring (see this documentation and DataSourceTransactionManager Javadoc).

Exposed could maybe allow to set the default db to use at Table level, delegate the transaction management to any kind of other mechanism and allow to perform queries with Table.foo() functions without a wrapping them into a db.transaction{ } block.

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).

[Tapac]

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

[sdeleuze]

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.

[dragossusi]

What about multiplatform?

[Tapac]

@dragossusi , how is it related to that issue?

[dragossusi]

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

[Tapac]

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