Very cool! Thanks a lot for putting the effort into this one. Would the factory also generate a md5() function for HSQL (assuming that you've tweaked your HSQL with a function called md5 that takes a varchar)?
Also, and only FWIW, I've noticed with Oracle that dbms_obfuscation_toolkit has a 32K varchar input limit, where dbms_crypto can operate on lobs. On Fri, Nov 23, 2012 at 12:17 PM, Lukas Eder <[email protected]> wrote: > MD5 function support is now simulated for Oracle/MySQL. This is now > committed to GitHub: > https://github.com/jOOQ/jOOQ/issues/1972 > > Cheers > Lukas > > 2012/11/21 Ben Hood <[email protected]>: > > Thanks a lot for the heads up about the HSQL library to generate a digest > > and how to implement a CustomField - I'll check it out. > > > > (And as ever, thanks for responding so quickly :-) > > > > > > On Wed, Nov 21, 2012 at 2:39 PM, Lukas Eder <[email protected]> > wrote: > >> > >> >> How would you generically go about this for HSQLDB (without creating > a > >> >> UDF, of course)? > >> > > >> > Very good point - I was just going to resort to creating a UDF to call > >> > out > >> > to Apache Commons DigestUtils ...... > >> > >> Well, I found this answer by Fred Toussi, the HSQLDB developer, here: > >> http://stackoverflow.com/a/10777312/521799 > >> > >> Of course, such a solution is not viable for jOOQ's core. So if you > >> want this to work for HSQLDB as well, you'll have to provide your own > >> abstraction. A good way to do this is by implementing a CustomField: > >> > >> > http://www.jooq.org/doc/2.6/manual/sql-building/queryparts/custom-queryparts/ > >> > >> You then have full control over its SQL rendering and variable > >> binding, depending on the context's SQLDialect. > > > > >
