sql:connect creates a database connection. It has attributes
all of which are attribute value templates (so the values can be passed in as parameters).
driver attribute names the JDBC driver class to be used. The
database name must be a name that JDBC can associate with an actual database.
auto-commit attribute, if present, should take the value "yes" or "no". This
causes a call of
connection.setAutoCommit() on the underlying JDBC connection.
sql:connect instruction returns a database connection as a value, specifically
a value of type "external object", which can be referred to using the type
the value will be assigned to a variable using the construct:
This can be a global variable or a local variable; if local, it can be passed to other templates
as a parameter in the normal way. The connection is used on instructions such as
sql:query with an attribute such as
connection="$connection"; the value
connection attribute is an expression that returns a database connection object.