Thread: [Proxool-developer] Disconnect problem with oracle database.
UNMAINTAINED!
Brought to you by:
billhorsman
Menu
▾
▴
proxool-developer
|
From: <Do...@ma...> - 2007-05-14 06:21:16
|
<FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size= =3D2>Dear all,<br> <br> We development a web application on OC4J= . Database is Oracle 10g.<br> We connect to Oracle DB via proxool 0.9= .0 as a db pool.<br><br>Following is the setting of proxool :<br><br>jdbc-0= .proxool.driver-class=3Dsun.jdbc.odbc.JdbcOdbcDriver<br>jdbc-0.proxool.maxi= mum-connection-count=3D8<br>jdbc-0.proxool.maximum-connection-lifetime=3D18= 00000<br>jdbc-0.proxool.prototype-count=3D8<br>jdbc-0.proxool.house-keeping= -test-sql=3Dselect CURRENT=5FDATE from dual<br>jdbc-0.proxool.verbose=3Dtru= e<br>jdbc-0.proxool.statistics=3D1h,1d<br>jdbc-0.proxool.statistics-log-lev= el=3D INFO<br><br>We set maximum 8 connection. <br>But it appeared total co= nnections is 10 on application server after it running 2 days.<br>After we = checked. When it created more 2 connection, application had not do any thin= g.<br><br>The Case :<br>Application in idle. None of user used it.<br><br>0= 4:15.44 Proxool connect 8 connection, total =3D 8<br>04:30.00 Proxool disco= nnect 7 connection, total =3D 8<br>04:30.01 Proxool connect 7 connection, t= otal =3D 8<br>04:45.23 Proxool connect 1 connection, total =3D 8 <------= - ( it is 8 connections in proxool, but it is 9 connections in oc4j )<br><b= r>It seems sometime it can not disconnect from oracle or have not disconnec= t.<br>It is counted 8 in proxool. but it is counted 10 in OC4j .<br>It seem= s problem at housekeeper or lifetime timeout.<br><br><br> Thank you f= or attention.<br><br>Regards,<br><br>Macro Systems Limited<br>Douglas Huang= <br>---<br><a class=3D"moz-txt-link-freetext" href=3D"http://www.macro.com.= hk">http://www.macro.com.hk</a><br><br></FONT>*****************************= **********************************************<br />The information contain= ed in this message may be privileged and confidential and protected from di= sclosure. Any dissemination, distribution, copying of or taking of = any action in reliance upon this message, other than to/by the addresse= e, is strictly prohibited.<br />If you have received this in error,= please destroy it and notify us immediately. Opinions, conclusions and= other information in this message that do not relate to the official busin= ess of our company shall be understood as neither given nor endorsed by it = and we disclaim all liability for any such statements.<br />***************= **************************************************************<br />= |
|
From: <Do...@ma...> - 2007-05-14 06:37:21
|
<html><body> <p><tt>Dear all,<br> </tt> <ul><tt>We development a web application on OC4J. Database is Oracle 10= g.<br> </tt><tt>We connect to Oracle DB via proxool 0.9.0 as a db pool.</tt><b= r> </ul> <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><tt>After we checked. When it created more 2 connection, applicati= on had not do any thing.<br> </tt><br> <tt>The Case :<br> </tt><tt>Application in idle. None of user used it.<br> </tt><br> <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><br> <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>= |
|
From: Bill H. <bi...@lo...> - 2007-05-14 08:29:31
|
Hi Douglas, On 05/14/2007 07:29 AM, Do...@ma... wrote: > 04:15.44 Proxool connect 8 connection, total = 8 > 04:30.00 Proxool disconnect 7 connection, total = 8 > 04:30.01 Proxool connect 7 connection, total = 8 > 04:45.23 Proxool connect 1 connection, total = 8 <------- ( it is 8 > connections in proxool, but it is 9 connections in oc4j ) Can you give more log output at around that time please? If you log at debug level then you should see Proxool closing those old connections and creating new ones. Please don't email resend the same mail to this list: your message received three times! - Bill |
|
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>= |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X