Hi Lukas, thank you for showing interest in this issue, but I've somehow managed to reach solution with great help of @jklingsporn <https://github.com/jklingsporn/vertx-jooq/issues/150#issuecomment-621104396> .
Details to my answer can be checked here on Stackoverflow <https://stackoverflow.com/a/61556193/6805866>. понедељак, 27. април 2020. 14.21.08 UTC+2, 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 > > On Mon, Apr 27, 2020 at 10:39 AM Nikola Stevanović <[email protected] > <javascript:>> wrote: > >> 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] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/f7a974e2-6d7e-466c-9154-757985a1b330%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/f7a974e2-6d7e-466c-9154-757985a1b330%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/62cb4897-74cb-46f3-aca8-a5b2d85dca5c%40googlegroups.com.
