Hi Paul,
Thanks for replying.
First of all we are not using JDBC BC .
we are doing all CRUD operations from java.
we re using all connection related properties from context.xml in which in
defining.
In Open ESB 2.2 code was working fine but after migrating to OPENESB 3
standalone CRUD operation is working slow.
Here is parameter of context.xm file we define for connection.
<dataSource-pool-properties>
<dbConnector-name>oracleESBPool</dbConnector-name>
<datasource-classname>oracle.jdbc.xa.client.OracleXADataSource</datasource-classname>
<resource-type>Datasource</resource-type>
<database-name>Oracle</database-name>
<database-vendor>Oracle</database-vendor>
<database-version>11</database-version>
<dbconnector-description>DBConnector for Oracle
XA</dbconnector-description>
<dataSource-properties>
<property>
<name>user</name>
<value>XXXXXXX</value>
<description></description>
</property>
<property>
<name>password</name>
<value>XXXXX</value>
<description></description>
</property>
<property>
<name>serverName</name>
<value>XXXXX</value>
<description></description>
</property>
<property>
<name>portNumber</name>
<value>XXXX</value>
<description></description>
</property>
<property>
<name>databaseName</name>
<value>XXXXXX</value>
<description></description>
</property>
<property>
<name>driverType</name>
<value>thin</value>
<description></description>
</property>
</dataSource-properties>
<pool-properties>
<property>
<name>initialSize</name>
<value>10</value>
<description></description>
</property>
<property>
<name>maxActive</name>
<value>20</value>
<description></description>
</property>
<property>
<name>maxIdle</name>
<value>9</value>
<description></description>
</property>
<property>
<name>minIdle</name>
<value>9</value>
<description></description>
</property>
<property>
<name>testOnCreate</name>
<value>false</value>
</property>
<property>
<name>testOnBorrow</name>
<value>true</value>
</property>
<property>
<name>testOnReturn</name>
<value>false</value>
</property>
<property>
<name>testWhileIdle</name>
<value>false</value>
</property>
<property>
<name>numTestsPerEvictionRun</name>
<value>3</value>
</property>
<property>
<name>lifo</name>
<value>true</value>
</property>
<property>
<name>maxConnLifetimeMillis</name>
<value>120000</value>
</property>
</pool-properties>
</dataSource-pool-properties>
Thanks,
Nikhil
--
Sent from:
http://openesb-community-forum.794670.n2.nabble.com/