commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin van den Bemt <mll...@mvdb.net>
Subject Re: Réf. : Re: Réf. : Re: Réf. : RE: dbcp size nightmare
Date Fri, 07 Nov 2003 13:55:43 GMT
Your finally block is not executed in case of an exception, since you
are throwing an exception fro the catch :)

Mvgr,
Martin

On Fri, 2003-11-07 at 09:53, meissa.Sakho@assetmanagement.natexis.fr
wrote:
> the fragment code below describe how I acquire and close ressource.
> 
> protected void executeDB() throws TechnicalException
>         {
>                 Connection connection = null;
>                 Statement statement = null;
> 
>                 connection = getConnection();
> 
>                 try
>                 {
>                         statement = connection.createStatement();
>                         executeTransaction(statement);
> 
>                 }
>                 catch (SQLException e1)
>                 {
>                         throw new TechnicalException(this, "Probleme d'accés à la base
de donnée impossible de créer un objet
> Statement " + e1.getMessage());
> 
>                 }
> 
>                 finally
>                 {
>                         // on libere les ressources
>                         release(connection, statement);
>                         sqlQueries = new ArrayList();
>                 }
> 
>         }
> 
> 
> the getConnection() method will acquire a connection defined in server.xml
> file
> while the release connection will close ressources.
> 
> 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 09:08
> Veuillez répondre à "Jakarta Commons Users List"
> 
> 
>         Pour :  Jakarta Commons Users List <commons-user@jakarta.apache.org>
>         cc :
>         Objet : Re: Réf. : Re: Réf. : RE: dbcp size nightmare
> 
> 
> 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
> 
> 
> 
> 
> 
> 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.
-- 
Martin van den Bemt <mllist@mvdb.net>
mvdb.com


---------------------------------------------------------------------
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