# ExposedConnection

interface ExposedConnection<OriginalConnection : Any>

Represents a wrapper for a database connection.

## Properties

autoCommit
Link copied to clipboard
abstract var autoCommit: Boolean

Whether the connection is in auto-commit mode.

catalog
Link copied to clipboard
abstract var catalog: String

The name of the connection's catalog.

connection
Link copied to clipboard
abstract val connection: OriginalConnection

The underlying database connection object contained by this wrapper.

isClosed
Link copied to clipboard
abstract val isClosed: Boolean

Whether the connection has been closed.

readOnly
Link copied to clipboard
abstract var readOnly: Boolean

Whether the connection is in read-only mode.

schema
Link copied to clipboard
abstract var schema: String

The name of the connection's schema.

transactionIsolation
Link copied to clipboard
abstract var transactionIsolation: Int

The transaction isolation level of the connection.

## Functions

close
Link copied to clipboard
abstract fun close()

Closes the connection and releases any of its database and/or driver resources.

commit
Link copied to clipboard
abstract fun commit()

Saves all changes since the last commit or rollback operation.

executeInBatch
Link copied to clipboard
abstract fun executeInBatch(sqls: List<String>)

Sends a collection of SQL strings to the database for execution as a batch statement.

metadata
Link copied to clipboard
abstract fun <T> metadata(body: ExposedDatabaseMetadata.() -> T): T

Calls the specified function body with an ExposedDatabaseMetadata implementation as its receiver and returns the retrieved metadata as a result.

prepareStatement
Link copied to clipboard
abstract fun prepareStatement(sql: String, columns: Array<String>): PreparedStatementApi
abstract fun prepareStatement(sql: String, returnKeys: Boolean): PreparedStatementApi

Returns a precompiled sql statement stored as a PreparedStatementApi implementation.

releaseSavepoint
Link copied to clipboard
abstract fun releaseSavepoint(savepoint: ExposedSavepoint)

Removes the specified savepoint.

rollback
Link copied to clipboard
abstract fun rollback()

Reverts all changes since the last commit or rollback operation.

abstract fun rollback(savepoint: ExposedSavepoint)

Reverts all changes since the specified savepoint was set.

setSavepoint
Link copied to clipboard
abstract fun setSavepoint(name: String): ExposedSavepoint

Sets and returns a new savepoint with the specified name.