Details

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

      Java DBCP

      Description

      Hi,

      I work in Operations, I feel that adding debug and info statements for this commons-dbcp is very much helpful to debug the database connection problems in production environment to the applications, its very useful for tuning the connectioon pool parameters also, I got surprised how the logging is missing to DBCP packages. Can I expect this to add in near releases.

      Thanks,
      Madhu.

        Activity

        Madhusudan Pagadala created issue -
        Phil Steitz made changes -
        Field Original Value New Value
        Fix Version/s 1.4 [ 12312615 ]
        Phil Steitz made changes -
        Fix Version/s 1.3 [ 12311977 ]
        Fix Version/s 1.4 [ 12312615 ]
        Hide
        Mark Thomas added a comment -

        Introducing a dependency on a any logging framework means pushing this to 2.0

        Show
        Mark Thomas added a comment - Introducing a dependency on a any logging framework means pushing this to 2.0
        Mark Thomas made changes -
        Fix Version/s 2.0 [ 12313721 ]
        Fix Version/s 1.3 [ 12311977 ]
        Hide
        Thomas Fox added a comment -

        One possibility would be to use the java logger, see
        http://download.oracle.com/docs/cd/E17476_01/javase/1.4.2/docs/api/java/util/logging/package-frame.html
        It does not require any additional libraries, because dbcp 1.3 requires java 1.4 anyway.

        The java logger is not perfect as a logging choice in my opinion but it is far better than no logging. Plus people can use or write bridges to other logging frameworks.

        Show
        Thomas Fox added a comment - One possibility would be to use the java logger, see http://download.oracle.com/docs/cd/E17476_01/javase/1.4.2/docs/api/java/util/logging/package-frame.html It does not require any additional libraries, because dbcp 1.3 requires java 1.4 anyway. The java logger is not perfect as a logging choice in my opinion but it is far better than no logging. Plus people can use or write bridges to other logging frameworks.
        Hide
        Mark Thomas added a comment -

        A dependency on Commons Logging has been added to DBCP 2.

        At present it is limited to logging exceptions that would otherwise be swallowed by the Pooling implementation (Commons Pool 2).

        The preferred way to monitor the state of the DBCP is via JMX but additional logging can be added as required. Any specific request for additional logging should be made via a new Jira issue.

        Show
        Mark Thomas added a comment - A dependency on Commons Logging has been added to DBCP 2. At present it is limited to logging exceptions that would otherwise be swallowed by the Pooling implementation (Commons Pool 2). The preferred way to monitor the state of the DBCP is via JMX but additional logging can be added as required. Any specific request for additional logging should be made via a new Jira issue.
        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:
            Madhusudan Pagadala
          • Votes:
            3 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development