Sun Microsystems JDBC/ODBC Adapter manual Outbound XA Jdbc eWay-Connection Retry Settings

Chapter 3	Section 3.5
Setting Properties of the JDBC/ODBC eWay	eWay Environment Properties

Table 11 Outbound XA JDBC eWay—JDBC Connector Settings (Continued)

Name	Description	Required Value
DataSource	Specifies the name of the	The name of the XADataSource
name	XADataSource implementation, to	implementation. This property is
	which the DataSource object	Optional. In most cases, leave this box
	delegates behind the scenes when	empty.
	there is connection pooling or
	distributed transaction management
	being done.
MinPoolSize	Specifies the maximum number of	A valid numeric value. The default is 0.
	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.
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 12.

Table 12 Outbound XA JDBC 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.

JDBC/ODBC eWay Adapter User’s Guide 39 Sun Microsystems, Inc.