Hopefully this is another simple question:

I have a column in a pre-existing database that is storing an encrypted password. Built into the database is a procedure/function that decrypts this password for me on retrieval.

This is an oracle database.

The normal sql for this is:

select passwordDecrypt(password) from PasswordTable;

passwordDecrypt being the procedure/function and password is the column name.

Is there any way to map this into hibernate easily? I thought about using my own UserType but then I would have to duplicate the decrypt procedure in java code which I would like to avoid.

Any useful suggestions would be appreciated.

if you don't have to update this column, use formula tag in the mapping file

Perfect! Thank you.