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.

Page 37
Image 37
Sun Microsystems JDBC/ODBC Adapter manual Outbound XA Jdbc eWay Properties