user manual

Chapter 22: Using JDBC 235
Defining the Connection Pool Properties for a JDBC Datasource
reuseStateme
nts
Boolean Optimization
directive requesting
prepared SQL
statements to be
cached for reuse.
Applies to all
connections
obtained from the
connection pool.
True initSQL String Specifies a list of
";" separated SQL
statements to be
executed each
time a connection
is obtained for a
fresh transaction.
The SQL is
performed before
any application
work is performed
on the connection.
This property is
optional. There
is no default
value.
refreshFrequ
ency
Integer Using dbPingSQL, this
property specifies a
timeout, in seconds,
for each connection
in an idle state.
Once the timeout
expires, the
connection is
examined to
determine if it is still
a valid connection.
All idle connections
are checked for
refreshFrequency at
sixty second
intervals.
300 (five
minutes
)
dbPingSQ
L
String Specifies a SQL
statement used to
validate open
connections
present in the
connection pool
and to refresh
connections
during a
refreshFrequency
timeout.
Not defined.
When no SQL
is specified, the
container uses
java.sql.Connect
ionisClosed()
method to
validate the
connection.
Name
Allowed
Values
Description
Default
Value
connect
ionType
Enumera
ted:
■ Direct
■ XA
Indicates type
transaction
association of all
connections
retrieved from the
connection pool,
whether "Direct"
or "XA"
Not Applicable.
Property
specification is
mandatory