How to use mysql compress () / uncompress () with hibernate?

Question

How to use mysql compress () and uncompress () functions to compress text before i save it and unzip it when i extract it using mysql database with sleep mode for ORM?

Answer 1

See ColumnTransformer , IIRC with 3.6:

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

Answer 2

hmm own requests ? But I should not tell you that your application will depend on mysql rdbms then;)

Answer 3

. hibernate. , .