search

vert-x3 / vertx-jdbc-client

JDBC support for Vert.x
Apache License 2.0
126 stars 90 forks source link

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

Open cristian-joseb opened 2 years ago

cristian-joseb commented 2 years ago

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.

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