where to close statement ? - Mailing list pgsql-interfaces

From Guillaume Rousse
Subject where to close statement ?
Date
Msg-id 00041816334200.05125@agathe
Whole thread Raw
List pgsql-interfaces
Hi.
Imagine the foolowing situation: i got one connection, and i have several
preparedStatements to execute, each with different parameters. Is is good
practice to close the connection in a finally() statement. But what about
statements and resultset ? Is there an advantage to close them explicitely :
-in the finally statement, before the connection.close() (see code A) ?
-in the try statement, between each statement execution for the resultset, and
between each redefinition for each preparedStatement (see code B) ?

code A:
Connection con=null;
PreparedStatement stmt=null;
Resulset rs=null;

try {
stmt=...
stmt.set...
rs=stmt.execute();
stmt.set...
rs=stmt.execute();

stmt=...
stmt.set...
rs=stmt.execute();
stmt.set...
rs=stmt.execute();
} finally {
rs.close();
stmt.close();
con.close()
}

code B:
Connection con=null;

try {
PreparedStatement stmt=...
stmt.set...
Resulset rs=stmt.execute();
rs.close();
stmt.set...
rs=stmt.execute();
rs.close();
stmt.close();

stmt=...
stmt.set...
rs=stmt.execute();
rs.close();
stmt.set...
rs=stmt.execute();
rs.close();
stmt;close();

} finally {
con.close()
}
-- 
Guillaume Rousse
Iremia - Universit� de la R�union

Sleep doesn't exists. Just lack of cafeine.


pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: RE: Postgresql JDBC errors
Next
From: Peter Mount
Date:
Subject: RE: where to close statement ?