[Proxool-developer] Disconnect problem with oracle database.
UNMAINTAINED!
Brought to you by:
billhorsman
Menu
▾
▴
[Proxool-developer] Disconnect problem with oracle database.
|
From: <Do...@ma...> - 2007-05-14 08:20:09
|
<html><body> <p><tt>Dear all,<br> </tt><br> <br> <tt>We development a web application on OC4J. Database is Oracle 10g.<b= r> </tt><tt>We connect to Oracle DB via proxool 0.9.0 as a db pool.<br> </tt><tt>Following is the setting of proxool :<br> </tt><br> <tt>jdbc-0.proxool.driver-class=3Dsun.jdbc.odbc.JdbcOdbcDriver<br> </tt><tt>jdbc-0.proxool.maximum-connection-count=3D8<br> </tt><tt>jdbc-0.proxool.maximum-connection-lifetime=3D1800000<br> </tt><tt>jdbc-0.proxool.prototype-count=3D8<br> </tt><tt>jdbc-0.proxool.house-keeping-test-sql=3Dselect CURRENT_DATE fr= om dual<br> </tt><tt>jdbc-0.proxool.verbose=3Dtrue<br> </tt><tt>jdbc-0.proxool.statistics=3D1h,1d<br> </tt><tt>jdbc-0.proxool.statistics-log-level=3D INFO<br> </tt><br> <tt>We set maximum 8 connection.<br> </tt><tt>But it appeared total connections is 10 on application server = after it running 2 days.<br> </tt><br> <br> <tt>After we checked. When it created more 2 connection, application ha= d not do any thing.<br> </tt><br> <tt>The Case :<br> </tt><tt>Application in idle. None of user used it.<br> </tt><tt>04:15.44 Proxool connect 8 connection, total =3D 8<br> </tt><tt>04:30.00 Proxool disconnect 7 connection, total =3D 8<br> </tt><tt>04:30.01 Proxool connect 7 connection, total =3D 8<br> </tt><tt>04:45.23 Proxool connect 1 connection, total =3D 8 <-------= ( it is 8 connections in proxool, but it is 9 connections in oc4j )<br= > </tt><br> <tt>It seems sometime it can not disconnect from oracle or have not dis= connect.<br> </tt><tt>It is counted 8 in proxool. but it is counted 10 in OC4j .<br>= </tt><tt>It seems problem at housekeeper or lifetime timeout.<br> </tt> <ul><tt>Thank you for attention.<br> </tt></ul> <tt>Regards,<br> </tt><br> <tt>Macro Systems Limited<br> </tt><tt>Douglas Huang<br> </tt><tt>---<br> </tt><tt><a href=3D"http://www.macro.com.hk****************************= ***********************************************">http://www.macro.com.h= k**********************************************************************= *****</a><br> </tt><tt>The information contained in this message may be privileged an= d confidential and protected from disclosure. Any dissemination, distri= bution, copying of or taking of any action in reliance upon this messag= e, other than to/by the addressee, is strictly prohibited.<br> </tt><tt>If you have received this in error, please destroy it and noti= fy us immediately. Opinions, conclusions and other information in this = message that do not relate to the official business of our company shal= l be understood as neither given nor endorsed by it and we disclaim all= liability for any such statements.<br> </tt><tt>**************************************************************= ***************</tt><br> </body></html>= |
