Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New pooled client handles stores procedures differently then deprecated client. #240

Open
javadevmtl opened this issue Oct 5, 2021 · 0 comments
Labels

Comments

@javadevmtl
Copy link

javadevmtl commented Oct 5, 2021

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 javadevmtl added the bug label Oct 5, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

1 participant