I see, I wasn't aware of other databases shipping with similar functions. Let's pull this method up to Factory, then: https://github.com/jOOQ/jOOQ/issues/1972
So, Oracle has some MD5 function: LOWER(RAWTOHEX(SYS.DBMS_OBFUSCATION_TOOLKIT.MD5(input_string=>'mypass'))) How would you generically go about this for HSQLDB (without creating a UDF, of course)? 2012/11/21 Ben Hood <[email protected]>: > Actually I was hoping for Oracle, MySQL and HSQL support :-) > > So the MySQLFactory looks like a good solution for MySQL, but I guess that I > going to have to look at a way of executing the native queries on a dialect > by dialect basis. Is this something that could be patched into the default > Factory and implemented separately for each DB you want to support? > > > > On Wed, Nov 21, 2012 at 2:04 PM, Lukas Eder <[email protected]> wrote: >> >> I'm guessing that this is about MySQL? Have a look at MySQLFactory, then: >> http://www.jooq.org/javadoc/latest/org/jooq/util/mysql/MySQLFactory.html >> >> http://www.jooq.org/javadoc/latest/org/jooq/util/mysql/MySQLFactory.html#md5(org.jooq.Field) >> >> Cheers >> Lukas >> >> 2012/11/21 Ben Hood <[email protected]>: >> > Hi, >> > >> > I was wondering whether there is a factory method to call an MD5() >> > string >> > function in a query. Natively I was thinking of the following SQL: >> > >> > select year(some_date), md5(group_concat(some_column)) >> > from some_table >> > group by year(some_date) >> > >> > The generic Factory class offers functions to generate year() and >> > group_concat(), but I couldn't see one for md5(). >> > >> > How should I proceed? >> > >> > TIA, >> > >> > Cheers, >> > >> > Ben > >
