Connection¶

[Source]

Non-sendable database connection wrapping SQLHDBC (and its own SQLHENV). All methods check internal state and return errors for misuse.

class ref Connection

Public Functions¶

exec¶

[Source]

Execute a non-parameterized statement via SQLExecDirect. Returns affected row count, or None for DDL.

fun ref exec(
  sql: String val)
: (RowCount | ExecError val)

Parameters¶

sql: String val

Returns¶

(RowCount | ExecError val)

exec_p¶

[Source]

Partial variant of exec(). Raises error on failure. For try/else chaining of multiple statements.

fun ref exec_p(
  sql: String val)
: RowCount ?

Parameters¶

sql: String val

Returns¶

RowCount ?

prepare¶

[Source]

Prepare a statement for parameter binding and repeated execution.

fun ref prepare(
  sql: String val)
: (Statement ref | PrepareError val)

Parameters¶

sql: String val

Returns¶

(Statement ref | PrepareError val)

prepare_p¶

[Source]

Partial variant of prepare(). Raises error on failure.

fun ref prepare_p(
  sql: String val)
: Statement ref ?

Parameters¶

sql: String val

Returns¶

Statement ref ?

query¶

[Source]

Execute a SELECT via SQLExecDirect and return a Cursor.

fun ref query(
  sql: String val)
: (Cursor ref | ExecError val)

Parameters¶

sql: String val

Returns¶

(Cursor ref | ExecError val)

query_p¶

[Source]

Partial variant of query(). Raises error on failure.

fun ref query_p(
  sql: String val)
: Cursor ref ?

Parameters¶

sql: String val

Returns¶

Cursor ref ?

begin¶

[Source]

Set autocommit off. Returns error if already in a transaction or if the connection is closed.

fun ref begin()
: (TxBegun val | TxBeginError val)

Returns¶

(TxBegun val | TxBeginError val)

commit¶

[Source]

Commit the current transaction and re-enable autocommit.

fun ref commit()
: (TxCommitted val | TxCommitError val)

Returns¶

(TxCommitted val | TxCommitError val)

rollback¶

[Source]

Rollback the current transaction and re-enable autocommit.

fun ref rollback()
: (TxRolledBack val | TxRollbackError val)

Returns¶

(TxRolledBack val | TxRollbackError val)

begin_p¶

[Source]

Partial variant of begin(). Raises error on failure.

fun ref begin_p()
: None val ?

Returns¶

None val ?

commit_p¶

[Source]

Partial variant of commit(). Raises error on failure.

fun ref commit_p()
: None val ?

Returns¶

None val ?

rollback_p¶

[Source]

Partial variant of rollback(). Raises error on failure.

fun ref rollback_p()
: None val ?

Returns¶

None val ?

last_warnings¶

[Source]

fun ref last_warnings()
: (Warnings val | None val)

Returns¶

(Warnings val | None val)

close¶

[Source]

Close the connection. Idempotent. Auto-rollbacks if in a transaction. Sets shared _alive flag to false.

fun ref close()
: None val

Returns¶

None val