This subsection describes the databases that can be connected to by using DB Connector.
The databases that you can connect to by using DB Connector include HiRDB, Oracle, SQL Server, and XDM/RD E2. Note that you cannot use global transactions with SQL Server and XDM/RD E2.
To connect to a database by using DB Connector, you require a JDBC driver compatible with the database. The following table describes the mapping between the database to be connected to and the available JDBC drivers.
Table 3-22 Database to be connected to and the available JDBC drivers (for database connections)
Database | JDBC driver | ||
---|---|---|---|
HiRDB Type4 JDBC Driver | Oracle JDBC Thin Driver | JDBC driver for SQL Server | |
HiRDB | M | N | N |
Oracle | N | M | N |
SQL Server | N | N | Y |
XDM/RD E2 | Y | N | N |
The following table describes the JDBC drivers used for connections and the JDBC specifications supported by DB Connector. However, if the JDBC drivers used for connections do not support the functionality provided in the JDBC specifications, that functionality cannot be used with DB Connector.
Table 3-23 JDBC drivers used for connections and the JDBC specifications supported by DB Connector
JDBC drivers used for connections | JDBC specifications supported by DB Connector |
---|---|
HiRDB Type4 JDBC Driver | JDBC 4.0 |
Oracle JDBC Thin Driver | JDBC 4.0 |
SQL Server JDBC Driver 3.0 | JDBC 3.0 |
JDBC Driver 4.0 for SQL Server | JDBC 4.0 |