Use @Transactional properly in test methods

[danielpetisme]

Is your feature request related to a problem? Please describe. When a test is annotated @Transactional the data is not commited into the DB thus not visible in the application under test.

Describe the solution you'd like The objective is to use @Transactional smoothly without any hacks.

Describe alternatives you've considered The current solution is to manually manage the transaction

Additional context https://github.com/quarkusio/quarkus/issues/6536