Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connection pool

YEDec 1 2009 — edited Apr 13 2010
There 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2010
Added on Dec 1 2009
15 comments
1,536 views