commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pgarvie <pgar...@mn.rr.com>
Subject Re: Réf. : Re: Réf. : Re: Réf. : RE: dbcp size nightmare
Date Fri, 07 Nov 2003 14:12:01 GMT
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


Mime
View raw message