Hello,

Im very new to Hibernate. I have a backend MySQL Database which uses AES_ENCRYPT and AES_DECRYPT for certian fields. Does hibernate allow for you to get these encrypted fields returned? And if so, whats needed to be done.?

Thanks,
DM.

You can try to use SQL replaces constructions to replace some parts of SQL before it gone to server. So one can translate:

SELECT a.id, a.name FROM table a WHERE a.id=1
to
SELECT a.id, a.name FROM (SELECT b.id id, AES_DECRYPT(b.name, ...) name FROM table b) a WHERE a.id=1

You could also create a custom UserType that did the encryption/decryption.

http://www.hibernate.org/hib_docs/v3/ap ... rType.html

Chris....

Hey Guys,

Thanks for the replies. I think i am going to try and create Customer tags for required fields

Hi,

I was able to call the the MYSQL aes_encrypt function for encryption in the <sql-insert> and <sql-update>

http://www.hibernate.org/hib_docs/v3/re ... rysql.html

for decryption i used the aes_decrypt function in the formula tag of the property element.

When i included the formula on the properties element, the <sql-insert> and <sql-update> queries are not called.

It is like either one works, but not both.

Has anybody come across this.

Any help will be greatly appreciated.

Thanks
chandrika