- Index
- »
- fan.sql
- »
- SqlConnPool
SqlConnPool
const class SqlConnPool : Obj
SqlConnPool manages a pool of reusable SQL connections
It-block construtor
Connection password
Time to linger an idle connection before closing it
Logger
Max number of simultaneous connections to allow before blocking threads
autoCommit sets the autoCommit field on a connection just after it is opened by the pool
Connection URI
Max time to block waiting for a connection before raising TimeoutErr
Connection username
onClose is invoked just before a connection is closed by the pool
Return if close has been called
onOpen is invoked just after a connection is opened by the pool
Close idle connections that have lingered past the linger timeout
Close all connections and raise exception on any new executes
Allocate a SQL connection inside the given callback
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
Time to linger an idle connection before closing it. An external actor must call checkLinger periodically to close idle connetions.
const Log : log
Logger
new make(|This|? f)
It-block construtor
const Int : maxConns
Max number of simultaneous connections to allow before blocking threads
virtual Void onClose(SqlConn c)
onClose is invoked just before a connection is closed by the pool.
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
Max time to block waiting for a connection before raising TimeoutErr
const Str : uri
Connection URI
const Str? : username
Connection username