INSERT LOW_PRIORITY or INSERT DELAYED in Hibernate

Question

How do I do a low_priority or delayed insert into a MySQL table with Hibernate?

In my logging routine I want to insert the log info to a table in my database for further analysis. But I don't care about how long it takes for the insert to be done, so usually I would say INSERT LOW_PRIORITY INTO LogEntry (level, title, full) VALUES ('Info', 'Title here', 'Full log'); If I have an entity LogEntry, how do I write or wire up my LogEntryDAO to do LOW_PRIORITY or DELAYED inserts and updates?

Cheers

Nik

Answer 1

There is a much simpler solution.

Annotate my entity class with @SQLInsert(sql="INSERT LOW_PRIORITY INTO LogEntry (level, title, full) VALUES (?, ?,?)")

Nice and elegant :-)

Answer 2

Use an org.hibernate.Interceptor. It will get a copy of the SQL to execute to modify.

See the docs for details.