Hibernate version: 2.1.2

Is there a way to specify a formula for writing data? I realize the formula attribute of a property can be used for "computed" properties, but what about computing the value that will be inserted?

A specific (and I think common) use case would be encrypting/decrypting functions.

On read, I would like to use the db function decrypt(dbvalue).

On write, I would like to use the db function encrypt(javavalue).

So that ultimately: the java object only ever contains unencrypted values, and the db only ever contains encrypted values.

I think I can get around this using 2 properties (1 mapped as formula, and 1 mapped as a "normal" property; the written unencrypted value will updated using a separate db call during flush via interceptor), but it is far from elegant.

A user type could also work, but similarly there would need to be a extra db call for each read, and for each write.

Thanks for any advice!
Tyson

if you use the "property" based persistence scheme Hibernate, Hibernate core is going to call your getXXXX and setXXX() while retrieving or saving your data. Can't you put the logic for encryption or decryption there?

-Anand

Storing the encryption logic in the java code would be my preference, but circumstances govern that the encryption logic be stored within the database. (i.e. other applications access the same data, using only stored procedures and other db-centric code...)

I need to do the exact same thing as this user. Does v3 provide a way to do it?

Thanks,
Max

I need to be able to use Hibernate with SQLServer2005 encryption, as opposed to something like Jasypt which does the encryption within the java web server.

It looks like you could load data from the database using the formula property but there is no obvious way to do the inserts and updates.

I see from this post I am not alone. Is there a decent solution for this?