Heya,

Does anyone know how you might update an encrypted filed using hibernate in a MySQL database. The old query used to be

UPDATE User SET password = AES_ENCRYPT('pass', 'key') where user_id = 1;

Ive had a good look for this around but found nothing so far!

Thanks.

I actually don't think there is a way to do it with hibernate, but one way to do it would be to encrypt the data in Java, then store it in the DB. You might find this link helpful:

http://java.sun.com/developer/technicalArticles/Security/AES/AES_v1.html

Thanks for that and I had a good look at it but it doesn’t do really what i need it to do. I need to somehow set the private key value, not just use a generated key, so im also able to decrypt the String once its returned from the database.

So the private Key value in the example above is 'key'. I looked at the API for all the associating objects, but couldn’t see how this would be set. Any ideas?

Thanks.