Hi, I've got a vert.x project where I don't want to use blocking query execution with a standard sql driver but I want still to use Jooq. I'm lookoing for a way to use Jooq in an event-driven manner, so that not only when I fetch a query I pass a callback, but also Jooq does not block when it directly executes a query. There's even an asynchronous database driver project which could be used: https://github.com/mauricio/postgresql-async. Unfortunetaly its interfaces are not compatible with java.sql (ex. Connection, ResultSet etc.).
So far I've managed to create a very simple solution which uses Jooq to build and return SQL query in a string, which I pass to the asynchronous driver to get a result. But there are multiple drawbacks: I can't use jooq fetch methods (ex. fetchInto, fetchMap etc.), I don't see a way to create a Jooq-like result (Result<Record>) so I loose the type safety Jooq provides. Has anyone had a similiar issue and managed to come up with smth? I tried to observe how Jooq executes queries and frankly I don't see a way to make it work without waiting. Is there a simple way to build a jooq-like result with Record, knowing the column names? -- 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.
