mixin sql::SqlConn

sql::SqlConn

Source

SqlConn manages a connection to a relational database. See pod-doc.

autoCommit

abstract Bool autoCommit

Source

If auto-commit is true then each statement is executed and committed as an individual transaction. Otherwise statements are grouped into transaction which must be closed via commit or rollback.

close

abstract Bool close()

Source

Close the database connection. Closing a connection already closed is a no-op. This method is guaranteed to never throw an exception. Return true if the connection was closed successfully or false if closed abnormally.

Do not close connections that were created by SqlConnPool. The pool handles that for you.

commit

abstract Void commit()

Source

Commit all the changes made inside the current transaction.

isClosed

abstract Bool isClosed()

Source

Return if close has been called.

meta

abstract SqlMeta meta()

Source

Get the database meta-data

open

static SqlConn open(Str uri, Str? username, Str? password)

Source

Open a connection to the database specified by the given JDBC uri and username/password credentials. Raise exception if connection cannot be established. See pod-doc.

rollback

abstract Void rollback()

Source

Undo any changes made inside the current transaction.

sql

abstract Statement sql(Str sql)

Source

Create a statement for this database.

stash

abstract Str:Obj? stash()

Source

User data stash for adding cached data to this connection.