uCosminexus Application Server Overview

[Contents][Index][Back][Next]

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

Database JDBC driver JDBC interface JMS interface and JDBC interface
Local transaction Global transaction Local transaction Global transaction
HiRDB Version 9 HiRDB Type 4 JDBC Driver Y Y Y Y
HiRDB Version 8 HiRDB Type 4 JDBC Driver Y Y Y Y
XDM/RD E2 HiRDB Type 4 JDBC Driver Y -- -- --
Oracle 11g R1
11.1.0
Oracle JDBC Thin Driver Y Y Y Y
Oracle 11g R2
11.2.0
Oracle JDBC Thin Driver Y Y Y Y
Oracle 12c
12.1.0
Oracle JDBC Thin Driver Y Y Y Y
SQL Server 2012 JDBC Driver 4.0 for SQL Server Y -- -- --
SQL Server 2008 SQL Server JDBC Driver 3.0 Y -- -- --
SQL Server 2008 R2 SQL Server JDBC Driver 3.0 or JDBC Driver 4.0 for SQL Server Y -- -- --
SQL Server 2005 SQL Server JDBC Driver 3.0 Y -- -- --

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.