<sql-connection>
Use <sql-datasource> instead.
Opens the specified RDBMS connection and registers it as a request attribute. By default, it will be registered under OpenConnectionTask.DEFAULT_ATTRIBUTE_NAME. Cernunnos SQL tasks will look for a connection under this name as well. In most cases, therefore, neither parent nor child tasks need specify an attribute name for the Connection object.
| Name | XPath | Description | Reagent Type | Expected Type | Required |
|---|---|---|---|---|---|
| ATTRIBUTE_NAME | @attribute-name | Optional name under which the new connection will be registered as a request attribute. If omitted, the name 'SqlAttributes.CONNECTION' will be used. | PHRASE | java.lang.String | No |
| DATA_SOURCE | @data-source | Optional DataSource object from which the connection may be opened. This phrase will be evaluated only if DRIVER, URL, USERNAME, and PASSWORD are not provided. The default is a request attribute under the name 'SqlAttributes.DATA_SOURCE'. | PHRASE | javax.sql.DataSource | No |
| DRIVER | @driver | Optional JDBC driver class name to use when opening the connection. You must provide either DATA_SOURCE or DRIVER, URL, USERNAME, and PASSWORD. | PHRASE | java.lang.String | No |
| URL | @url | Optional JDBC connection URL to use when opening the connection. You must provide either DATA_SOURCE or DRIVER, URL, USERNAME, and PASSWORD. | PHRASE | java.lang.String | No |
| USERNAME | @username | Optional username to use when opening the connection. You must provide either DATA_SOURCE or DRIVER, URL, USERNAME, and PASSWORD. | PHRASE | java.lang.String | No |
| PASSWORD | @password | Optional password to use when opening the connection. You must provide either DATA_SOURCE or DRIVER, URL, USERNAME, and PASSWORD. | PHRASE | java.lang.String | No |
| DATA_SOURCE_ATTRIBUTE_NAME | @data-source-attribute-name | Optional name under which the new DataSource will be registered as a request attribute. If omitted, the name 'SqlAttributes.DATA_SOURCE' will be used. | PHRASE | java.lang.String | No |
| SUBTASKS | * | The set of tasks that are children of this task. | NODE_LIST | java.util.List | No |