Hi Venkat, That's good news! How did you implement it?
2013/8/6 Venkat Sadasivam <[email protected]> > I can create a new class called StringCrypt and handle the encryption > using converter. > > > On Monday, 22 July 2013 05:09:57 UTC-4, Lukas Eder wrote: > >> I have recently thought of this myself. It would be nice to be able to >> encrypt data centrally through jOOQ. >> >> You can implement this using Converters, indeed. But Converters currently >> have a couple of design drawbacks. Assume a Converter<T, U> where T is the >> database type (e.g. String) and U is the user type (e.g. EncryptedString). >> jOOQ maintains a U -> T type registry with Class<U> keys. This means that >> currently: >> >> - Mappings are global, based on U types. I.e. you can only have a single >> mapping per U type. >> - Mappings are mostly type-based, although column-based mappings can >> override global mappings. But column-based mappings are only available if a >> column from the generated table is used. >> >> What you would probably want is a column-based String -> String mapping. >> This is currently not really possible, as such a String -> String converter >> would: >> >> - Be applied globally, to all String values >> - Be applied in the wrong direction, as it is not clear which String is T >> and which String is U >> >> >> >> >> 2013/7/18 Venkat Sadasivam <[email protected]> >> >>> I want to encrypt a few sensitive data like social security number in >>> database. >>> >>> Does jOOQ supports them? Looks like I can use custom data type (i.e. >>> converter) to do. Can you confirm? >>> >>> Thanks, >>> Venkat >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "jOOQ User Group" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to jooq-user+...@**googlegroups.com. >>> >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
