JDBCCallabe execute does not return the result set when use with HSQLDB Stored Procedure Cursor.

[cristian-joseb]

Questions

Do not use this issue tracker to ask questions, instead use one of these channels. Questions will likely be closed without notice.

Version

Which version(s) did you encounter this bug ? 3.9.13

Context

When writing some unit using HSQLDB, the execute method return false, and hence the result set is not returned.

https://github.com/vert-x3/vertx-jdbc-client/blob/master/src/main/java/io/vertx/ext/jdbc/impl/actions/JDBCCallable.java#L50

HSQLDB return false when call CallableStatement.execute(), in such a case Vertx is not able to return the result set.

Do you have a reproducer?

A reproducer is a simple project hosted on GitHub (or another forge supporting git clone operation) that has a build file that can be executed to reproduce the issue.

Reproducers are very helpful for contributors and will likely help them fixing your bug faster.

• Link to github project/gist

https://github.com/cristian-joseb/vertx-JDBCCallable-HSQLDB/blob/main/src/test/java/org/brito/jdbc/JDBCCallableStoreProcedureTest.java

Steps to reproduce

1. clone project.
2. run the unit test.

Extra

• Anything that can be relevant such as OS version, JVM version Java 8