DBCP Object not closed- urgent help reuired.

[micky none <ha...@rediffmail.com>]

Hi friends,
i've a program that takes in date from the user in a text box.Everything works fine except the log files shows something like this:

------------------------------------------

(Http11Protocol.java:738)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
DBCP object created 2005-03-01 23:06:58 by the following code was never closed:
java.lang.Exception
        at org.apache.commons.dbcp.AbandonedTrace.init(AbandonedTrace.java:96)
        at org.apache.commons.dbcp.AbandonedTrace.<init>(AbandonedTrace.java:79)
        at org.apache.commons.dbcp.DelegatingStatement.<init>(DelegatingStatement.java:60)
        at org.apache.commons.dbcp.DelegatingConnection.createStatement(DelegatingConnection.java:173)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.createStatement(PoolingDataSource.java:209)
        at com.ResSet.getResultSet(ResSet.java:30)
        at com.TournamentDollars.retArrayList(TournamentDollars.java:119)
        at org.apache.jsp.BonusReleased_jsp._jspService(org.apache.jsp.BonusReleased_jsp:158)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.jasper.servlet.JspServletWrapper.service

--------------------------------------------------

whereas i am calling the close method at the end of my JSP,after i am finished with my data display.The close method that i call is:


---------------------------------------------------
 public void close()
  {
   try { results.close(); } catch (Exception ex) {}
   try { st.close(); } catch (Exception ex) {}
   try { con.close(); } catch (Exception ex) {}
  }

----------------------------------------------------

Please help me friends asap,it's really urgent for me,your help would be really appreciated.Waitin for your replies,
bye