Sun Microsystems JDBC/ODBC Adapter manual Connection Retry Settings

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

Table 7 Outbound JDBC eWay—JDBC Connector Settings (Continued)

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

Table 8 Outbound 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 34 Sun Microsystems, Inc.