Hi Marcus,
You cannot inline an array list. You have to inline each individual value.
In terms of streams:
List<Integer> ids = ...
MY_TABLE.ID.in(
ids.stream()
.map(DSL::inline)
.toArray(new Field[0]));
Hope this helps,
Lukas
2017-03-09 8:29 GMT+01:00 Marcus Gattinger <[email protected]>:
> Lukas,
>
> after using DSL.inline() as you proposed, I receive the following
> exeception:
> Exception in thread "main" org.jooq.exception.
> SQLDialectNotSupportedException: Type class java.util.ArrayList is not
> supported in dialect DEFAULT
> at org.jooq.impl.DefaultDataType.getDataType(DefaultDataType.java:820)
> at org.jooq.impl.DefaultDataType.getDataType(DefaultDataType.java:764)
> at org.jooq.impl.DSL.getDataType(DSL.java:18663)
> at org.jooq.impl.DSL.val(DSL.java:16502)
> at org.jooq.impl.DSL.inline(DSL.java:15735)
>
> I create the DSLContext like this:
>
> DSL.using(DataSource.get(), SQLDialect.SQLSERVER2014)
>
> What am I missing here?
>
> Cheers,
> Marcus
>
> --
> 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/d/optout.
>
--
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/d/optout.
