Outbound Oracle Applications Adapter Properties (Configuring Java CAPS Environment Components for Application Adapters)

Configuring Java CAPS Environment Components for Application Adapters

Outbound Oracle Applications Adapter Properties

The Outbound Oracle Applications Adapter properties, accessed from the Environment Explorer tree, are organized into the following sections:

JDBC Connector Settings

The JDBC Connector Settings section of the Outbound Oracle Applications Environment contains the top-level parameters displayed in the following table.

Table 1 Outbound Adapter Environment JDBC Connector Settings


Name	Description	Required Value
Description	Enter a description for the database.	A valid string.
ServerName	Specifies the host name of the external database server.	Any valid string.
DatabaseName	Specifies the name of the database instance used on the Server.	Any valid string.
PortNumber	Specifies the I/O port number on which the server is listening for connection requests.	A valid port number. The default is 1521.
User	Specifies the user name that the Adapter uses to connect to the database.	Any valid string.
Password	Specifies the password used to access the database.	Any valid string.
DriverProperties	Use the JDBC driver that is shipped with this Adapter. Often times the DataSource implementation needs to execute additional methods to assure a connection. You must identify the additional methods in the Driver Properties.	Any valid delimiter. Valid delimiters are: “<method-name-1>#<param-1>#<param-2>##.........<param-n>##<method-name-2>#<param-1>#<param-2>#........<param-n>##......##” For example: to execute the method setURL, give the method a String for the URL “setURL#<url>##”.
Delimiter	This is the delimiter character to be used in the DriverProperties prompt.	The default is #.
TNSEntry	Specifies the TNS name for the Oracle instance specified in TNSNAMES.ORA. If a TNS name is specified, then the OCI driver is used, which further requires installation of the Oracle client. If a TNS name is not specified, then the thin driver is used.	A valid TNS name if using the OCI driver; otherwise do not enter any value.
MinPoolSize	The minimum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there are no physical connections in the pool and new connections are created as needed.	A valid numeric value. The default is 2.
MaxPoolSize	The maximum number of physical connections the pool keeps available at all times. 0 (zero) indicates that there is no maximum.	A valid numeric value. The default is 10.
MaxIdleTime	The maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit.	A valid numeric value.

Connection Retry Settings

The Connection Retry Settings section of the Outbound Oracle Applications Environment contains the top-level parameters displayed in the following table.

Table 2 Outbound Adapter Environment Connection Retry Settings


Name	Description	Required Value
ConnectionRetries	Specifies the number of retries to establish a connection with the Oracle database upon a failure to acquire one.	An integer indicating the number of attempts allowed to establish a connection. The configured default is 0.
ConnectionRetry Interval	Specifies the configured length of the pause before each reattempt to access the destination file. This property is used in conjunction with the property ConnectionRetries.	An integer indicating the configured length of the time (in milliseconds) before each reattempt to access the destination file. The configured default is 1000 (1 second).