Configuring Java CAPS Environment Components for Database Adapters

Informix Adapter External System Properties

Adapter External System properties must be configured from within the Environment. Until you have successfully configured all adapters for your Java CAPS project, your project cannot be properly executed. The following list identifies the Informix Adapter properties. There are four adapter connection types that the Informix Adapter implements.

Inbound Adapter

Table 28
Outbound Adapter
- Table 29
- Table 30
Outbound non-Transactional Adapter
- Table 31
- Table 32
Outbound XA Adapter
- Table 33
- Table 34

Inbound Informix Adapter External System Properties

Before deploying your adapter, you will need to set the Environment properties. This section describes the External System properties used by the Inbound Informix Adapter.

Details for the Inbound Informix Adapter Parameter Settings are listed in the following table.

Table 28 Inbound Informix Adapter External System Parameter Settings


Name	Description	Required Value
Description	The description of the database.	Any 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 1526.
InformixServer	Specifies the name of the Informix server being used.	Any valid string.
DatabaseName	Specifies the name of the database being used by the server.	Any valid string.
User	Specifies the user name the adapter uses to connect to the database.	Any valid string.
Password	Specifies the password used to access the database.	Any valid string.

Outbound Informix Adapter External System Properties

Before deploying your adapter, you will need to set the Environment properties. This section describes the External System properties used by the Outbound Informix Adapter.

Table 29 Outbound Adapter External System JDBC Connector Settings


Name	Description	Required Value
Description	Enter a description for the database. The default is INFORMIX Connection Pool Datasource.	Any 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 1526.
InformixServer	Specifies the name of the Informix server being used.	Any valid string.
DatabaseName	Specifies the name of the database being used by the server.	Any valid string.
User	Specifies the user name the adapter uses to connect to the database.	Any valid string.
Password	Specifies the password used to access the database.	Any valid string.
DriverProperties	Specifies the driver properties used for this adapter. If you choose not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional properties to assure a connection. The additional methods will need to be identified 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>##”. Note – The setSpyAttributes, contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion. “setURL#jdbc:SeeBeyond:informix://<host>1526;DatabaseName=<database>##setInformixServer#<informixserver>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”.
Delimiter	Specifies the delimiter character used in the DriverProperties prompt.	The default is #.
MinPoolSize	Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed.	A valid numeric value. The default is 0.
MaxPoolSize	Specifies the maximum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there is no maximum.	A valid numeric value. The default is 10.
MaxIdleTime	Specifies 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. The default is 0.

Table 30 Outbound Informix Adapter External System Connection Retry Settings


Name	Description	Required Value
ConnectionRetries	Specifies the number of retries to establish a connection upon initial failure.	A valid numeric value. The default is 0.
ConnectionRetryInterval	Specifies the number of milliseconds of pause before each reattempt to acces the destination file. This property is used in conjunction with the Connection Retries setting.	A valid numeric value. The default is 1000.

Outbound non-Transactional InformixAdapter External System Properties

Before deploying your adapter, you will need to set the Environment properties. This section describes the External System properties used by the Outbound Informix non-Transactional Adapter.

Table 31 Outbound non-Transactional Informix Adapter External System JDBC Connector Settings


Name	Description	Required Values
Description	Enter a description for the database. The default is INFORMIX non-Transactional Connection Pool Datasource.	Any 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 1526.
InformixServer	Specifies the name of the Informix server being used.	Any valid string.
DatabaseName	Specifies the name of the database being used by the server.	Any valid string.
User	Specifies the user name the adapter uses to connect to the database.	Any valid string.
Password	Specifies the password used to access the database.	Any valid string.
DriverProperties	Specifies the driver properties used for this adapter. If you choose not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional properties to assure a connection. The additional methods will need to be identified 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>##”. Note – The setSpyAttributes, contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion. “setURL#jdbc:SeeBeyond:informix://<host>1526;DatabaseName=<database>##setInformixServer#<informixserver>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”.
Delimiter	Specifies the delimiter character used in the DriverProperties prompt.	The default is #.
MinPoolSize	Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed.	A valid numeric value. The default is 0.
MaxPoolSize	Specifies the maximum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there is no maximum.	A valid numeric value. The default is 10.
MaxIdleTime	Specifies 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. The default is 0.

Table 32 Outbound non-Transactional Informix Adapter External System Connection Retry Settings


Name	Description	Required Value
ConnectionRetries	Specifies the number of retries to establish a connection upon initial failure.	A valid numeric value. The default is 0.
ConnectionRetryInterval	Specifies the number of milliseconds of pause before each reattempt to access the destination file. This property is used in conjunction with the Connection Retries setting.	A valid numeric value. The default is 1000.

Outbound XA Informix Adapter External System Properties

Before deploying your adapter, you will need to set the Environment properties. This section describes the External System properties used by the Outbound Informix XA Adapter.

Table 33 Outbound XA Informix Adapter External System JDBC Connector Settings


Name	Description	Required Value
Description	Enter a description for the database. The default is INFORMIX XA Connection Pool Datasource.	Any 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 1526.
InformixServer	Specifies the name of the Informix server being used.	Any valid string.
DatabaseName	Specifies the name of the database being used by the server.	Any valid string.
User	Specifies the user name the adapter uses to connect to the database.	Any valid string.
Password	Specifies the password used to access the database.	Any valid string.
DriverProperties	Specifies the driver properties used for this adapter. If you choose not to use the JDBC driver that is shipped with this adapter, you will need to add the drivers properties to the adapter. Often times the DataSource implementation will need to execute additional properties to assure a connection. The additional methods will need to be identified 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>##”. Note – The setSpyAttributes, contained in the following examples (between the last set of double octothorps [##] within each example), are used for debugging purposes and need not be used on every occasion. “setURL#jdbc:SeeBeyond:informix://<host>1526;DatabaseName=<database>##setInformixServer#<informixserver>##setSpyAttributes#log=(file)c:/temp/spy.log;logTName=yes##”.
Delimiter	Specifies the delimiter character used in the DriverProperties prompt.	The default is #.
MinPoolSize	Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there should be no physical connections in the pool and the new connections should be created as needed.	A valid numeric value. The default is 0.
MaxPoolSize	Specifies the maximum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there is no maximum.	A valid numeric value. The default is 10.
MaxIdleTime	Specifies 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. The default is 0.

Table 34 Outbound XA Informix Adapter External System Connection Retry Settings


Name	Description	Required Value
ConnectionRetries	Specifies the number of retries to establish a connection upon initial failure.	A valid numeric value. The default is 0.
ConnectionRetryInterval	Specifies the number of milliseconds of pause before each reattempt to access the destination file. This property is used in conjunction with the Connection Retries setting.	A valid numeric value. The default is 1000.