we set up the
JDBC Connection pool as below:
<JDBCConnectionPool
Name="ejb-pool"
CapacityIncrement="2"
DriverName="oracle.jdbc.driver.OracleDriver"
InitialCapacity="30"
MaxCapacity="100"
Properties="user=xxxx;password=xxxxx"
ShrinkingEnabled="true"
URL="jdbc:oracle:thin:@//xxxxxx1521/xxxxx"
TestTableName="SQL select 1 from /*wl:jdbc:ejb-pool*/dual"
TestConnectionsOnReserve="true"
ConnLeakProfilingEnabled="false"
StatementCacheSize="10"
Targets="myservers
/>
It takes 15 seconds create each single connection, E.g, by settings, it should init 30 connections when starting up weblogic; and it the log file, we noticed that it takes 15s to create each one:
####<Aug 17, 2014 4:59:26 AM GMT> <Info> <JDBC> <eng-xps5> <ncs0> <main> <<WLS Kernel>> <> <BEA-001068> <Connection for pool "ejb-pool" created.>
####<Aug 17, 2014 4:59:26 AM GMT> <Info> <JDBC> <eng-xps5> <ncs0> <main> <<WLS Kernel>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "ejb-pool".>
####<Aug 17, 2014 4:59:41 AM GMT> <Info> <JDBC> <eng-xps5> <ncs0> <main> <<WLS Kernel>> <> <BEA-001068> <Connection for pool "ejb-pool" created.>
####<Aug 17, 2014 4:59:41 AM GMT> <Info> <JDBC> <eng-xps5> <ncs0> <main> <<WLS Kernel>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "ejb-pool".>
####<Aug 17, 2014 4:59:57 AM GMT> <Info> <JDBC> <eng-xps5> <ncs0> <main> <<WLS Kernel>> <> <BEA-001068> <Connection for pool "ejb-pool" created.>
####<Aug 17, 2014 4:59:57 AM GMT> <Info> <JDBC> <eng-xps5> <ncs0> <main> <<WLS Kernel>> <> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "ejb-pool".>
I'm wondering is there any attribute which may cause this issue in weblogic settings?
Basically this issue only happens on our production environment which is using Oracle ODA (Oracle Database Appliance) database;
This setting works fine for our
testing and developing environment which is a normal Oracle DB;
We thought it might be the ODA settings; but we have another application which is running with Jetty Apache Datasource:
<New class="org.apache.commons.dbcp.BasicDataSource">
<Set name="driverClassName">oracle.jdbc.driver.OracleDriver</Set>
<Set name="url">jdbc:oracle:thin:@xxxxxx1521:xxxxx</Set>
<Set name="username">xxxx</Set>
<Set name="password">xxxx</Set>
<Set name="initialSize">10</Set>
<Set name="maxActive">100</Set>
<Set name="maxIdle">50</Set>
<Set name="minIdle">10</Set>
</New>
And this one is working fine, that means this is not the ODA issue;
So I'm wondering is there any settings in weblogic which may cause this issue?