Pure JDBC is always an option, of course. Just to be clear: REF CURSOR types are supported by jOOQ, but they can only be fetched eagerly.
2018-05-16 12:15 GMT+02:00 Rafael Ponte <[email protected]>: > Interesting! > > How to workaround on this? Using pure JDBC instead? > > On Wed, 16 May 2018 at 06:34 Lukas Eder <[email protected]> wrote: > >> Hello, >> >> Unfortunately, this is not yet supported. Routines (stored procedures / >> functions) always execute and fetch results eagerly. >> >> The relevant feature request to support lazy routine execution is here: >> https://github.com/jOOQ/jOOQ/issues/4472 >> >> Thanks, >> Lukas >> >> 2018-05-16 11:29 GMT+02:00 <[email protected]>: >> >>> We are considering the possibility of using jooq. Oracle database is >>> used. If the procedure returns a Ref Cursor type, is it possible to fetch >>> it lazily? >>> The problem is that jooq generates classes with such methods: >>> org.jooq.Result <org.jooq.Record> getPResult () >>> And as the documentation says - "jOOQ's results are simple in-memory >>> Java java.util.List objects" >>> >>> -- >>> 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. >> > -- > Rafael Ponte > TriadWorks | Formação Java > http://cursos.triadworks.com.br > > -- > 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.
