Re: Es verdad qu? Java tiene sus d?as contados???

Article View: chile.comp.programacion

Article #1823

Back to chile.comp.programacion Previous Next

#1823

From: sigfridelunico
Date: Tue, 23 May 2006 19:03

31 lines
2474 bytes

Guero sin Fe ha escrito:
> En las primeras aplicaciones en java que desarrollé con JDBC me di cuenta
> que no debia confiarme en exceso del GC, claro, yo cerraba todos mis
> resultset y mi conexion con close(), pero al ver las sesiones de la base de
> datos, mi sesiones no se cerraban de inmediato sino que al cabo de unos 10
> min, finalmente supe que debia cerrar los statement, resultset, connection,
> todo en ese orden.

Buena práctica es colocar un try{}finally{} cuando creas objetos
relacionados con base de datos. Por ejemplo:

Connection connection = new Connection();
try
{
    Resultset rs = new Resultset (connection);
    try
    {
    }
    finally
    {
        rs.close();
    }
//Todo lo que hay que 
}
finally
{
    connection.close;
}

Technical Details

Message-ID: <1148410997.704123.282950@j33g2000cwa.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!j33g2000cwa.googlegroups.com!not-for-mail

References:

<1147226876.295762.285700@i39g2000cwa.googlegroups.com> <1147466683.473616.296620@v46g2000cwv.googlegroups.com> <1147486625.785406.170650@d71g2000cwd.googlegroups.com> <1147699486.729952.299900@j55g2000cwa.googlegroups.com> <1147706864.907379.189240@u72g2000cwu.googlegroups.com> <1147709301.358766.66120@j73g2000cwa.googlegroups.com> <e4dag7$2vs$1@helcaraxe.dcc.uchile.cl> <e4fm11$4v3$1@spawn.telmexchile.cl>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,e865c80029686f0e
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!j33g2000cwa.googlegroups.com!not-for-mail
From: "sigfridelunico@yahoo.com" <sigfridelunico@yahoo.com>
Newsgroups: chile.comp.programacion
Subject: Re: Es verdad qu? Java tiene sus d?as contados???
Date: 23 May 2006 12:03:17 -0700
Organization: http://groups.google.com
Lines: 32
Message-ID: <1148410997.704123.282950@j33g2000cwa.googlegroups.com>
References: <1147226876.295762.285700@i39g2000cwa.googlegroups.com>
   <1147466683.473616.296620@v46g2000cwv.googlegroups.com>
   <1147486625.785406.170650@d71g2000cwd.googlegroups.com>
   <1147699486.729952.299900@j55g2000cwa.googlegroups.com>
   <1147706864.907379.189240@u72g2000cwu.googlegroups.com>
   <1147709301.358766.66120@j73g2000cwa.googlegroups.com>
   <e4dag7$2vs$1@helcaraxe.dcc.uchile.cl>
   <e4fm11$4v3$1@spawn.telmexchile.cl>
NNTP-Posting-Host: 164.77.255.200
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1148411004 16583 127.0.0.1 (23 May 2006 19:03:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 23 May 2006 19:03:24 +0000 (UTC)
In-Reply-To: <e4fm11$4v3$1@spawn.telmexchile.cl>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: j33g2000cwa.googlegroups.com; posting-host=164.77.255.200;
   posting-account=DkQVCgwAAACpYb2TXp-vwPk-CZFRXMPm

Reply to Parent Message