Jasypt Users Forum

How to search on encrypted field if encrypted using fixed salt generator

View: New views
1 Messages — Rating Filter:   Alert me  

How to search on encrypted field if encrypted using fixed salt generator

by shafran :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

hi everyone,

i've seen postings saying that the only way you can search on an encrypted field is if you use a fixed salt generator.  i've configured everything correctly (as far as i can tell) using jayspt and hibernate.  i've confirmed that i can create records with the encrypted field and believe that the fixed salt generator is working because i created multiple records with the same value and the encrypted string value is the same.

my problem is searching via the hibernate query language.  i tried searching on using the unencrypted value and keep getting 0 results.  so my question is, now that i've used the fixed salt generator, what does my hibernate query have to look like in order to search on the encrypted field??

thanks
-s