type

SqlConn

mixin SqlConn

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

fields

autoCommit

If auto-commit is true then each statement is executed and committed as an individual transaction.

methods

close

Close the database connection.

commit

Commit all the changes made inside the current transaction.

isClosed

Return if close has been called.

meta

Get the database meta-data

open

Open a connection to the database specified by the given JDBC uri and username/password credentials.

rollback

Undo any changes made inside the current transaction.

sql

Create a statement for this database.

Slot Details

autoCommit

abstract Bool autoCommit

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()

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.

commit

abstract Void commit()

Commit all the changes made inside the current transaction.

isClosed

abstract Bool isClosed()

Return if close has been called.

meta

abstract SqlMeta meta()

Get the database meta-data

open

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

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()

Undo any changes made inside the current transaction.

sql

abstract Statement sql(Str sql)

Create a statement for this database.