Forms: Datasource Instance
Datasource Instances define the connection details to the database. A number of instances can be defined to allow for several connections under a single Datasource. At least one Datasource Instance must be defined for each Datasource.
Form: Datasource Instance Details
The following fields are configured on the Details tab:
| Field | Description |
|---|---|
| Name | Name of the datasource instance. This must be unique, although one instance may be named "Default". Typically, if a datasource has only one instance then it usually named "Default". |
| URL | URL for the data source. This is the full url required in Java, not the service name which might be used for various database technologies such as Oracle. e.g. jdbc:oracle:thin:@localhost:1521:orcl |
| Anonymous Username | The anonymous username configured to access the datasource instance. |
| Password | The password for the anonymous username configured to access the datasource instance. |
The following fields are configured through separate tabs on the form:
| Field | Description |
|---|---|
| Check Query | This is an advanced (optional) setting. Use this field when connections to the target database might go "stale", e.g. if the target database disconnects long running connections. Setting this field causes PhixFlow to run the query against the database just before each use of a "pooled" connection. If the query does not return a row, the connection is discarded and a new connection is created. To avoid any performance impact, the query should execute quickly |
| Description | Description of the datasource instance. |
Form Icons
The form provides the standard form icons.