Currently, only one JDBC data source is supported for each JDBC data
view. In other words, you cannot load balance across JDBC data sources. To
access multiple JDBC data sources, you can create a data view for each data
source, and join them together with a join data view.

The following properties must be set when you create a JDBC data source:

db-name

The name of the relational database, for example, payrolldb.

db-url

The URL to the database, in the form jdbc:vendor:driver://dbhost:dbport.

The db-url is not a complete
JDBC database URL, because it does not contain the database name. (The database
name is specified by the db-name property.)

You must finish db-url with a / for
MySQL, DB2, and Derby databases and with a : for Oracle
database.

driver-class

The JDBC driver class, for example org.hsqldb.jdbcDriver.

driver-url

The path to the JDBC driver, for example file:///path/to/hsqldb/lib/hsqldb.jar.

The driver-url property is multi-valued. Hence, driver-url can support multiple JAR files for the JDBC driver to
ensure connectivity to the JDBC source on different platforms.