Creates a database connection.
The name of the JDBC driver class to be used. From Saxon 10.5 this is no longer needed, and is ignored if specified.
The name (URL) of the database. Must be a name that JDBC can associate with an
actual database. An example might be
The user name if required for connection (and if not included in the database URL).
The password if required for connection (and if not included in the database URL).
If the value is
Requires Saxon-PE or Saxon-EE. Available for Java only.
sql:connect instruction returns a database connection as a value,
specifically a value of type "external object", which can be referred to using the
java:java.sql.Connection. Typically 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:insert and
sql:query with an attribute such
connection="$connection"; the value of the
attribute is an expression that returns a database connection object.