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 >
