connection pool
YEDec 1 2009 — edited Apr 13 2010There are about 40 people including 30 programmers and 10 testers in a team. They use Jdeveloper 11.1.1.2, weblogic 10.3.2.0, and oracle 10g.
The max connection pool is 500.
The code snippets are as follow.
1, (ApplicationModule)JSFUtils.resolveExpression("#{data." + name +".dataProvider}");
2, The ViewObject is used by ApplicationModule and rows of VO are changed.
3, ApplicationModule is used in backing bean for commit and rollback.
4, ViewRowImpl:
public class DistressInfoByzcbhViewRowImpl extends ViewRowImpl {
….
public String getSomething(){
SysCodeAMImpl codeAm=(SysCodeAMImpl)Configuration.createRootApplicationModule("com.sunz.model.am.commonmodule.SysCodeAM", "SysCodeAMLocal");
….
Configuration.releaseRootApplicationModule(codeAm, true);
….
}
}
==================================
After running the page http://127.0.0.1:7101/DL-viewcontroller-context-root/faces/portalDaiban?_afrLoop=31082873706450&_adf.ctrl-state=1qme8hi02_14
the connection pool will increase if the page is refreshed.
After the page http://127.0.0.1:7101/goldland-viewcontroller-context-root/faces/portalDaiban
runs, if the page is refreshed the connection pool number will increase 1 each time.
Sometime, the connection pool number will increase 0 to 4 if the page is reloaded.
After all browsers are closed, the connection pool is still high.
I want the connection pool number can be stable and not increase.