commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kwok Peng Tuck <pengt...@makmal.net>
Subject Re: Réf. : Re: Réf. : RE: dbcp size nightmare
Date Fri, 07 Nov 2003 08:08:34 GMT
Uh, sorry, I didn't quite get that. Could you include your code for us 
to see ?


meissa.Sakho@assetmanagement.natexis.fr wrote:

>better,
>Im closing in my finally statement all resources.
>
>Resultset,statement and connection.
>
>Meissa Sakho
>NATEXIS ASSET MANAGEMENT
>Direction de l'organisation
>Tel. : 01 58 19 45 71
>http://www.assetmanagement.natexis.fr
>
>
>
>
>
>Kwok Peng Tuck <pengtuck@makmal.net>
>07/11/2003 08:22
>Veuillez répondre à "Jakarta Commons Users List"
>
>
>
>        Pour :  Jakarta Commons Users List <commons-user@jakarta.apache.org>
>        cc :
>
>        Objet : Re: Réf. : RE: dbcp size nightmare
>
>
>Make sure that you include a finally block after your catch, in which
>
>you actually close the connection.
>
>try {
>    //Do your db con here.
>
>}catch (SQLException e) {
>    e.printStackTrace() ;
>}finally {
>     try {
>          if(con!=null) { con.close() ;  }
>    }catch (SQLException e) {
>       e.printStackTrace() ;
>    }
>}
>
>You can find this design pattern in the tomcat doc as well (under JNDI
>
>datasource how-to)  .
>
>
>meissa.Sakho@assetmanagement.natexis.fr wrote:
>
>  
>
>>I do close everything.
>>I'm wondering if it's not because I don't specify a factory
>>in the pool config.
>>
>>any other suggestion ...
>>
>>
>>
>>Meissa Sakho
>>NATEXIS ASSET MANAGEMENT
>>Direction de l'organisation
>>Tel. : 01 58 19 45 71
>>http://www.assetmanagement.natexis.fr
>>
>>
>>
>>
>>
>>"Michael Holly" <MHolly@talisentech.com>
>>06/11/2003 17:31
>>Veuillez répondre à "Jakarta Commons Users List"
>>
>>
>>
>>       Pour :  "'Jakarta Commons Users List'"
>>    
>>
>
><commons-user@jakarta.apache..org>
>  
>
>>       cc :
>>
>>       Objet : RE: dbcp size nightmare
>>
>>
>>Make sure you are closing all your resources after running the SQL.
>>Connection, Statement, ResultSet.
>>
>>
>>Michael Holly
>>
>>"Developing Software from requirements and Walking on water, both are
>>easy when frozen."
>>"Good, Fast, and Cheap... pick Two"
>>
>>
>>
>>-----Original Message-----
>>From: meissa.Sakho@assetmanagement.natexis.fr
>>[mailto:meissa.Sakho@assetmanagement.natexis.fr]
>>
>>Sent: Thursday, November 06, 2003 7:11 AM
>>To: commons-user@jakarta.apache.org
>>Subject: dbcp size nightmare
>>
>>
>>
>>hi all,
>>
>>I have configured my dbcp connection pool like the fragment below.
>>
>><Resource name="jdbc/recProduit" auth="Container"
>>                       type="javax.sql.DataSource"/>
>>
>>
>>
>>           <ResourceParams name="jdbc/recProduit">
>><parameter><name>username</name><value>mailer</value></parameter>
>><parameter><name>password</name><value>mail2002</value></parameter>
>>
>>
>><parameter><name>maxActive</name><value>3</value></parameter>
>>           <parameter><name>driverClassName</name>
>>             <value>com.sybase.jdbc2.jdbc.SybDriver</value></parameter>
>>           <parameter><name>url</name>
>>
>>
>><value>jdbc:sybase:Tds:s198000BLAHBLAH:5000/intranet_mail</value></param
>>eter>
>>
>>
>>
>>         </ResourceParams>
>>
>>
>>
>>I don't know why, but the pool size is always increasing.
>>
>>
>>
>>I've tried the maxActive parameter unsucessfully.
>>
>>I've search the list before posting this question.
>>But I've found no cure to my problem.
>>
>>Any help to detect what's missing in my config would
>>be greetly appreciated.
>>
>>Meissa
>>
>>Meissa Sakho
>>NATEXIS ASSET MANAGEMENT
>>Direction de l'organisation
>>Tel. : 01 58 19 45 71
>>http://www.assetmanagement.natexis.fr
>>
>>
>>L'integrite de ce message n'etant pas assuree sur internet, Natexis
>>Banques Populaires ne peut etre tenu responsable de son contenu. Toute
>>utilisation ou diffusion non autorisee est interdite. Si vous n'etes pas
>>destinataire de ce message, merci de le detruire et d'avertir
>>l'expediteur.
>>
>>The integrity of this message cannot be guaranteed
>>on the Internet. Natexis Banques Populaires can not therefore be
>>considered responsible for the contents.Any unauthorized use or
>>dissemination is prohibited. If you are not the intended recipient of
>>this message, then please delete it and
>>
>>notify the sender.
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>
>>
>>
>>
>>
>>L'integrite de ce message n'etant pas assuree sur internet, Natexis
>>Banques Populaires ne peut etre tenu responsable de
>>son contenu. Toute utilisation ou diffusion non autorisee est
>>interdite. Si vous n'etes pas destinataire de ce message, merci de le
>>detruire et d'avertir l'expediteur.
>>
>>The integrity of this message cannot be guaranteed
>>on the Internet. Natexis Banques Populaires can not therefore be
>>considered responsible for the contents.Any unauthorized use or
>>    
>>
>
>dissemination is prohibited.
>  
>
>>If you are not the intended recipient of this message, then please delete
>>    
>>
>
>it and
>  
>
>>notify the sender.
>>
>>    
>>
>
>  
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
>
>
>L'integrite de ce message n'etant pas assuree sur internet, Natexis
>Banques Populaires ne peut etre tenu responsable de
>son contenu. Toute utilisation ou diffusion non autorisee est
>interdite. Si vous n'etes pas destinataire de ce message, merci de le
>detruire et d'avertir l'expediteur.
>
>The integrity of this message cannot be guaranteed
>on the Internet. Natexis Banques Populaires can not therefore be
>considered responsible for the contents.Any unauthorized use or dissemination is prohibited.
>If you are not the intended recipient of this message, then please delete it and
>
>notify the sender.
>  
>


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message