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 14:40:31 GMT
My bad wasn't thinking.. 

Mvgr,
Martin

On Fri, 2003-11-07 at 15:12, pgarvie wrote:
> A finally block is ALWAYS executed, assuming you don't call System.exit(0) 
> or pull the plug while you're in the catch.
> 
> 
> 
> 
> 
> 
> At 07:55 AM 11/7/2003, you wrote:
> >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
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
-- 
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