Represents a connection to a SQL database
Anything
Object
SQLConnection
Basic
Identifiable
Object
Anything
no subtypes hierarchy
Initializer |
SQLConnection(SQLConnection unknown) |
Inherited Attributes |
Attributes inherited from: Object hash , string |
Methods | |
batch | shared default SQLConnection batch(List<String> sqlStatements, Anything(Throwable|List<Integer>) handler) Batch simple SQL strings and execute the batch where the async result contains a array of Integers. Parameters:
|
batchCallableWithParams | shared default SQLConnection batchCallableWithParams(String sqlStatement, List<Array> inArgs, List<Array> outArgs, Anything(Throwable|List<Integer>) handler) Batch a callable statement with all entries from the args list. Each entry is a batch. The size of the lists inArgs and outArgs MUST be the equal. The operation completes with the execution of the batch where the async result contains a array of Integers. Parameters:
|
batchWithParams | shared default SQLConnection batchWithParams(String sqlStatement, List<Array> args, Anything(Throwable|List<Integer>) handler) Batch a prepared statement with all entries from the args list. Each entry is a batch. The operation completes with the execution of the batch where the async result contains a array of Integers. Parameters:
|
call | shared default SQLConnection call(String sql, Anything(Throwable|ResultSet) resultHandler) Calls the given SQL Parameters:
|
callWithParams | shared default SQLConnection callWithParams(String sql, Array params, Array outputs, Anything(Throwable|ResultSet) resultHandler) Calls the given SQL The index of params and outputs are important for both arrays, for example when dealing with a prodecure that takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like: params = [VALUE1, VALUE2, null] outputs = [null, null, "VARCHAR"] Parameters:
|
close | shared default void close() Closes the connection. Important to always close the connection when you are done so it's returned to the pool. |
close | shared default void close(Anything(Throwable?) handler) Closes the connection. Important to always close the connection when you are done so it's returned to the pool. Parameters:
|
commit | shared default SQLConnection commit(Anything(Throwable?) handler) Commits all changes made since the previous commit/rollback. Parameters:
|
execute | shared default SQLConnection execute(String sql, Anything(Throwable?) resultHandler) Executes the given SQL statement Parameters:
|
getTransactionIsolation | shared default SQLConnection getTransactionIsolation(Anything(Throwable|TransactionIsolation) handler) Attempts to return the transaction isolation level for this Connection object to the one given. Parameters:
|
query | shared default SQLConnection query(String sql, Anything(Throwable|ResultSet) resultHandler) Executes the given SQL Parameters:
|
queryWithParams | shared default SQLConnection queryWithParams(String sql, Array params, Anything(Throwable|ResultSet) resultHandler) Executes the given SQL Parameters:
|
rollback | shared default SQLConnection rollback(Anything(Throwable?) handler) Rolls back all changes made since the previous commit/rollback. Parameters:
|
setAutoCommit | shared default SQLConnection setAutoCommit(Boolean autoCommit, Anything(Throwable?) resultHandler) Sets the auto commit flag for this connection. True by default. Parameters:
|
setQueryTimeout | shared default SQLConnection setQueryTimeout(Integer timeoutInSeconds) Sets a connection wide query timeout. It can be over written at any time and becomes active on the next query call. Parameters:
|
setTransactionIsolation | shared default SQLConnection setTransactionIsolation(TransactionIsolation isolation, Anything(Throwable?) handler) Attempts to change the transaction isolation level for this Connection object to the one given. The constants defined in the interface Connection are the possible transaction isolation levels. Parameters:
|
update | shared default SQLConnection update(String sql, Anything(Throwable|UpdateResult) resultHandler) Executes the given SQL statement which may be an Parameters:
|
updateWithParams | shared default SQLConnection updateWithParams(String sql, Array params, Anything(Throwable|UpdateResult) resultHandler) Executes the given prepared statement which may be an Parameters:
|
Inherited Methods |
Methods inherited from: Object equals |