Chapter 3 | Section 3.5 |
Setting Properties of the JDBC/ODBC eWay | eWay Environment Properties |
Table 9 Outbound non-Transactional eWay —JDBC Connector Settings (Continued)
Name | Description | Required Value |
|
|
|
MaxPoolSize | Specifies the maximum number of | A valid numeric value. The default is |
| physical connections the pool | 10. |
| should keep available at all times. 0 |
|
| (zero) indicates that there is no |
|
| maximum. |
|
| If the pool size is too big, you may |
|
| end up with too many connections |
|
| with the database. The pool size |
|
| depends on the transaction volume |
|
| and response time. |
|
|
|
|
MaxIdleTime | Specifies the maximum number of | A valid numeric value. The default is 0. |
| seconds that a physical connection |
|
| may remain unused before it is |
|
| closed. 0 (zero) indicates that there is |
|
| no limit. |
|
|
|
|
Connection Retry Settings
Details for the Connection Retry Settings used by the external database are detailed in Table 10.
Table 10 Outbound non-Transactional eWay—Connection Retry Settings
Name | Description | Required Value |
|
|
|
ConnectionRetries | Specifies the number of retries to | A valid numeric value. The |
| establish a connection upon failure | default is 0. |
| to acquire one. |
|
|
|
|
ConnectionRetryInterval | Specifies the milliseconds of pause | A valid numeric value. The |
| before each attempt to reaccess the | default is 1000. |
| database. This setting is used in |
|
| conjunction with the 'Connection |
|
| Retries' setting. |
|
| For example: In the event that the |
|
| eWay cannot connect to the |
|
| Database, the eWay will try to |
|
| reconnect to the database 10 times |
|
| in 5 seconds apart when the |
|
| Connection Retries is 10 and the |
|
| Connection Retry Interval is 5000 |
|
|
|
|
3.5.4Outbound XA JDBC eWay Properties
The Outbound XA JDBC eWay includes the following configuration sections:
JDBC Connector Settings
JDBC/ODBC eWay Adapter User’s Guide | 37 | Sun Microsystems, Inc. |