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