vertx-jdbc-client icon indicating copy to clipboard operation
vertx-jdbc-client copied to clipboard

Published 20 hours ago • verified publisher icon vert-x3

New pooled client handles stores procedures differently then deprecated client.

Open javadevmtl opened this issue 3 years ago • 0 comments

Vertx 4.1.4 and Ms Sql 2016.

Based on convo here: https://groups.google.com/g/vertx/c/2iBAmU-xGNE

In the deprecated client we are able to use CallableStatment, it seems that in the new client everything is delegated to PreparedStatment.

On the deprecated client CallableStatement and PreparedStament results are treated differently. When using the new client with stored procedures we get com.microsoft.sqlserver.jdbc.SQLServerException: The statement must be executed before any results can be obtained.

Which then requires us to set "autoGeneratedKeys": false this is not documented.

Either it needs to be documented. Or it should be considered to use CallableStatement for SPs and handle the result differently?

javadevmtl avatar Oct 05 '21 02:10 javadevmtl