Database Reference
In-Depth Information
Default
Value
Tuned
Value
Parameter Name
Remarks
database terminates its connection. The
or-
acle.net.CONNECT_TIMEOUT
property, defined for
SOADataSource
, should be set to a larger value to overcome
these exceptions.
Establishing a JDBC connection with a DBMS can be very slow. If
the application requires database connections that are repeatedly
opened and closed, this can become a significant performance is-
sue. It is good to start with a high value of Initial Capacity, so that
connections are opened and available to all clients when the server
is first started.
Initial Capacity
5
50
The
MaxCapacity
attribute of the
JDBCConnectionPool
ele-
ment sets the maximum number of physical database connections
that a connection pool can contain. Tuning this to a higher value
means that if the connections available run out of the initial capa-
city, more are added.
Maximum Capacity
50
200
The database must be configured to support these number of pro-
cesses. Note that these are the number of connections from each
SOA server in your cluster. So, setting it to 200 in a 4-node cluster
may potentially result in 800 simultaneous connections to the data-
base.
