Getting the Underlying JDBC Connection from a JMS Session

Figure 16-6 Use Case Diagram: Get the Underlying JDBC Connection from a JMS Session

Text description of the illustration adq16jsi46.gif

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Operational Interface -- Basic Operations"

Purpose

Get the Underlying JDBC Connection from a JMS session

Usage Notes

This method is used to obtain the underlying JDBC connection from a JMS session. The JDBC connection may be used to perform SQL operations as part of the same transaction that the JMS operations are done.

Syntax

See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Use the following syntax references for each programmatic environment:

• See Java (JDBC): Oracle9i Supplied Java Packages Reference oracle.jms, AQjmsSession.getDBConnection

Examples

See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment.

java.sql.Connection db_conn;
QueueSession     jms_sess;
db_conn = ((AQjmsSession)jms_sess).getDBConnection();