commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alfredo Ledezma Melendez <alfredo.lede...@mail.telcel.com>
Subject RE: commons.dbcp
Date Wed, 08 Mar 2006 00:39:45 GMT
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
View raw message