sqlObjectMapper/com.qualifiedcactus.sqlObjectMapper

Package-level declarations

Types

AutoGeneratedKeys

enum AutoGeneratedKeys : Enum<AutoGeneratedKeys>

NamedParameterQuery

class NamedParameterQuery(npSqlQuery: String)

Used to parse sql string with named parameter. Parameter start with the character ':'.

NpCallableStatement

class NpCallableStatement : NpStatement, CallableStatement

A named parameter(s) version of CallableStatement

NpPreparedStatement

class NpPreparedStatement : NpStatement, PreparedStatement

A named parameter(s) version of PreparedStatement

NpSqlStringBuilder

class NpSqlStringBuilder @JvmOverloads constructor(val connection: Connection, startingString: String = "")

A convenient class that helps with building dynamic raw sql query

abstract class NpStatement

ResultSetConcurrency

enum ResultSetConcurrency : Enum<ResultSetConcurrency>

ResultSetHoldability

enum ResultSetHoldability : Enum<ResultSetHoldability>

enum ResultSetType : Enum<ResultSetType>

SqlObjectMapperException

open class SqlObjectMapperException : RuntimeException

An exception thrown on invalid mapping

TransactionIsolation

enum TransactionIsolation : Enum<TransactionIsolation>

Isolation level of a transaction

Functions

executeTransaction

fun <T> Connection.executeTransaction(isolationLevel: TransactionIsolation = TransactionIsolation.TRANSACTION_SERIALIZABLE, executor: Connection.() -> T): T

A convenient function for wrapping executor function in a transaction. Will roll back transaction if any exception is thrown.

fun Connection.prepareNpCall(npSql: String): NpCallableStatement

Create NpCallableStatement from a Connection and a SQL string with named parameter (for example ":foo", ":bar")

fun Connection.prepareNpCall(npSql: String, resultSetType: ResultSetType, resultSetConcurrency: ResultSetConcurrency): NpCallableStatement

fun Connection.prepareNpCall(npSql: String, resultSetType: ResultSetType, resultSetConcurrency: ResultSetConcurrency, resultSetHoldability: ResultSetHoldability): NpCallableStatement

prepareNpStatement

fun Connection.prepareNpStatement(npSql: String): NpPreparedStatement

Create NpPreparedStatement from a Connection and a SQL string with named parameter (for example ":foo", ":bar")

fun Connection.prepareNpStatement(npSql: String, autoGeneratedKeys: AutoGeneratedKeys): NpPreparedStatement

fun Connection.prepareNpStatement(npSql: String, declaredGeneratedKeys: DeclaredGeneratedKeys<*>): NpPreparedStatement

fun Connection.prepareNpStatement(npSql: String, resultSetType: ResultSetType, resultSetConcurrency: ResultSetConcurrency): NpPreparedStatement

fun Connection.prepareNpStatement(npSql: String, resultSetType: ResultSetType, resultSetConcurrency: ResultSetConcurrency, resultSetHoldability: ResultSetHoldability): NpPreparedStatement