user manual

236 BES Developer’s Guide
Defining the Connection Pool Properties for a JDBC Datasource
resSharingSc
ope
Enumerat
ed:
■ Shareab
le
■ Unshare
able
Indicates whether
connection
statements and
result sets are
cached for reuse --
Shareable -- thereby
optimizing
throughput of
connections. If set to
Unshareable,
connections are
closed once the
application closes
the connection.
Shareabl
e
maxPrepa
redState
mentCach
eSize
Integer Each connection
within a BES
JDBC pool
caches
java.sql.Prepared
Statement objects
for reuse.
Each
PreparedStatement
cache is
organized by SQL
literal strings
representing
unique SQL
statement
requests.
This property
limits the number
of
PreparedStatements
cached per
pooled JDBC
connection. It
specifies the
maximum size of
the cache. If a
cache reaches the
limit, any
subsequent
javax.sql.Connecti
on.prepareStatemen
t() calls result in
non-cached
instances of
PreparedStatement
objects being
created and
returned to the
caller. The
lifecycle of the
cache is the same
as the JDBC
connection
lifecycle. For
example, if an idle
connection times
out, both the
connection and its
PreparedStatement
cache are
discarded.
Unresolved
parameterized
SQL statements
are cached, for
example, the
statement SELECT
NAME FROM CUSTOMER
WHERE AGE=20 is
cached as SELECT
NAME FROM CUSTOMER
WHERE :age=
'
?
'
40
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