DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=27438>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=27438

JDBCAppender doesn't release connection in case of failure





------- Additional Comments From [EMAIL PROTECTED]  2004-03-29 09:12 -------
Hi Clement, 

your observations concerning firewall hold. Just one thing: if sql is bad 
(e.g. "insert intoS ...") connections will be never closed

                if (firstTime)
                {
                    retry(con, sql); //throws a new Exception 
                }
                else
                {
                    if (con != null)
                    {
                        connection = null;
                        try
                        {
                            con.close();
                        }
                        catch (Exception ignore)
                        {}
                    }
                    throw e;
                }
            }
        }
        stmt.close();
        closeConnection(con); //never reached 


As a conseguence, for each attempt to write a log event a new connection is 
opened and "never" released. 



Regards, 
      Gino Tesei

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to