3.6.2 Available J2EE components and functionality

This subsection describes the functionality available for the database connections.

The following table provides a database-wise description of the J2EE components and functionality available for the database connections.

Table 3-21 Available J2EE components and functionality

ItemsHiRDBOracle11gSQL ServerXDM/RD E2
J2EE componentsServlet/JSPYYYY
Stateless Session BeanYYYY
Stateful Session BeanYYYY
Singleton Session BeanYYYY
Entity Bean (BMP)YYYN
Entity Bean (CMP 1.1)YNNN
Entity Bean (CMP 2.0)Y#1NNN
Message-driven Bean (database access from the onMessage method)YYYY
Available functionalityConnection poolingYYYY
Connection pool warming upYYYY
Connection sharing associationYYYY
Caching the DataSource objectYR#5YY
Optimizing the container-managed sign-on for DB ConnectorYYYY
Connection count adjustment functionalityYYYY
Connection sweeper functionalityYYYY
Displaying the connection pool information (cjlistpool command)YYYY
Clearing the connection pool (cjclearpool command)YYYY
Connection test for resourcesYYYY
Detecting the connection errorsYYYY
Timeout in detecting connection errorsYYYY
Waiting to obtain connections during connection depletionYYYY
Retrying a connectionYYYY
Auto-closing a connectionYYYY
Suspending a connection poolYR#6NY
Restarting a connection poolYR#6NY
Statement poolingY#2YYY#2
Statement cancellationYY#3YY
Statement setQueryTimeout methodYY#3YN
Optional name functionality for J2EE resourcesYYYY
Functionality for reporting exceptions occurring in Client APIsYYYY
PRF trace output of the connection IDYYNY
Output of the SQL statement for troubleshootingYYYY
Connection pool clusteringNY#4NN
Legend:
Y: Available
N: Not available
R: Partially restricted

#1: The CMR functionality, which is the CMP 2.0 functionality, is not available.

#2: The HiRDB auto-reconnect functionality and the statement pooling functionality cannot be used together.

#3 Precautions need to be taken when you connect to Oracle. For details, see 3.6.6 Preconditions and notes on connecting to Oracle.

#4: This functionality is available when the RAC functionality is used and when Oracle JDBC Thin Driver is used for connection.

#5: This functionality is not available when you use a member resource adapter to connect to Oracle11g.

#6: This functionality is available when you use a member resource adapter to connect to Oracle11g.