Support for call and call with param in SQLConnection

vert-x3 / vertx-mysql-postgresql-client

This client is deprecated - use instead

https://github.com/eclipse-vertx/vertx-sql-client

Apache License 2.0

117 stars 59 forks source link

Support for call and call with param in SQLConnection #114

Closed pratikpparikh closed 6 years ago

pratikpparikh commented 6 years ago

Dear Authors,

I need support for call and callwithparams are not implemented in SQLConenction, can you please let me know when this is planned. Also what is the blocker on this, want to understand why the support was not added?

If I need to wrap many sql queries in one to share a single connection to provide features like (row level locking) then not having it implemented requires using a workaround using querywithparams.

Regards, Pratik Parikh

julianladisch commented 6 years ago

There is some explanation how to do it:

call, callWithParam: https://vertx.io/docs/vertx-sql-common/java/#_callable_statements
batch, batchWithParams: https://vertx.io/docs/vertx-sql-common/java/#_batch_operations
transaction (commit/rollback): https://vertx.io/docs/vertx-sql-common/java/#_using_transactions