Database transactions logging

[OleKsimov]

Hi guys!
Is there a way to track down actual DB transactions? I would like to log somehow the beginning and the end of a specific transaction and investigate the behavior.
hibernate-orm.log.sql=true doesn't show this type of operations

[famod]

Have you tried setting the log level like described here?
https://stackoverflow.com/questions/30576385/how-to-log-the-start-and-the-completion-of-db-transactions-in-hibernate

[OleKsimov]

Yes, I've tried setting the next properties:

quarkus.log.category."org.hibernate".level=DEBUG
quarkus.hibernate-orm.statistics=true
quarkus.hibernate-orm.log-session-metrics=true
quarkus.hibernate-orm.metrics.enabled=true

But non of them show the information about transactions. I use slf4j logger btw

[famod]

quarkus.log.category."org.hibernate.engine.transaction.internal.TransactionImpl".level=DEBUG

Prints some (more or less useful) transaction infos for me:

2022-02-09 21:43:57,613 DEBUG [org.hib.eng.tra.int.TransactionImpl] (main) TransactionImpl created on closed Session/EntityManager
2022-02-09 21:43:57,614 DEBUG [org.hib.eng.tra.int.TransactionImpl] (main) On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
2022-02-09 21:43:57,614 DEBUG [org.hib.eng.tra.int.TransactionImpl] (main) TransactionImpl created on closed Session/EntityManager
2022-02-09 21:43:57,614 DEBUG [org.hib.eng.tra.int.TransactionImpl] (main) On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
2022-02-09 21:43:57,615 DEBUG [org.hib.eng.tra.int.TransactionImpl] (main) TransactionImpl created on closed Session/EntityManager
2022-02-09 21:43:57,615 DEBUG [org.hib.eng.tra.int.TransactionImpl] (main) On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false