src Void checkLinger()

Close idle connections that have lingered past the linger timeout.

src Void close()

Close all connections and raise exception on any new executes

src 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.

src Bool isClosed()

Return if close has been called.

src const Duration linger := 5min

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

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

Logger

src new make(|This|? f)

It-block construtor

src const Int maxConns := 10

Max number of simultaneous connections to allow before blocking threads

src protected virtual Void onClose(SqlConn c)

onClose is invoked just before a connection is closed by the pool. This method can be used to clean up any state owned by the connection, for example by closing prepared Statements that are stored in the connection's stash.

src protected virtual Void onOpen(SqlConn c)

onOpen is invoked just after a connection is opened by the pool. This method can be used to modify the newly opened connection, for example by turning off autoCommit.

src const Str? password

Connection password

src const Duration timeout := 30sec

Max time to block waiting for a connection before raising TimeoutErr

src const Str uri

Connection URI

src const Str? username

Connection username