Hello, 2013/8/14 <[email protected]>
> Hello, > > I wrote a question about this on stackoverflow: > http://stackoverflow.com/questions/18223648/jooq-sql-generation-for-where-in-quotation-seems-inconsistent-for-multiple-objec. > The question has been answered here: http://stackoverflow.com/a/18247615/521799 In essence, remember that jOOQ will generate all SQL and SQL clauses for you. There is no point in providing jOOQ with comma-separated value lists for the IN-predicate, as jOOQ will render all syntax elements, such as quotes or commas. moreover, is it possible to generate the code without adding any quotes? > Yes, by default, jOOQ renders quotes to produce case-sensitive identifiers. This behaviour can be overridden, again, through the Settings object. In your case, RenderNameStyle is the relevant property (probably RenderNameStyle.AS_IS). Consider this XSD for all your Settings options: http://www.jooq.org/xsd/jooq-runtime-3.1.0.xsd > I have noticed that using DSL.fieldByName always generates names in " " > and DSL.field does not, but then I cannot add the schema by doing > ("Schema", "rowName"). > org.jooq.Name objects (produced by DSL.fieldByName) are always quoted by default. Plain SQL fields (as produced by DSL.field) are considered "plain SQL", i.e. they can contain syntax elements, names, parentheses, etc. Thus, no quoting by default. Hope this helps Lukas -- 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.
