Mutiple Connections problem

[bikashlama]

Hi I am having a problem with multiple connections opened though I have closed them using cn.close() method.
Actually, I have a frame contains multiple instances of panels containing the records on JLabel. I have setText() on labels from MySQL.
The query goes like this:

public void fillDetails(int ID) {
        Connection cn = null;
        Statement stmt = null;
        ResultSet rss = null;
        try {
            cn = connectMySql.conn();
            String sqltempCDR = "select amount from table1 where id=" + ID + "";
            stmt = cn.createStatement();
            rss = stmt.executeQuery(sqltempCDR);
            int li_row = 0;
            if (rss != null) {
                while (rss.next()) {
                    amount = amount + rss.getDouble(1);
                    li_row++;
                }
            }
            labelTotalAmountValue.setText(Double.toString(amount));
            rss.close();
            stmt.close();
            cn.close();
        } catch (Exception e) {
            e.PrintStackTrace();
        } 
}

There are 15 panels in a frame.
So when I load the application this method is invoked 15 times.
and though I have closed the connection, when i try to view the connection state in ms-dos command using netstat -a
it dispaly around 15-16 connections
with
proto local address foreign address State
tcp ip-address TIME_WAIT

and I think this is also the reason that my application consumes Mem usage alot too and becomes slow.

Any solution plz....

Thanks in advance

[bikashlama]

I tried using the finally too
finally
{
if(cn!=null)
{
cn.close();
}
}

[Eranga]

In a single execution of cycle, you have to open the connection then process data and then close the connection. You have to maintain the sequence in each cycle. Seems you don't have work on that.

[Eranga]

And also please use the code tags when you are posting again. Unformatted codes are really hard to read.

[bikashlama]

But I think this is the process you open connection, process, then close the connection. If you have better way plz suggest me.

[Eranga]

Only the other possibility you have is that open a connection and keep for the complete of all the processing you have. Connection open/close in periodically required lots of resources.

[2by4]

TIME_WAIT is a TCP thing. It can hang around for a while after a connection is closed. Try again and wait a good few minutes to see if the TIME_WAITs disappear.

[bikashlama]

Thank you so much your reply. let me try that too.