Oracle Applications Adapter Environment Properties

The Oracle Applications Adapter configuration parameters, accessed from the NetBeans Services window, are organized into the following sections:

Outbound Oracle Applications Adapter Properties.
Outbound Oracle Adapter Properties with XA support.

Outbound Oracle Applications Adapter Properties

The Outbound Oracle Applications Adapter properties are organized into the following sections:

JDBC Connector Settings.
Connection Retry Settings.

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. For example: to execute the method setURL, give the method a String for the URL “setURL#<url>##”.	A list of driver properties. The format is: “<method-name-1>#<param-1>#<param-2>##...<param-n>##<method-name-2>#<param-1>#<param-2>#...<param-n>##....##”
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).

Outbound Oracle Adapter Properties with XA support

The Outbound Oracle Applications Adapter properties with XA support are organized into the following sections:

JDBC Connector Settings (with XA support).
Connection Retry Settings (with XA support).

JDBC Connector Settings (with XA support)

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

Table 3 Outbound XA 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.
PortNumber	Specifies the I/O port number on which the server is listening for connection requests.	A valid port number. The default is 1521.
DatabaseName	Specifies the name of the database instance used on the Server.	Any valid string.
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. For example: to execute the method setURL, give the method a String for the URL “setURL#<url>##”.	A list of driver properties. The format is: “<method-name-1>#<param-1>#<param-2>##....<param-n>##<method-name-2>#<param-1>#<param-2>#...<param-n>##...##”
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 (with XA support)

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

Table 4 Outbound XA 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).

Skip Navigation Links
Exit Print View
	Configuring Environment Components for Oracle Java CAPS Application Adapters Java CAPS Documentation