Monitoring DB: MySQL

Question

Hi, I am writing to ask for advice. I have to monitor certain "insert" on a mysql db. In what way is more convenient to do this? The application uses Servlets and MySQL. Thank you very much

Answer 1

Depends on the persistence framework you're using.

• If it's Hibernate, you need to implement an Interceptor and hook on onSave().
• If it's JPA, you need to use an entity method with the @PrePersist or @PostPersist annotation.
• If it's plain vanilla JDBC, just add the code to the boilerplated DAO method.

This is unrelated to servlets. The servlet is just an API for intercepting on HTTP requests. Your data access layer should be independent and transparent from that.