Hi, I use jooq only as SQL builder. However I run into trouble with generation of valid SQL queries with TEIID dialect (not supported by jooq). *It requires limit clause in format "LIMIT 10,20" instead of "LIMIT 10 OFFSET 20".* This format is supported by CUBRID but I cannot switch whole sql generator into CUBRID syntax.
Is it possible to use different dialects for select/where and different one for limit clause for example? Or is it possible to customize my own dialect with overwritten org.jooq.impl.Limit#accept method? I really do not want to use regexp to "fix" result of jooq's getSQL() string result. What is preferable way to achieve my goal? Thanks for any ideas! Best regards, 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/d/optout.
