CODEWITHSUNDEEP
javaspring-bootjooqaudit
Heril Muratovic
Heril Muratovic

Reputation: 2028

Spring Boot and JOOQ Auditing Solutions

does anybody has an idea how to do auditing with Spring Boot and JOOQ (Java Object Oriented Queries)?

I don't want custom audit, because I already have an idea how to do that. Does JOOQ has out of the box auditing engine like Hibernate / JPA (Envers)?

Thank you in advance!

Upvotes: 3

Views: 2544

Answers (1)

Lukas Eder
Lukas Eder

Reputation: 221106

As mentioned in the comments, that feature is on the roadmap: https://github.com/jOOQ/jOOQ/issues/1592

It is currently not a priority because jOOQ favours SQL-based solutions, and auditing is a lot more thoroughly solved through triggers than through any client-based approach, as triggers cannot be bypassed. Hibernate Envers can easily be bypassed through Hibernate API itself, e.g. when using JPQL bulk updates, or the native SQL API. A jOOQ based solution would be the same, it can easily be bypassed (more easily than in JPA, because jOOQ encourages using SQL).

Again, this may be fine for some setups, but it certainly means it's not a priority.

Upvotes: 5

Related Questions