Oracle Ref Cursor Fetched Lazily

[workho...@gmail.com]

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"

[Lukas Eder]

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

--
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 jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Rafael Ponte]

Interesting!

How to workaround on this? Using pure JDBC instead?

To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.

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 jooq-user+...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Rafael Ponte

TriadWorks | Formação Java
http://cursos.triadworks.com.br

[Lukas Eder]

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 <rpo...@gmail.com>:

Interesting!

How to workaround on this? Using pure JDBC instead?

On Wed, 16 May 2018 at 06:34 Lukas Eder <lukas...@gmail.com> 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 <workho...@gmail.com>:

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 jooq-user+unsubscribe@googlegroups.com.

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 jooq-user+unsubscribe@googlegroups.com.

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 jooq-user+unsubscribe@googlegroups.com.