SQLConnection |
SQLConnection.batch(List<String> sqlStatements) |
Batch simple SQL strings and execute the batch where the async result contains a array of Integers.
|
SQLConnection |
SQLConnection.batch(List<String> sqlStatements,
io.vertx.core.Handler<io.vertx.core.AsyncResult<List<Integer>>> handler) |
Batch simple SQL strings and execute the batch where the async result contains a array of Integers.
|
SQLConnection |
SQLConnection.batchCallableWithParams(String sqlStatement,
List<io.vertx.core.json.JsonArray> inArgs,
List<io.vertx.core.json.JsonArray> outArgs) |
Batch a callable statement with all entries from the args list.
|
SQLConnection |
SQLConnection.batchCallableWithParams(String sqlStatement,
List<io.vertx.core.json.JsonArray> inArgs,
List<io.vertx.core.json.JsonArray> outArgs,
io.vertx.core.Handler<io.vertx.core.AsyncResult<List<Integer>>> handler) |
Batch a callable statement with all entries from the args list.
|
SQLConnection |
SQLConnection.batchWithParams(String sqlStatement,
List<io.vertx.core.json.JsonArray> args) |
Batch a prepared statement with all entries from the args list.
|
SQLConnection |
SQLConnection.batchWithParams(String sqlStatement,
List<io.vertx.core.json.JsonArray> args,
io.vertx.core.Handler<io.vertx.core.AsyncResult<List<Integer>>> handler) |
Batch a prepared statement with all entries from the args list.
|
SQLConnection |
SQLConnection.call(String sql) |
Calls the given SQL PROCEDURE which returns the result from the procedure.
|
SQLConnection |
SQLConnection.call(String sql,
io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.ResultSet>> resultHandler) |
Calls the given SQL PROCEDURE which returns the result from the procedure.
|
SQLConnection |
SQLConnection.callWithParams(String sql,
io.vertx.core.json.JsonArray params,
io.vertx.core.json.JsonArray outputs) |
Calls the given SQL PROCEDURE which returns the result from the procedure.
|
SQLConnection |
SQLConnection.callWithParams(String sql,
io.vertx.core.json.JsonArray params,
io.vertx.core.json.JsonArray outputs,
io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.ResultSet>> resultHandler) |
Calls the given SQL PROCEDURE which returns the result from the procedure.
|
SQLConnection |
SQLConnection.commit() |
Commits all changes made since the previous commit/rollback.
|
SQLConnection |
SQLConnection.commit(io.vertx.core.Handler<io.vertx.core.AsyncResult<Void>> handler) |
Commits all changes made since the previous commit/rollback.
|
SQLConnection |
SQLConnection.execute(String sql) |
Executes the given SQL statement
|
SQLConnection |
SQLConnection.execute(String sql,
io.vertx.core.Handler<io.vertx.core.AsyncResult<Void>> resultHandler) |
Executes the given SQL statement
|
SQLConnection |
SQLConnection.getTransactionIsolation() |
Attempts to return the transaction isolation level for this Connection object to the one given.
|
SQLConnection |
SQLConnection.getTransactionIsolation(io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.TransactionIsolation>> handler) |
Attempts to return the transaction isolation level for this Connection object to the one given.
|
static SQLConnection |
SQLConnection.newInstance(io.vertx.ext.sql.SQLConnection arg) |
|
SQLConnection |
SQLConnection.query(String sql) |
Executes the given SQL SELECT statement which returns the results of the query.
|
SQLConnection |
SQLConnection.query(String sql,
io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.ResultSet>> resultHandler) |
Executes the given SQL SELECT statement which returns the results of the query.
|
SQLConnection |
SQLConnection.queryStream(String sql) |
Executes the given SQL SELECT statement which returns the results of the query as a read stream.
|
SQLConnection |
SQLConnection.queryStream(String sql,
io.vertx.core.Handler<io.vertx.core.AsyncResult<SQLRowStream>> handler) |
Executes the given SQL SELECT statement which returns the results of the query as a read stream.
|
SQLConnection |
SQLConnection.queryStreamWithParams(String sql,
io.vertx.core.json.JsonArray params) |
Executes the given SQL SELECT statement which returns the results of the query as a read stream.
|
SQLConnection |
SQLConnection.queryStreamWithParams(String sql,
io.vertx.core.json.JsonArray params,
io.vertx.core.Handler<io.vertx.core.AsyncResult<SQLRowStream>> handler) |
Executes the given SQL SELECT statement which returns the results of the query as a read stream.
|
SQLConnection |
SQLConnection.queryWithParams(String sql,
io.vertx.core.json.JsonArray params) |
Executes the given SQL SELECT prepared statement which returns the results of the query.
|
SQLConnection |
SQLConnection.queryWithParams(String sql,
io.vertx.core.json.JsonArray params,
io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.ResultSet>> resultHandler) |
Executes the given SQL SELECT prepared statement which returns the results of the query.
|
SQLConnection |
SQLConnection.rollback() |
Rolls back all changes made since the previous commit/rollback.
|
SQLConnection |
SQLConnection.rollback(io.vertx.core.Handler<io.vertx.core.AsyncResult<Void>> handler) |
Rolls back all changes made since the previous commit/rollback.
|
SQLConnection |
SQLConnection.setAutoCommit(boolean autoCommit) |
Sets the auto commit flag for this connection.
|
SQLConnection |
SQLConnection.setAutoCommit(boolean autoCommit,
io.vertx.core.Handler<io.vertx.core.AsyncResult<Void>> resultHandler) |
Sets the auto commit flag for this connection.
|
SQLConnection |
SQLConnection.setOptions(io.vertx.ext.sql.SQLOptions options) |
Sets the desired options to be applied to the current connection when statements are executed.
|
SQLConnection |
SQLConnection.setQueryTimeout(int timeoutInSeconds) |
Deprecated.
|
SQLConnection |
SQLConnection.setTransactionIsolation(io.vertx.ext.sql.TransactionIsolation isolation) |
Attempts to change the transaction isolation level for this Connection object to the one given.
|
SQLConnection |
SQLConnection.setTransactionIsolation(io.vertx.ext.sql.TransactionIsolation isolation,
io.vertx.core.Handler<io.vertx.core.AsyncResult<Void>> handler) |
Attempts to change the transaction isolation level for this Connection object to the one given.
|
SQLConnection |
SQLConnection.update(String sql) |
Executes the given SQL statement which may be an INSERT , UPDATE , or DELETE
statement.
|
SQLConnection |
SQLConnection.update(String sql,
io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.UpdateResult>> resultHandler) |
Executes the given SQL statement which may be an INSERT , UPDATE , or DELETE
statement.
|
SQLConnection |
SQLConnection.updateWithParams(String sql,
io.vertx.core.json.JsonArray params) |
Executes the given prepared statement which may be an INSERT , UPDATE , or DELETE
statement with the given parameters
|
SQLConnection |
SQLConnection.updateWithParams(String sql,
io.vertx.core.json.JsonArray params,
io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.UpdateResult>> resultHandler) |
Executes the given prepared statement which may be an INSERT , UPDATE , or DELETE
statement with the given parameters
|