[Proxool-developer] Disconnect problem with oracle database.

[<Do...@ma...>]

<FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=
=3D2>Dear all,<br>&nbsp;<br>&nbsp; We development a web application on OC4J=
. Database is Oracle 10g.<br>&nbsp; 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 &lt;------=
- ( 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>&nbsp; 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&#44; distribution&#44; copying of or taking of =
any action in reliance upon this message&#44; other than to/by the addresse=
e&#44; is strictly prohibited.<br />If you have received this in error&#44;=
 please destroy it and notify us immediately. Opinions&#44; 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 />=