[Pljava-dev] Pljava-dev Digest, Vol 26, Issue 8

pljava-dev-request,hi?

Marek's source code:

> // insert into regional registrations table
> {
> Statement s = connection.createStatement();
>
> ResultSet r = s.executeQuery("SELECT oCarTypeId FROM
>samarapp_data.sapp_cda_pl_cep_rre WHERE oCarTypeId = " + co + " AND
>nCarTypeId = " + cn + " AND nMakeId = " + mk + " AND nModelId = " + mo +
>" AND nDistrictW = " + rw + " AND nDistrictP = " + rp + " AND
>productionYear = " + result.getInt("productionyear") + " AND
>registrationYear = " + result.getInt("registrationyear"));
>
> if (r.next() == false) s.execute("INSERT INTO
>samarapp_data.sapp_cda_pl_cep_rre (oCarTypeId, nCarTypeId, nMakeId,
>nModelId, nDistrictW, nDistrictP, productionYear, registrationYear,
>registrationMonth" + result.getInt("registrationmonth") + ") VALUES (" +
>co + "," + cn + "," + mk + "," + mo + "," + rw + "," + rp + "," +
>result.getInt("productionyear") + "," +
>result.getInt("registrationyear") + "," +
>result.getInt("registrationamount") + ")");
>
> else s.execute("UPDATE samarapp_data.sapp_cda_pl_cep_rre SET
>registrationMonth" + result.getInt("registrationmonth") + "=" +
>result.getInt("registrationamount") + " WHERE oCarTypeId = " + co + "
>AND nCarTypeId = " + cn + " AND nMakeId = " + mk + " AND nModelId = " +
>mo + " AND nDistrictW = " + rw + " AND nDistrictP = " + rp + " AND
>productionYear = " + result.getInt("productionyear") + " AND
>registrationYear = " + result.getInt("registrationyear"));
>
> r.close();
>
> s.close();
> }

When did the result close ? Marek, we can see two ResultSet("result" and "r")in your sourcecode .In the last code ,there is "r.close" to close ResultSet("r") explicitly but i cann't see where the "result" is closed . If you did not close the "result", i guess that it's the error to lead the memory leak.

????????lifeng
????????lifenggod at 263.net
??????????2006-04-19