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 [email protected].
For more options, visit https://groups.google.com/d/optout.
