3.6.3 Connectable databases

This subsection describes the databases that can be connected to by using DB Connector.

Organization of this subsection
(1) Types of connectable databases
(2) Mapping the databases and JDBC drivers
(3) JDBC specifications supported by DB Connector

(1) Types of connectable databases

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.

(2) Mapping the databases and JDBC drivers

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)

DatabaseJDBC driver
HiRDB Type4 JDBC DriverOracle JDBC Thin DriverJDBC driver for SQL Server
HiRDBMNN
OracleNMN
SQL ServerNNY
XDM/RD E2YNN
Legend:
M: Available and usage is recommended.
Y: Available.
N: Not available.

(3) JDBC specifications supported by DB Connector

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 connectionsJDBC specifications supported by DB Connector
HiRDB Type4 JDBC DriverJDBC 4.0
Oracle JDBC Thin DriverJDBC 4.0
SQL Server JDBC Driver 3.0JDBC 3.0
JDBC Driver 4.0 for SQL ServerJDBC 4.0
Hint
Oracle JDBC Thin Driver supports functionality in the range defined in the JDBC 4.0 specifications. The Oracle extension functionality using the classes and interfaces in the Oracle package is not available.
Also, when Application Server connects to a database by using Oracle JDBC Thin Driver, the extension functionality of Oracle JDBC Thin Driver, statement cache and connection cache functionality, cannot be used. Use the statement pooling or connection pooling provided with Application Server. For details on statement pooling or connection pooling, see 3.14 Functionality for performance tuning.
Note that the java.sql.Wrapper interface is not supported. If a method of the Wrapper interface is used, the UnsupportedOperationException exception is thrown.
Note
From among the methods of the java.sql.Statement interface in the JDBC specifications, the following methods are not supported:
  • setCursorName(String name)
  • setFetchDirection(int direction)