user manual

Chapter 22: Using JDBC 233
Defining the Connection Pool Properties for a JDBC Datasource
value> elements shown above. The complete list of properties, allowed values,
defaults, and descriptions appear in the following table:
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
optimizeXA Boolean By default,
XAResource calls
are limited to
optimize JDBC 2
connection pool
performance.
Setting optimizeXA
to false disables this
optimization. Under
certain conditions
the optimization
must be disabled.
For instance when
conflicts arise with
resource manager
optimizations during
two-phase commit
protocol.
True maxPoolS
ize
Integer Specifies the
maximum number
of database
connections that
can be obtained
from this
datasource
connection pool.
0 (zero),
implying
unbounded size
waitTimeout Integer The number of
seconds to wait for a
free connection
when maxPoolSize
connections are
already opened.
When using the
maxPoolSize
property and the
pool is at its max
and can't serve any
more connections,
the threads looking
for JDBC
connections end up
waiting for the
connection(s) to
become available
for a long time if the
wait time is
unbounded (set to 0
seconds). You can
set the waitTimeout
period to suit your
needs.
30 busyTime
out
Integer The number of
seconds to wait
before a busy
connection is
released
600 (ten
minutes)