Executes the provided Statement object, retrieves the generated value, then calls the specified function body with this generated value as its argument and returns its result.

fun exec(stmt: String, args: Iterable<Pair<IColumnType<*>, Any?>> = emptyList(), explicitStatementType: StatementType? = null): Unit?

fun <T : Any> exec(stmt: String, args: Iterable<Pair<IColumnType<*>, Any?>> = emptyList(), explicitStatementType: StatementType? = null, transform: (ResultSet) -> T?): T?

Executes the provided statement exactly, using the supplied args to set values to question mark placeholders (if applicable).

execInBatch

fun execInBatch(stmts: List<String>)

Provided statements will be executed in a batch. Select statements are not supported as it's impossible to return multiple results.

execQuery

fun <R> execQuery(query: BlockingExecutable<ResultApi, *>, body: Statement<ResultApi>.(ResultSet) -> R): R?

Executes the provided query object, retrieves the generated ResultSet, then calls the specified function body with this generated value as its argument and returns its result.

explain

fun JdbcTransaction.explain(analyze: Boolean = false, options: String? = null, body: StatementBuilder.() -> Statement<*>): ExplainBlockingExecutable

Creates an ExplainQuery using the EXPLAIN keyword, which obtains information about a statement execution plan.

fullIdentity

fun fullIdentity(column: Column<*>): String

getOrCreate

fun <T : Any> getOrCreate(key: Key<T>, init: () -> T): T

getUserData

fun <T : Any> getUserData(key: Key<T>): T?

identity

fun identity(column: Column<*>): String

fun identity(table: Table): String

putUserData

fun <T : Any> putUserData(key: Key<T>, value: T)

registerInterceptor

fun registerInterceptor(interceptor: StatementInterceptor): Boolean

Adds the specified StatementInterceptor to act on this transaction.

removeUserData

fun <T : Any> removeUserData(key: Key<T>): Any?

rollback

open override fun rollback()

Reverts all changes since the last commit or rollback operation, or to the last set savepoint, if applicable.

unregisterInterceptor

fun unregisterInterceptor(interceptor: StatementInterceptor): Boolean

Removes the specified StatementInterceptor from acting on this transaction.

withDataBaseLock

fun <T> JdbcTransaction.withDataBaseLock(body: () -> T)

Creates table with name "busy" (if not present) and single column to be used as "synchronization" point. Table wont be dropped after execution.

withSuspendTransaction

suspend fun <T> JdbcTransaction.~~withSuspendTransaction~~(context: CoroutineContext? = null, statement: suspend JdbcTransaction.() -> T): T