ERROR Connection not open CLOSED when composing Futures using vertx-jooq-classic-reactive: 5.0.1

[Nikola Stevanović]

I have an issue when multiple Futures are being composed in order to perform update Book table and insert/delete certain rows in intermediate tables _Category_Book_ and _Author_Book_ since Book is connected with Many-To-Many relationship with Author and Category. Error message that I get in console is:

ERROR com.ns.vertx.pg.BookJooqQueries - Error, something failed in deleteCategoryBookFuture.compose(..)! Cause: io.vertx.core.VertxException: Connection not open CLOSED

Also, I am using mixture of DAO instances and execute() method on instance of ReactiveClassicGenericQueryExecutor class. This is repo link to my class where I am getting this error and this is HttpVerticle where routes, DAOs and other configuration is taking place for my RESTful web services.

I don't know if there is a possibility that I've "over-composed" Future instances and that's what's causing this error, but as I understood composition is used when certain operations (Insert/Delete/Update) need to be performed in sequential order and all have to succeeded.

Libraries I am using:
Vert.x version: 3.8.2
vertx-jooq-classic-reactive: 5.0.1
postgre-sql: 42.2.2 (Postgre DB is version 11.7 on my machine)

NOTE: I have these changes made in my book_CRUD branch, not to be mistaken with master (as I don't want to merge these not fully functional changes).

[Lukas Eder]

Thanks for your message. I see you've asked it also on Stack Overflow:

https://stackoverflow.com/q/61454777/521799

We currently do not offer support for this third party software (vertx-jooq), so I'm not sure what the reason for any issue could be.

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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/f7a974e2-6d7e-466c-9154-757985a1b330%40googlegroups.com.

[Nikola Stevanović]

Hi Lukas,

thank you for showing interest in this issue, but I've somehow managed to reach solution with great help of @jklingsporn.

Details to my answer can be checked here on Stackoverflow.

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