Nikola Stevanović
Nikola Stevanović
I've managed to (ALMOST) fix this issue by creating ``s in pom.xml file for user-defined function RETURN_VALUE and INPUT parameter type as described [here](https://stackoverflow.com/a/62633733/6805866) in Stackoverflow Q&A. Problem is that...
Hi @jklingsporn , no problem and thanks for replying. :) The thing is that I can NOT extract result of selected routine from `QueryResult` (above in my 1st post I've...
I see.. anyway, I've tried out what you suggested - replaced parameter of `queryExecutor.query()` method like this: ```java Future ordersFuture = queryExecutor.transaction(qe -> qe.query( dsl -> dsl.resultQuery("SELECT get_all_orders()") )); ```...
BTW, please have a look at ``s from this [line](https://github.com/nixos89/VertxPgReactiveJOOQ/blob/a01c9f8e2b9f4f8f1c19cafe7e37db53d9387a53/vertx-pg-reactive-jooq/pom.xml#L298) in project's *pom.xml* file for generated routines and it's types (**maybe** it might help).
I've tired out to print out in `convertGetAllOrdersQRToJsonObject()` method outside and inside of its FOR-loop `Row.getColumnName(0);` and got the same result which is "**get_all_orders**" and for each next column with...
1) Yes, I'm sure it returns result - I've tested it in pgAdmin4 and DataGrip by running `SELECT get_all_orders();` query. 2) Tried it with plain jOOQ and it works. Code...
As a **temporary workaround** I've managed to solve my use-case by using plain-jOOQ code in combination with [executeBlocking(..)](https://vertx.io/docs/apidocs/io/vertx/core/Vertx.html#executeBlocking-io.vertx.core.Handler-io.vertx.core.Handler-). I did it by using try-catch blocks to perform jOOQ [query](https://github.com/nixos89/VertxPgReactiveJOOQ/blob/1580e45281d1421b466ac7c5b1b86c0f4f34ede2/vertx-pg-reactive-jooq/src/main/java/com/ns/vertx/pg/service/OrderServiceImpl.java#L76): ```java...
> Hey, I tried to run you project but it fails when executing `restore.sql`, e.g. `COPY public.author (author_id, first_name, last_name) FROM '$$PATH$$/3984.dat';` because these files do not exist. I've updated...