Generic - Queue Connector (Out) - Oracle AQ
Search form
Description - Generic to configure a Oracle AQ sending queue
Parameter Groups
Parameter Type Description
* SID: string SID of server connection
Host: string Host of server connection
Port: integer Port to use for server connection
* Driver: string Driver to use for server connection
Select from one of the following options:
- Thin {thin}
* - denotes required
Parameter Type Description
* Type string Connect using JMS API or older Oracle AQ API
Select from one of the following options:
- AQ {aq}
- JMS {jms}
User ID: string User logon id at broker
Password: password User's password at the broker machine
* Table Owner/Schema: string Usually the same as the Login
Table Name: string Table in which queue resides, necesary to create table if it does not exist already
* - denotes required
Parameter Type Description
* Name: string Name of the input queue to be monitored
Type: string Select queue for point-to-point or topic for publish-and-subscribe
Select from one of the following options:
- Queue {queue}
- Topic {topic}
Owner: string Name of the owner of the queue
* - denotes required
Parameter Type Description
Hosts: string Enter additional hosts for RAC failover/load balancing (host1:port,host2:port,host3:port)
Loadbalance: boolean Use RAC connection for load balancing
Failover: boolean Use RAC connection for failover
* - denotes required
Parameter Type Description
Min Connections: integer The minimum number of connections to the queue to be held in the cache
Max Connections: integer The maximum number of connections to the queue to be held in the cache
Initial: integer The initial number of connections to create in the cache
Inactive Timeout: integer The maximum time a cached physical connection can remain idle
Abandoned Timeout: integer The maximum time that a connection can remain unused before the connection is closed and returned to the cache
Maximum Statements: integer The maximum number of statements that a connection keeps open
Property Interval: integer Sets the time interval at which the cache manager inspects and enforces all specified cache properties
* - denotes required
Parameter Type Description
Payload Class string When using custom defined objects, specify a class that is in the classpath
Payload Object string When using custom defined objects, specify the oracle object the class will map to. Owner of the schema will be prepended
ONS Hosts string Hosts emitting ONS information, ie host:port,host:port
* - denotes required
Parameter Groups
Parameter | Type | Description | |
---|---|---|---|
* | SID: | string | SID of server connection | Host: | string | Host of server connection | Port: | integer | Port to use for server connection | * | Driver: | string | Driver to use for server connection
Select from one of the following options:
|
* - denotes required
Parameter | Type | Description | |
---|---|---|---|
* | Type | string | Connect using JMS API or older Oracle AQ API
Select from one of the following options:
|
User ID: | string | User logon id at broker | Password: | password | User's password at the broker machine | * | Table Owner/Schema: | string | Usually the same as the Login | Table Name: | string | Table in which queue resides, necesary to create table if it does not exist already |
* - denotes required
Parameter | Type | Description | |
---|---|---|---|
* | Name: | string | Name of the input queue to be monitored | Type: | string | Select queue for point-to-point or topic for publish-and-subscribe
Select from one of the following options:
|
Owner: | string | Name of the owner of the queue |
* - denotes required
Parameter | Type | Description | |
---|---|---|---|
Hosts: | string | Enter additional hosts for RAC failover/load balancing (host1:port,host2:port,host3:port) | Loadbalance: | boolean | Use RAC connection for load balancing | Failover: | boolean | Use RAC connection for failover |
* - denotes required
Parameter | Type | Description | |
---|---|---|---|
Min Connections: | integer | The minimum number of connections to the queue to be held in the cache | Max Connections: | integer | The maximum number of connections to the queue to be held in the cache | Initial: | integer | The initial number of connections to create in the cache | Inactive Timeout: | integer | The maximum time a cached physical connection can remain idle | Abandoned Timeout: | integer | The maximum time that a connection can remain unused before the connection is closed and returned to the cache | Maximum Statements: | integer | The maximum number of statements that a connection keeps open | Property Interval: | integer | Sets the time interval at which the cache manager inspects and enforces all specified cache properties |
* - denotes required
Parameter | Type | Description | |
---|---|---|---|
Payload Class | string | When using custom defined objects, specify a class that is in the classpath | Payload Object | string | When using custom defined objects, specify the oracle object the class will map to. Owner of the schema will be prepended | ONS Hosts | string | Hosts emitting ONS information, ie host:port,host:port |