Generic - Queue Connector (Out) - Oracle AQ

Description - Generic to configure a Oracle AQ sending queue


Parameter Groups

 ParameterTypeDescription
*SID:stringSID of server connection
Host:stringHost of server connection
Port:integerPort to use for server connection
*Driver:stringDriver to use for server connection

Select from one of the following options:
  • Thin {thin}
* - denotes required
 ParameterTypeDescription
*TypestringConnect using JMS API or older Oracle AQ API

Select from one of the following options:
  • AQ {aq}
  • JMS {jms}
User ID:stringUser logon id at broker
Password:passwordUser's password at the broker machine
*Table Owner/Schema:stringUsually the same as the Login
Table Name:stringTable in which queue resides, necesary to create table if it does not exist already
* - denotes required
 ParameterTypeDescription
*Name:stringName of the input queue to be monitored
Type:stringSelect queue for point-to-point or topic for publish-and-subscribe

Select from one of the following options:
  • Queue {queue}
  • Topic {topic}
Owner:stringName of the owner of the queue
* - denotes required
 ParameterTypeDescription
Hosts:stringEnter additional hosts for RAC failover/load balancing (host1:port,host2:port,host3:port)
Loadbalance:booleanUse RAC connection for load balancing
Failover:booleanUse RAC connection for failover
* - denotes required
 ParameterTypeDescription
Min Connections:integerThe minimum number of connections to the queue to be held in the cache
Max Connections:integerThe maximum number of connections to the queue to be held in the cache
Initial:integerThe initial number of connections to create in the cache
Inactive Timeout:integerThe maximum time a cached physical connection can remain idle
Abandoned Timeout:integerThe maximum time that a connection can remain unused before the connection is closed and returned to the cache
Maximum Statements:integerThe maximum number of statements that a connection keeps open
Property Interval:integerSets the time interval at which the cache manager inspects and enforces all specified cache properties
* - denotes required
 ParameterTypeDescription
Payload ClassstringWhen using custom defined objects, specify a class that is in the classpath
Payload ObjectstringWhen using custom defined objects, specify the oracle object the class will map to. Owner of the schema will be prepended
ONS HostsstringHosts emitting ONS information, ie host:port,host:port
* - denotes required