commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vijay Anjur" <vijay.an...@gmail.com>
Subject Re: commons.dbcp
Date Wed, 08 Mar 2006 13:00:14 GMT
I did set those..

On 3/7/06, Alfredo Ledezma Melendez <alfredo.ledezma@mail.telcel.com> wrote:
>
> Try setting removeAbandoned and removeAbandonedTimeout in your
> configuration.
>
> More references at.
> http://jakarta.apache.org/commons/dbcp/configuration.html
>
> Regards,
> ____________________________________________
> Alfredo Ledezma Meléndez.
> Gerencia de Sistemas CRM
> Consultor Externo de Sistemas de Atención a Clientes
> RadioMovil DIPSA, S. A. de C. V.
> Ejército Nacional No. 488, Col. Chapultepec Morales,
> C.P. 11570 México D.F.
>
> Aquel que construye la casa de la felicidad futura edifica la cárcel del
> presente.
> Octavio Paz
>
>
>
>
> > -----Original Message-----
> > From: Vijay Anjur [mailto:vijay.anjur@gmail.com]
> > Sent: Tuesday, March 07, 2006 6:19 PM
> > To: Jakarta Commons Users List
> > Subject: Re: commons.dbcp
> >
> >
> > If the connections are not killed from the RDBMS (Sybase),
> > the pool does not
> > complain about the pool exhaust. Only if the DBA kills the
> > connections in
> > the RDBMS, which makes the connections in the pool invalid. I see the
> > org.apache.commons.dbcp.SQLNestedException: Cannot get a
> > connection, pool
> > exhaustedexception.
> >
> > On 3/7/06, Alfredo Ledezma Melendez
> > <alfredo.ledezma@mail.telcel.com> wrote:
> > >
> > >
> > >
> > > OK...
> > >
> > > How many concurrent users are we talking about? Please post
> > (or attach)
> > > the code
> > > where you are using the connections, and check that all
> > connections call
> > > close()
> > > method on a finally clause.
> > >
> > >
> > > Connection con = null;
> > > try{
> > >        con = SomeObject.getPooledConnection() ; // change
> > whatever your
> > > object is
> > > called
> > >        con.query...
> > >        ....
> > >        ... process data()
> > >
> > > }catch(SQLException sqle){
> > >        // report error
> > > }finally{ // no matter what happens, close the connection
> > >        con.close();
> > > }
> > >
> > > Regards,
> > > ____________________________________________
> > > Alfredo Ledezma Meléndez.
> > > Gerencia de Sistemas CRM
> > > Consultor Externo de Sistemas de Atención a Clientes
> > > RadioMovil DIPSA, S. A. de C. V.
> > > Ejército Nacional No. 488, Col. Chapultepec Morales,
> > > C.P. 11570 México D.F.
> > >
> > > Aquel que construye la casa de la felicidad futura edifica
> > la cárcel del
> > > presente.
> > > Octavio Paz
> > >
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Vijay Anjur [mailto:vijay.anjur@gmail.com]
> > > > Sent: Tuesday, March 07, 2006 5:03 PM
> > > > To: Jakarta Commons Users List
> > > > Subject: commons.dbcp
> > > >
> > > >
> > > >  Application connects to database.Pool has 5 connections.
> > > > Exit the application.Kill all the 5 connections (the Pool
> > has) in the
> > > > database.
> > > > Try connecting to the database from the application, I get
> > > > the following
> > > > error:
> > > >  org.apache.commons.dbcp.SQLNestedException: Cannot get a
> > > > connection, pool
> > > > exhausted
> > > >         at
> > org.apache.commons.dbcp.PoolingDataSource.getConnection(
> > > > PoolingDataSource.java:103)
> > > >         at org.apache.commons.dbcp.BasicDataSource.getConnection(
> > > > BasicDataSource.java:540)
> > > >         at
> > > >
> > org.apache.commons.dbcp.DataSourceConnectionFactory.createConnection(
> > > > DataSourceConnectionFactory.java:42)
> > > >         at
> > > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(
> > > > PoolableConnectionFactory.java:290)
> > > >         at
> > > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(
> > > > GenericObjectPool.java:771)
> > > >         at
> > org.apache.commons.dbcp.PoolingDataSource.getConnection(
> > > > PoolingDataSource.java:95)
> > > > I have set maxActive to 7. and testOnBorrow to true.
> > > >  Public void setupPool(){
> > > > private static PoolingDataSource pdsSample
> > > > DataSource dsSample = (DataSource) envCtx.lookup("ds/sample");
> > > > ConnectionFactory cf1 = new DataSourceConnectionFactory(dsSample);
> > > > poolSample = new GenericObjectPool(null,
> > > >
> > > >
> > > > bdsINTLDB.getMaxActive(),
> > > >
> > > >                                                (byte)1,
> > > >
> > > >
> > bdsINTLDB.getMaxWait(),
> > > >
> > > >
> > bdsINTLDB.getMaxIdle(),
> > > >
> > > >
> > bdsINTLDB.getMinIdle(),
> > > >
> > > >
> > > > bdsINTLDB.getTestOnBorrow(),
> > > >
> > > >
> > > > bdsINTLDB.getTestOnReturn(),
> > > >
> > > >
> > > > bdsINTLDB.getTimeBetweenEvictionRunsMillis(),
> > > >
> > > >
> > > > bdsINTLDB.getNumTestsPerEvictionRun(),
> > > >
> > > >
> > > > bdsINTLDB.getMinEvictableIdleTimeMillis(),
> > > >
> > > >
> > > > bdsINTLDB.getTestWhileIdle()
> > > > );
> > > >  PoolableConnectionFactory pcf1 = new
> > PoolableConnectionFactory(cf1,
> > > > poolSample, null, null, false, true);
> > > > pcf1.setValidationQuery(bdsINTLDB.getValidationQuery());
> > > > pdsSample = new PoolingDataSource(poolSample);
> > > >
> > > > }
> > > >
> > > >
> > > >
> > > > public Connection getConnection(){
> > > > try{
> > > > Connection c = pdsSample.getConnection();
> > > >
> > > > }catch(Exception e)
> > > >
> > > > return c;
> > > > }
> > > >
> > >
> > >
> > > Este mensaje es exclusivamente para el uso de la persona o
> > entidad a quien
> > > esta dirigido; contiene informacion estrictamente
> > confidencial y legalmente
> > > protegida, cuya divulgacion es sancionada por la ley. Si el
> > lector de este
> > > mensaje no es a quien esta dirigido, ni se trata del
> > empleado o agente
> > > responsable de esta informacion, se le notifica por medio
> > del presente, que
> > > su reproduccion y distribucion, esta estrictamente
> > prohibida. Si Usted
> > > recibio este comunicado por error, favor de notificarlo
> > inmediatamente al
> > > remitente y destruir el mensaje. Todas las opiniones
> > contenidas en este mail
> > > son propias del autor del mensaje y no necesariamente
> > coinciden con las de
> > > Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas,
> > > controladoras, afiliadas y subsidiarias. Este mensaje
> > intencionalmente no
> > > contiene acentos.
> > >
> > > This message is for the sole use of the person or entity to
> > whom it is
> > > being sent.  Therefore, it contains strictly confidential
> > and legally
> > > protected material whose disclosure is subject to penalty
> > by law.  If the
> > > person reading this message is not the one to whom it is
> > being sent and/or
> > > is not an employee or the responsible agent for this
> > information, this
> > > person is herein notified that any unauthorized
> > dissemination, distribution
> > > or copying of the materials included in this facsimile is strictly
> > > prohibited.  If you received this document by mistake please
> > > notify  immediately to the subscriber and destroy the
> > message. Any opinions
> > > contained in this e-mail are those of the author of the
> > message and do not
> > > necessarily coincide with those of Radiomovil Dipsa, S.A.
> > de C.V. or any
> > > of its control, controlled, affiliates and subsidiaries
> > companies. No part
> > > of this message or attachments may be used or reproduced in
> > any manner
> > > whatsoever.
> > >
> > >
> > ---------------------------------------------------------------------
> > > 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message