Hi Andrew, Thank you very much for your message. It does not matter what version you ran the code generator with. However, in order to make sure that on 11g you're getting appropriate ROWNUM filtering for .offset() and .limit(), make sure you always use SQLDialect.ORACLE11G in your Configuration. Both SQLDialect.ORACLE and SQLDialect.ORACLE12C will generate the new row_limiting_clause. If you auto-discover the SQLDialect with a 12c JDBC Connection, then it will also be mapped to ORACLE12C.
I hope this helps, Lukas Am Mi., 8. Aug. 2018 um 09:05 Uhr schrieb <[email protected]>: > jOOQ version 3.10.5 > > I developing against an Oracle 12c DB but deploying to an 11g. > > I don't think it matters but the code generation was done against the 12c. > > In my jOOQ query, I have .offset(...) and .limit(...). > > When I run against the 11g DB, jOOQ sometimes generates the proper rownum > format for emulating the offset and limit. > > Sometimes, however, it generates the offset 0 rows fetch next ? rows only > form. > > Is there a way to specify the Oracle version or to specify the form of the > offset/limit generation? > > Thanks > Andrew > > -- > 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.
