I've been using Jasypt(.org) 1.4 for encrypting/decrypting at the app level rather than a database dependent solution. It's pretty easy to use. My only gripe is it's abnormally large, due to its dependence on icu4j. Although, they have made that jar optional w/ the newer version coupled w/ Java 6.
-Chad ----- Original Message ----- From: "Joe Baldwin" <[email protected]> To: [email protected] Sent: Thursday, February 5, 2009 3:36:40 PM GMT -07:00 US/Canada Mountain Subject: Encrypted Fields 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
