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 Tue, 07 Mar 2006 21:48:40 GMT


Check that all your connections are closed (even when an exception can occur).
BTW, at least, post the code extract which is throwing the exception, database
used. Remember the more information (not being verbose) you give, the more help
you can expect.

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 3:38 PM
> To: commons-user@jakarta.apache.org
> Subject: commons.dbcp
>
>
> I am getting following exception,
> org.apache.commons.dbcp.SQLNestedException:
> Cannot get a connection, pool exhausted - Any ideas?
>
> The sequence to produce the exception is as follows.
>
> Make connection(into connection pool) from an
> application,Exit the client.
>
> Kill all the connections the client made to the RDBMS (the
> Pool has). The
> pool now has invalid connections.Logging thru the client again to get
> connection from pool. Pool validates the dead connection and
> then trying to
> make a new connection throws the following error from
> factory.makeobject().
>
> 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.
>
> Thanks, Vijay
>


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


Mime
View raw message