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