Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-1459

port [jbas-5524] - DB Connections established which fail check-valid-connection-sql do not immediatly close their connection

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • 4.2.0.GA_CP05, 4.3.0.GA_CP03
    • JCA
    • None

    Description

      When a DB connection is attempted to be created where it is configured with new-connection-sql, if the socket/connection succeeds but the new-connection-sql statement fails a connection remains open until GC. In a large volume environment this can lead to many sockets being opened until GC occurs and can thus run into file handle limits.

      If a valid TCP connection was established, but the SQL fails, I am suggesting the connection should also be closed at the time of failure, not waiting till GC.

      Attachments

        Issue Links

          Activity

            People

              jpederse@redhat.com Jesper Pedersen
              rhn-support-jhowell William Howell
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: