Thursday, November 28, 2013

How to set JDBC connection pool in WEBLOGIC Manually

JDBC connection pool in WEBLOGIC SERVER Manually:

These attributes are used to set the jdbc connection settings

Initial Capacity:
The no of physical db connections to create when creating the connection pool
Min:0
Max:2147483647
Default:1
Attribute:IntialCapacity

Maximum Capacity:
Max no. of physical db connections that contain in connection pool. Different JDBC drivers and db servers may limit the no .of possible physical connections
Min:1
Max:2147483647
Default:15
Attribute:MaxCapacity

Capacity Increment:
Increment by which the connection pool capacity is expanded. When there are no more avilablae physical connections to service requests, the connection pool will create this number of additional physical db connections add them to the connection pool.

Min:0
Max:2147483647
Default:1
Attribute:CapacityIncrement

To set these values in Weblogic manually

To open the file Jdbc_Data_source_0_3401_jdbc.xml in
D:\oracle weblogic\middleware\user_projects\domains\base_domains\config\jdbc



1
15
1
300
SQL SELECT 1 FROM DUAL
10
LRU
1