beautypg.com

Connection retry settings, 4 outbound xa jdbc eway properties, Outbound xa jdbc eway properties – Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 37

background image

Chapter 3

Section 3.5

Setting Properties of the JDBC/ODBC eWay

eWay Environment Properties

JDBC/ODBC eWay Adapter User’s Guide

37

Sun Microsystems, Inc.

Connection Retry Settings

Details for the Connection Retry Settings used by the external database are detailed in
Table 10.

3.5.4

Outbound XA JDBC eWay Properties

The Outbound XA JDBC eWay includes the following configuration sections:

ƒ

JDBC Connector Settings

MaxPoolSize

Specifies the maximum number of
physical connections the pool
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.

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 10 Outbound non-Transactional eWay—Connection Retry Settings

Name

Description

Required Value

ConnectionRetries

Specifies the number of retries to
establish a connection upon failure
to acquire one.

A valid numeric value. The
default is 0.

ConnectionRetryInterval

Specifies the milliseconds of pause
before each attempt to reaccess the
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

A valid numeric value. The
default is 1000.

Table 9 Outbound non-Transactional eWay —JDBC Connector Settings (Continued)

Name

Description

Required Value