uCosminexus Application Server Overview
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 | -- | -- | -- |
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.
All Rights Reserved. Copyright (C) 2013, 2015, Hitachi, Ltd.