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. > >
