What design (or pattern) is best for fields that are to be encrypted?
MySQL has quite a few simple functions that can be used to encrypt data. However, when using Cayenne to fetch the data I have not found a simple solution.
I have been testing using result directives and SQLTemplate, but the design is looking pretty messy.
I guess the first question is: can I rely on MySQL aes_encrypt()/ aes_decrypt() while using Cayenne or will I have to go to a java encryption class?
Thanks, Joe
