class isql::SqlConn

sys::Obj
  isql::SqlConn

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

autoCommit

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

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

Void commit()

Commit all the changes made inside the current transaction.

isClosed

Bool isClosed()

Return if close has been called.

meta

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

Void rollback()

Undo any changes made inside the current transaction.

sql

Statement sql(Str sql, Bool prepare := true)

Create a statement for this database.