Folks, While ResultQuery::fetchResultSet is a workaround for the time being (don't forget to close the ResultSet with try-with-resources!), it obviously bypasses a lot of useful jOOQ features by exposing the JDBC ResultSet directly.
In the future, we'll address this issue, which isn't strictly an issue about being able to read primitive types from the ResultSet, but to be able to bypass the intermediate org.jooq.Record type in the mapping, which is basically a wrapper for an Object[], another reason why wrapper types are necessary in jOOQ apart from reflection. Once this intermediate type is bypassable, then reflection won't be the limiting factor anymore either. An interesting feature that will not contribute to making this a trivial change is that currently, all fetch() operations pass by the RecordListener SPI, which would also have to be bypassed. Relevant feature requests are: - https://github.com/jOOQ/jOOQ/issues/6544 Optimise fetchXYZ() operations by allowing to bypass the RecordListener - https://github.com/jOOQ/jOOQ/issues/6737 Add Settings.fetchIntermediateRecords I hope this helps, Lukas On Tue, Jan 7, 2020 at 1:56 PM <[email protected]> wrote: > Hi Knut, > > thank you very much for the detailed answer. > your assumption is correct. > You gave some usefull tips that we will process now. In the end > ResultQuery#fetchResultSet() > is what i was looking for. > > bye, Andi. > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/00aa8fa4-bfa2-481d-9c0b-1a579b1712d3%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/00aa8fa4-bfa2-481d-9c0b-1a579b1712d3%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO71Th7YO0%2BaX%2B%3DfeKiRwgctee2ioCLP9fH8xZjcRQzEdA%40mail.gmail.com.
