RDB
JDBC driver is needed when connect the Flow service to the database. The JDBC driver type is decided by the database type. The procedure about how to connect Flow to the database is as below.
- Get the JDBC driver of the database which is going to use.
- Put the JDBC driver files under [INSTALL_DIR]/jre/lib/ext.
- Restart the Flow service.
- Define the connection configuration on the Flow Designer or the Management Console, and test the connection.
Caution
The JDPC driver files under [INSTALL_DIR]/jre/lib/ext are shared with the Pipeline service.
Content for connection configurations
| property name | discriptions |
| connection name |
Input a name to recognize the connection configurations. |
| database type[databasetype] |
Select a database from the list box for connecting. We have prepared kinds of ways for connecting according to the database type, for example, JDBC,ODBC. Please select a way according to the actual environment. |
| Driver[driver] |
Once the datebase type is specfied, the driver will be input automatically. Usually, there is no need to change the item. |
| URL[url] |
Once the database type is specified, the URL used to connect to the database will be input automatically. You can only change the part of [ ]. |
| username[[username] |
Input a username for connecting |
| password[password] |
Input a password for connecting. |
| schema[useSchemata] |
Input a schema. The schema includs a table list which consists of the SQLBuilder and the dialog for selecting a table. |
| connection pooling[pool] |
Select whether to use pooled connections or not for connecting.
| Yes[true] | Use connection pools (initial value) |
| No[false] | Don't use connection pools |
|
| XA Support[xa] |
Select whether to use XA interface or not to connect to DB.
If specify "ture" to the database which is not with the XA interface, error will occure when save it.
| Yes[true] | Use XA |
| No[false] | Don't use XA(initial value) |
|
| modify dynamically |
Select whether to enable it to modify the connection definition by DynamicConnection component while flow is running.
Select "Yes" to enable it to select in the "connection" property of DynamicConnection component.
| No | Don't enable it to modify.(initial value) |
| Yes | Enable it to modify. |
|