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

See the ColumnTransformer, IIRC since 3.6:

@Column(name = "data", columnDefinition = "BLOB", nullable = false)
@ColumnTransformer(read = "UNCOMPRESS(data)", write = "COMPRESS(?)")
@Lob
public byte[] getData()
{
    return theData;
}

Answer 2

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

Answer 3

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