If there are tables with huge volume of records and in order to limit the query execution to "x" seconds, add the following property in jdbc.xml file.
<jdbc-connection-pool-params>
<test-connections-on-reserve>true</test-connections-on-reserve>
<test-table-name>dual</test-table-name>
<statement-timeout>60</statement-timeout>
</jdbc-connection-pool-params>
This specifies how long the connection can be unused before the connection is abandoned. The connection timeout is in secs.
Please check foll. Oracle documentation for more:
http://docs.oracle.com/cd/E13222_01/wls/docs103/jdbc_admin/jdbc_datasources.html#wp1170721
<jdbc-connection-pool-params>
<test-connections-on-reserve>true</test-connections-on-reserve>
<test-table-name>dual</test-table-name>
<statement-timeout>60</statement-timeout>
</jdbc-connection-pool-params>
This specifies how long the connection can be unused before the connection is abandoned. The connection timeout is in secs.
Please check foll. Oracle documentation for more:
http://docs.oracle.com/cd/E13222_01/wls/docs103/jdbc_admin/jdbc_datasources.html#wp1170721
No comments:
Post a Comment