The following Parameter Settings are used by the external database.
Table 50 Outbound XA Sybase Adapter—JDBC Connector Settings
Name |
Description |
Required Value |
---|---|---|
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. |
|
If you choose to 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 methods to assure a connection. The additional methods will need to be identified in the Driver Properties. |
The delimiter set by the user. For more information, see the Delimiter property below. 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 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##” |
|
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. |