What does this error mean: the given SQL statement produces an unxpected ResultSet object

Question

The error:

"the given SQL statement produces an unxpected ResultSet object"

Was seen trying to call a stored procedure.  I am using a MariaDB database.

Answer 1

If you see this error it is likely due to trying to call a stored procedure that returns a result set using pQuery.doUpdateQuery. Recommend using pQuery.callStoredProcedure instead.

We have only seen this error when using a MariaDB database with the 3.x JDBC client.