| 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  PROCEDUREwhich returns the result from the procedure. | 
| SQLConnection | SQLConnection. callWithParams(String sql,
              JsonArray params,
              JsonArray outputs,
              Handler<AsyncResult<ResultSet>> resultHandler)Calls the given SQL  PROCEDUREwhich 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  SELECTstatement which returns the results of the query. | 
| SQLConnection | SQLConnection. queryStream(String sql,
           Handler<AsyncResult<SQLRowStream>> handler)Executes the given SQL  SELECTstatement 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  SELECTstatement 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  SELECTprepared 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)withSQLOptions.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, orDELETEstatement. | 
| SQLConnection | SQLConnection. updateWithParams(String sql,
                JsonArray params,
                Handler<AsyncResult<UpdateResult>> resultHandler)Executes the given prepared statement which may be an  INSERT,UPDATE, orDELETEstatement 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 © 2023 Eclipse. All rights reserved.