Sybase 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 Sybase External System, you may configure the type of
External System required.
Available External System properties include:
Inbound Sybase Adapter
Details for the Inbound Sybase Adapter Parameter Settings are listed in the following
table.
Table 47 Inbound Sybase Adapter—Parameter Settings
|
|
|
|---|
|
The description of the database. |
A valid string. |
|
Specifies the host name of
the external database server. |
Any valid string.
Note - The Sybase Adapter does not support using
“localhost” as the server name.
|
|
Specifies the I/O port number on which the server
is listening for connection requests. |
A valid port number. The default is 4100. |
|
Specifies the
name of the database instance. |
Any valid string. |
|
Specifies the user name the adapter
uses to connect to the database. |
Any valid string. |
|
Specifies the password used to
access the database. |
Any valid string. |
|
Outbound Sybase Adapter
The Outbound Sybase Adapter includes the following configuration sections:
JDBC Connector Settings
The following Parameter Settings are used by the external database.
Table 48 Outbound Sybase Adapter—JDBC Connector Settings
|
|
|
|---|
|
The description
of the database. |
A valid string. |
|
This setting specifies the host name of the
external database server. |
Any valid string.
Note - The Sybase Adapter does not support using “localhost” as the
server name.
|
|
Specifies the I/O port number on which the server is listening for
connection requests. |
A valid port number. The default is 4100. |
|
Specifies the name of
the database instance. |
Any valid string. |
|
Specifies the user name the adapter uses to
connect to the database. |
Any valid string. |
|
Specifies the password used to access the
database. |
Any valid string. |
|
The DataSource implementation may need to execute additional methods to assure
a successful run. The additional methods need to be identified in the Driver
Properties. For example: to execute the method setSpyAttributes, give the method a String for
the URL “setSpyAttribute#<url>##”.
Note - The setSpyAttributes (for Data Direct drivers) that are 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.
Optional—if
you are using Spy Log: setURL#jdbc:Seebeyond:Sybase://<server>: 4100;DatabaseName=<database>## setSpyAttributes#log=(file) c:/temp/spy.log;logTName=yes## |
A list of methods with their parameters. For
more information, see the Delimiter property below. The default format is: (with no spaces): <method-name-1># <param-1>#<param-2>#... <param-n>## <method-name-2># <param-1>#<param-2>#... <param-n>## |
|
This
is the delimiter character to be used in the DriverProperties prompt. |
The default is
#. See the DriverProperties property above for more information on how the default value
is used. |
|
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. If the
pool size is too small, you may experience a longer connection time due
to the existing number of physical connections. A connection that stays in the
pool allows transactions to use it via a logical connection which is faster. |
A
valid numeric value. The default is 0. |
|
Specifies the maximum number of physical
connections the pool should keep available at all times. 0 (zero) indicates that
there is no maximum. The pool size you set depends on the transaction volume
and response time of the application. If the pool size is too big,
you may end up with too many connections with the database. |
A valid numeric
value. The default is 10. |
|
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. |
|
Connection Retry Settings
The following Parameter Settings are used by the external database.
Table 49 Outbound Sybase Adapter—Connection Retry Settings
|
|
|
|---|
|
Specifies the
number of retries to establish a connection upon failure to acquire one. |
A valid
numeric value. The default is 0. |
|
Specifies the milliseconds of pause before each
attempt to access the database. This setting is used in conjunction with the
’Connection Retries’ setting. For example: In the event that the adapter cannot connect to the
Database, the adapter will try to reconnect to the database 10 times in
5 seconds intervals when the Connection Retries is 10 and the Connection Retry
Interval is 5000. |
A valid numeric value. The default is 1000. |
|
Outbound XA Sybase Adapter
The Outbound XA Sybase Adapter includes the following configuration sections:
JDBC Connector Settings
The following Parameter Settings are used by the external database.
Table 50 Outbound XA Sybase Adapter—JDBC Connector Settings
|
|
|
|---|
|
The description
of the database. |
Any valid string. |
|
Specifies the host name of the external database
server. |
Any valid string.
Note - The Sybase Adapter does not support using “localhost” as the server
name.
|
|
Specifies the I/O port number on which the server is listening for connection
requests. |
A valid port number. The default is 4100. |
|
Specifies the name of the
database instance. |
Any valid string. |
|
Specifies the user name the adapter uses to connect
to the database. |
Any valid string. |
|
Specifies the password used to access the database. |
Any
valid string. |
|
The DataSource implementation may need to execute additional methods to assure a
successful run. The additional methods need to be identified in the Driver Properties. For
example: to execute the method setSpyAttributes, give the method a String for the
URL “setSpyAttribute#<url>##”.
Note - The setSpyAttributes (for Data Direct drivers) that are 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.
Optional—if you
are using Spy Log: setURL#jdbc:Seebeyond:Sybase://<server>: 4100;DatabaseName=<database>## setSpyAttributes#log=(file) c:/temp/spy.log;logTName=yes## |
A list of methods with their parameters. For more
information, see the Delimiter property below. The default format is (with no spaces): <method-name-1># <param-1>#<param-2>#... <param-n>## <method-name-2># <param-1>#<param-2>#... <param-n>## |
|
This
is the delimiter character to be used in the DriverProperties prompt. |
The default is
#. |
|
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. |
|
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. |
|
Specifies the 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. |
|
Connection Retry Settings
The following Parameter Settings are used by the external database.
Table 51 Outbound XA Sybase Adapter—Connection Retry Settings
|
|
|
|---|
|
Specifies the
number of retries to establish a connection upon failure to acquire one. |
A valid
numeric value. The default is 0. |
|
Specifies the milliseconds of pause before each
attempt to access the database. This setting is used in conjunction with the
’Connection Retries’ setting. For example: In the event that the adapter cannot connect to the
Database, the adapter will try to reconnect to the database 10 times in
5 seconds intervals when the Connection Retries is 10 and the Connection Retry
Interval is 5000. |
A valid numeric value. The default is 1000. |
|
Outbound Sybase non-Transactional Adapter
The Outbound Sybase non-Transactional Adapter includes the following configuration sections:
JDBC Connector Settings
The following Parameter Settings are used by the external database.
Table 52 Outbound Sybase non-Transactional Adapter—JDBC Connector Settings
|
|
|
|---|
|
The description
of the database. |
Any valid string. |
|
Specifies the host name of the external database
server. |
Any valid string.
Note - The Sybase Adapter does not support using “localhost” as the server
name.
|
|
Specifies the I/O port number on which the server is listening for connection
requests. |
A valid port number. The default is 1521.
Note - The default port number displayed
in this field is incorrect. The value should be 4100.
|
|
Specifies the name
of the database instance. |
Any valid string. |
|
Specifies the user name the adapter uses
to connect to the database. |
Any valid string. |
|
Specifies the password used to access
the database. |
Any valid string. |
|
The DataSource implementation may need to execute additional methods to
assure a successful run. The additional methods need to be identified in the
Driver Properties. For example: to execute the method setSpyAttributes, give the method a String
for the URL “setSpyAttribute#<url>##”.
Note - The setSpyAttributes (for Data Direct drivers) that are 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.
Optional—if you are using Spy Log: setURL#jdbc:Seebeyond:Sybase://<server>: 4100;DatabaseName=<database>## setSpyAttributes#log=(file) c:/temp/spy.log;logTName=yes## |
A list of methods with their parameters.
For more information, see the Delimiter property below. The default format is (with no
spaces): <method-name-1># <param-1>#<param-2>#... <param-n>## <method-name-2># <param-1>#<param-2>#... <param-n>## |
|
This is the delimiter character to be used in the DriverProperties prompt. |
The default
is #. |
|
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. |
|
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. |
|
Specifies the 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. |
|
Connection Retry Settings
The following Parameter Settings are used by the external database.
Table 53 Outbound Sybase non-Transactional Adapter Adapter—Connection Retry Settings
|
|
|
|---|
|
Specifies the
number of retries to establish a connection upon failure to acquire one. |
A valid
numeric value. The default is 0. |
|
Specifies the milliseconds of pause before each
attempt to access the database. This setting is used in conjunction with the
’Connection Retries’ setting. For example: In the event that the adapter cannot connect to the
Database, the adapter will try to reconnect to the database 10 times in
5 seconds intervals when the Connection Retries is 10 and the Connection Retry
Interval is 5000. |
A valid numeric value. The default is 1000. |
|
