Commons Dbcp
  1. Commons Dbcp
  2. DBCP-219

how to kill a connection from the connection pool without shutting down the connection pool

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Labels:
      None
    • Environment:

      Windows, Unix

      Description

      Hi:

      This is really not a bug but probably a desired feature and something I am not aware of.

      We use the Apache connection pool in a Servlet environment. We need the feature to kill or close a connection forcefully when it is being used by a servlet. The reason can be various: an evil servlet that holds a connection forever, db issue, network issue, etc. How can we do that? I notice that datasource.getConnection() always returns a new connection. How do we keep track of connections that are being used so we can close them if needed? Currently we can only kill one at the database side by a DBA.

      Should we write a a util to keep track of connection objects that are borrowed by clients?

        Activity

        Bill Liu created issue -
        Phil Steitz made changes -
        Field Original Value New Value
        Fix Version/s 1.4 [ 12312615 ]
        Mark Thomas made changes -
        Issue Type Bug [ 1 ] New Feature [ 2 ]
        Phil Steitz made changes -
        Affects Version/s 2.0 [ 12313721 ]
        Affects Version/s 1.2.2 [ 12311976 ]
        Phil Steitz made changes -
        Fix Version/s 2.0 [ 12313721 ]
        Fix Version/s 1.4 [ 12312615 ]
        Gustavo Huff Mauch made changes -
        Comment [ [FÉRIAS] - Estou de férias! Volto dia 01/03.
        Assuntos urgentes tratar com Cléo (ramal 1112).


        Periodo de afastamento

        Inicio: 13/2/2010
        Termino: 27/2/2010

        --
        DATACOM - Mauch
         
        DATACOM
        Av. Franca, 725 - Porto Alegre, RS - 90230-220
        DDR: +55 51 3358 0100
        FAX: +55 51 3358 0101
        site: http://www.datacom.ind.br
        e-mail: <mauch@datacom.ind.br>
        ]
        Mark Thomas made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Phil Steitz made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Bill Liu
          • Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development