Does jOOQ work with a @Transactional annotation in a SpringBoot application?

[littlebytesof]

When I try the jOOQ insertInto with a transactional annotation, it doesn't seem to roll back with an error.

Additionally, when I save an entity with a JPA repository (calling its save and flush method) and try to retrieve the created record with the jOOQ select under a transactional, it only yields a null value (while the record is successfully returned when when done without a transactional). I guess this is perhaps due to the JPA repository transaction not being shared by the jOOQ context.

Does jOOQ work under a transactional annotation? And if so, is there any configurations to be set?
(I could find a relevant Stack Overflow thread that mentions on implementing a TransactionProvider)

The jOOQ version I used is 3.18.7, and SpringBoot 3.1.4.

[littlebytesof]

The problem has been solved. It seems that I should have used TransactionAwareDataSourceProxy for the jOOQ's connection provider in the configurations.