user manual

234 BES Developer’s Guide
Defining the Connection Pool Properties for a JDBC Datasource
idleTimeout Integer A pooled connection
remaining in an idle
state for a period of
time longer than this
timeout value should
be closed. All idle
connections are
checked for
idleTimeout
expiration every 60
seconds. The value
of the idleTimeout is
given in seconds.
600 (ten
minutes
)
queryTim
eout
Integer Specifies in
seconds the time
limit for executing
database queries
by this
datasource.
0 (zero),
implying
indefinite period
dialect Enumerat
ed:
■ oracle
■ sybase
■ interba
se
■ jdatast
ore
Specifies the
database vendor as
a hint for automatic
table creation
performed during
Container Managed
Persistence
This
property
is
optional
. There
is no
default
value.
isolatio
nLevel
Enumerat
ed:
■ TRANSAC
TION_
NONE
■ TRANSAC
TION_
READ_
COMMI
TTED
■ TRANSAC
TION_
READ_
UNCOM
MITTE
D
■ TRANSAC
TION_
REPRE
ATABL
E_REA
D
■ TRANSAC
TION_
SERIA
LIZEA
BLE
Indicates
database isolation
level associated
with all
connections
opened by this
datasource's
connection pool.
See the J2EE 1.3
specification for
details on these
isolation levels.
Defaults to
whatever level
is provided by
the JDBC driver
vendor.
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