Bool autoCommit

autoCommit sets the autoCommit field on a connection just after it is opened by the pool.

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 SqlConn.commit or SqlConn.rollback.

Void checkLinger()

Close idle connections that have lingered past the linger timeout.

Void close()

Close all connections and raise exception on any new executes

Void execute(|SqlConn| f)

Allocate a SQL connection inside the given callback. If a connection cannot be acquired before timeout elapses then a TimeoutErr is raised. Do not close the connection inside the callback.

Bool isClosed()

Return if close has been called.

const Duration linger := 5min

Time to linger an idle connection before closing it. An external actor must call checkLinger periodically to close idle connetions.

const Log log := Log.get("sqlPool")

Logger

new make(|This|? f)

It-block construtor

const Int maxConns := 10

Max number of simultaneous connections to allow before blocking threads

protected virtual Void onClose(SqlConn c)

onClose is invoked just before a connection is closed by the pool.

protected virtual Void onOpen(SqlConn c)

onOpen is invoked just after a connection is opened by the pool.

const Str? password

Connection password

const Duration timeout := 30sec

Max time to block waiting for a connection before raising TimeoutErr

const Str uri

Connection URI

const Str? username

Connection username