Registering through the Database with JDBC Connection Parameters

Figure 13-3 Use Case Diagram: Register through the Database with JDBC Connection Parameters

Text description of the illustration adq13jad23.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

Register a queue/topic connection factory through the database with JDBC connection parameters to LDAP.

Usage Notes

registerConnectionFactory is a static method. To successfully register the connection factory, the DB connection passed to registerConnectionFactory must be granted AQ_ADMINISTRATOR_ROLE. After registration, look up the connection factory using JNDI.

Syntax

See Java (JDBC): Oracle9i Supplied Java Packages Reference, oracle.jms, AQjmsFactory.registerConnectionFactory.

Example

String               url;
java.sql.connection  db_conn;

url = "jdbc:oracle:thin:@sun-123:1521:db1";
db_conn = DriverManager.getConnection(url, "scott", "tiger");
AQjmsFactory.registerConnectionFactory(db_conn, "queue_conn1", "sun-123",
				       "db1", 1521, "thin", "queue");