This is implemented for jOOQ 3.3. Note that in the mean time, you can also
use plain SQL to work around this missing feature. An example is given in
the Javadoc of DSL.field():
http://www.jooq.org/javadoc/3.2.x/org/jooq/impl/DSL.html#field%28java.lang.String,%20java.lang.Class,%20org.jooq.QueryPart...%29
In your case:
field("GROUP_CONCAT({0})", String.class, argument);
Regards,
Lukas
2014/1/13 Lukas Eder <[email protected]>
> Hello Christian,
>
> You're right, this emulation of MySQL's GROUP_CONCAT should be supported
> by jOOQ. I have registered #2944 for this:
> https://github.com/jOOQ/jOOQ/issues/2944
>
> Cheers
> Lukas
>
>
> 2014/1/13 <[email protected]>
>
> Hello,
>>
>> I am facing problems with using the groupConcat function in jooq with
>> Sqlite.
>> It is translated by jooq into the 'listagg' SQL function which is not
>> available in Sqlite, therefore the query fails. However the group_concat
>> function is available in Sqlite so jooq should use this function instead.
>>
>> Thanks and best regards
>>
>> Christian
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "jOOQ User Group" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
