| Package | Description | 
|---|---|
| io.vertx.ext.sql | |
| io.vertx.reactivex.ext.sql | |
| io.vertx.rxjava.ext.sql | 
| Modifier and Type | Method and Description | 
|---|---|
SQLConnection | 
SQLConnection.batch(List<String> sqlStatements,
     Handler<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<JsonArray> inArgs,
                       List<JsonArray> outArgs,
                       Handler<AsyncResult<List<Integer>>> handler)
Batch a callable statement with all entries from the args list. 
 | 
SQLConnection | 
SQLConnection.batchWithParams(String sqlStatement,
               List<JsonArray> args,
               Handler<AsyncResult<List<Integer>>> handler)
Batch a prepared statement with all entries from the args list. 
 | 
SQLConnection | 
SQLConnection.call(String sql,
    Handler<AsyncResult<ResultSet>> resultHandler)
Calls the given SQL  
PROCEDURE which returns the result from the procedure. | 
SQLConnection | 
SQLConnection.callWithParams(String sql,
              JsonArray params,
              JsonArray outputs,
              Handler<AsyncResult<ResultSet>> resultHandler)
Calls the given SQL  
PROCEDURE which returns the result from the procedure. | 
SQLConnection | 
SQLConnection.commit(Handler<AsyncResult<Void>> handler)
Commits all changes made since the previous commit/rollback. 
 | 
SQLConnection | 
SQLConnection.execute(String sql,
       Handler<AsyncResult<Void>> resultHandler)
Executes the given SQL statement 
 | 
SQLConnection | 
SQLConnection.getTransactionIsolation(Handler<AsyncResult<TransactionIsolation>> handler)
Attempts to return the transaction isolation level for this Connection object to the one given. 
 | 
SQLConnection | 
SQLConnection.query(String sql,
     Handler<AsyncResult<ResultSet>> resultHandler)
Executes the given SQL  
SELECT statement which returns the results of the query. | 
SQLConnection | 
SQLConnection.queryStream(String sql,
           Handler<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,
                     JsonArray params,
                     Handler<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,
               JsonArray params,
               Handler<AsyncResult<ResultSet>> resultHandler)
Executes the given SQL  
SELECT prepared statement which returns the results of the query. | 
SQLConnection | 
SQLConnection.rollback(Handler<AsyncResult<Void>> handler)
Rolls back all changes made since the previous commit/rollback. 
 | 
SQLConnection | 
SQLConnection.setAutoCommit(boolean autoCommit,
             Handler<AsyncResult<Void>> resultHandler)
Sets the auto commit flag for this connection. 
 | 
SQLConnection | 
SQLConnection.setOptions(SQLOptions options)
Sets the desired options to be applied to the current connection when statements are executed. 
 | 
default SQLConnection | 
SQLConnection.setQueryTimeout(int timeoutInSeconds)
Deprecated. 
 
instead use  
setOptions(SQLOptions) with SQLOptions.setQueryTimeout(int) | 
SQLConnection | 
SQLConnection.setTransactionIsolation(TransactionIsolation isolation,
                       Handler<AsyncResult<Void>> handler)
Attempts to change the transaction isolation level for this Connection object to the one given. 
 | 
SQLConnection | 
SQLConnection.update(String sql,
      Handler<AsyncResult<UpdateResult>> resultHandler)
Executes the given SQL statement which may be an  
INSERT, UPDATE, or DELETE
 statement. | 
SQLConnection | 
SQLConnection.updateWithParams(String sql,
                JsonArray params,
                Handler<AsyncResult<UpdateResult>> resultHandler)
Executes the given prepared statement which may be an  
INSERT, UPDATE, or DELETE
 statement with the given parameters | 
| Modifier and Type | Method and Description | 
|---|---|
SQLClient | 
SQLClient.getConnection(Handler<AsyncResult<SQLConnection>> handler)
Returns a connection that can be used to perform SQL operations on. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
SQLConnection | 
SQLConnection.getDelegate()  | 
| Modifier and Type | Method and Description | 
|---|---|
static SQLConnection | 
SQLConnection.newInstance(SQLConnection arg)  | 
| Constructor and Description | 
|---|
SQLConnection(SQLConnection delegate)  | 
| Modifier and Type | Method and Description | 
|---|---|
SQLConnection | 
SQLConnection.getDelegate()  | 
| Modifier and Type | Method and Description | 
|---|---|
static SQLConnection | 
SQLConnection.newInstance(SQLConnection arg)  | 
| Constructor and Description | 
|---|
SQLConnection(SQLConnection delegate)  | 
Copyright © 2020 Eclipse. All rights reserved.