Used to create, update, delete and browse through outgoing SQL connections, used by Zato services to access SQL databases.
Whether the connection can be used by services or not.
If a connection is not active a service will encounter a zato.common.Inactive exception when attempting to use it.
Note that an inactive connection still can be pinged.
|Database name||Database name|
|Pool size||Connection pool size. Always start with 1 and increase only if it’s not enough in practice.|
|Extra||(Optional) Any extra parameters passed directly into SQLAlchemy’s create_engine function as its keyword arguments. A connection won’t be available if any of the keywords is not a valid SQLAlchemy one.|
A connection can be pinged - this sends a dummy query from one of a cluster’s servers. This can be used to check whether a given database is reachable by Zato servers.
The feature is available even if a connection is inactive.