group_concat in Sqlite with jooq

[spiel.c...@gmail.com]

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

[Lukas Eder]

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 <spiel.c...@gmail.com>

--
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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Lukas Eder]

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 <lukas...@gmail.com>

[alber...@gmail.com]

I don't think this works with SQLite on jooq 3.13.1 . I get a syntax error on "order" when I use listAgg.

On Monday, January 13, 2014 at 6:05:11 AM UTC-5, Lukas Eder wrote:

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 <luka...@gmail.com>

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 <spiel.c...@gmail.com>

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 jooq...@googlegroups.com.

[Lukas Eder]

Can you please open an issue with some more details on how to reproduce this?

https://github.com/jOOQ/jOOQ/issues/new/choose 

Thanks,

Lukas 

To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/3ff42e8c-c9d1-456b-b77e-44a6ccf5ddda%40googlegroups.com.