Informix Adapter Environment Properties
The Adapter Environment Configuration properties contain parameters that define how the adapter connects
to and interacts with other Enterprise Service Bus components within the Environment. When
you create a new Informix External System, you may configure the type of
External System required.
Available External System properties include:
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 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
|
|
|
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
|
|
|
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. 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#. |
A list of properties with their parameters. The format is (with
no spaces): <method-name-1># <param-1>#<param-2>#... <param-n>## <method-name-2># <param-1>#<param-2>#... <param-n>## |
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
|
|
|
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 non-Transactional 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 non-Transactional Adapter.
Table 31 Outbound non-Transactional Informix Adapter External System JDBC Connector Settings
|
|
|
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. 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##. |
A list of properties with their parameters. The format
is (with no spaces): <method-name-1># <param-1>#<param-2>#... <param-n>## <method-name-2># <param-1>#<param-2>#... <param-n>## |
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
|
|
|
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
|
|
|
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. 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## |
A list of properties with their parameters. The format
is (with no spaces): <method-name-1># <param-1>#<param-2>#... <param-n>## <method-name-2># <param-1>#<param-2>#... <param-n>## |
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
|
|
|
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. |
|