How do I use mysql compress() / uncompress() with hibernate?

Question

How do I use mysql's compress() and uncompress() functions to compress text before I store it and uncompress it when I retrieve it using a mysql database with hibernate for ORM?

Answer 1

hmm native queries? But i dont have to tell you that your application will depend on a mysql rdbms then ;)

Answer 2

A workaround would be to use stored procedures instead of queries. Stored procedures supported by hibernate. That's likely to get unwieldy, though.