Hi Aram,
We haven't switched from using ` to " in MySQL. What are you calling
toSql() on? Are you sure that object is configured with your settings?
Cheers,
Lukas
2018-03-15 12:09 GMT+01:00 Aram Mirzadeh <aram...@gmail.com>:
>
> Hi,
>
> This is using jOOQ 3.10.5, Java 8 in eclipse.
>
> It's been a great while since I have had to use toSql to diagnose a
> jOOQ rendering issue so this may be a moot question if it was done
> intentionally. And it makes no real difference it isn't a valid MySQL
> command unless you have ANSIQUOTES set in your mysql startup which isn't
> recommended (I'm sort of guessing at that one since I remember reading it
> but now I cannot find the original source).
>
> I'm using this on my test bench:
>
> private static DSLContext db(Connection connection) {
> return DSL.using(connection, SQLDialect.MYSQL, getSettings());
> }
>
> private static Settings getSettings() {
> return new Settings().withRenderSchema(Boolean.TRUE)
> .withRenderNameStyle(RenderNameStyle.UPPER)
> .withRenderKeywordStyle(
> RenderKeywordStyle.UPPER)
> .withRenderFormatted(Boolean.TRUE)
> .withParamType(ParamType.NAMED)
> .withStatementType(StatementType.PREPARED_
> STATEMENT)
> .withExecuteLogging(Boolean.TRUE)
> .withFetchWarnings(Boolean.TRUE)
> .withUpdatablePrimaryKeys(Boolean.FALSE);
> }
>
> .toSql() is using ANSI quotes (") rather than (`)?
>
>
> --
> 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+unsubscr...@googlegroups.com.
> 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 jooq-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
