6.1 Linking with the database

Application Server can connect to the following databases:

The functions that you can use are different for every database. Note that you can use SQL Server only for Windows.

This section describes the databases, to which you can connect from the J2EE server and the JDBC driver you use for connecting. The JDBC driver you use for connecting is different for every database. You can use two connection methods for the database connection, such as the method of connecting to a database by using the JDBC interface and the method of connecting to a database by using the JMS interface in addition to the JDBC interface.

The following table describes the relationship of the databases that can be connected from the J2EE server, the JDBC driver, and the interface used for connection.

Table 6-1 Databases that can be connected from the J2EE server

DatabaseJDBC driverJDBC interfaceJMS interface and JDBC interface
Local transactionGlobal transactionLocal transactionGlobal transaction
HiRDB Version 9HiRDB Type 4 JDBC DriverYYYY
HiRDB Version 8HiRDB Type 4 JDBC DriverYYYY
XDM/RD E2HiRDB Type 4 JDBC DriverY------
Oracle 11g R1
11.1.0
Oracle JDBC Thin DriverYYYY
Oracle 11g R2
11.2.0
Oracle JDBC Thin DriverYYYY
Oracle 12c
12.1.0
Oracle JDBC Thin DriverYYYY
SQL Server 2012JDBC Driver 4.0 for SQL ServerY------
SQL Server 2008SQL Server JDBC Driver 3.0Y------
SQL Server 2008 R2SQL Server JDBC Driver 3.0 or JDBC Driver 4.0 for SQL ServerY------
SQL Server 2005SQL Server JDBC Driver 3.0Y------
Legend:
Y: Can be used.
--: Cannot be used.

Application Server provides a resource adapter for connecting to these databases. For details on the databases that can be connected and the functionalities that can be used, see section 3.3 Resource connections in the Application Server Common Container Functionality Guide.