Does jooq offer a class similar with DataTable in C# to load data from ad-hoc queries?

Question

Does jooq support running ad-hoc queries? I was wondering if it provides a data structure, similar with the C# DataTable (or the java CachedRowSet) where I can store the data from a query and which would support the different RDBMSes features such as Oracle cursor columns.

Thanks

Answer 1

Does jooq support running ad-hoc queries?

Yes. Most of jOOQ is about running ad-hoc queries.

I was wondering if it provides a data structure, similar with the C# DataTable (or the java CachedRowSet) where I can store the data from a query and which would support the different RDBMSes features such as Oracle cursor columns comes to mind.

No, that's currently not supported but if I understand you correctly, it is on the roadmap:

• https://github.com/jOOQ/jOOQ/issues/1846