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 <https://github.com/nixos89/VertxPgReactiveJOOQ/blob/book_CRUD/vertx-pg-reactive-jooq/src/main/java/com/ns/vertx/pg/BookJooqQueries.java> to my class where I am getting this error and this is HttpVerticle <https://github.com/nixos89/VertxPgReactiveJOOQ/blob/book_CRUD/vertx-pg-reactive-jooq/src/main/java/com/ns/vertx/pg/HttpVerticle.java> 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). -- 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/f7a974e2-6d7e-466c-9154-757985a1b330%40googlegroups.com.
