Re: Help... record locks

I got the code from one of the other developers here.  I'm new to this, so 
I just assumed that it's checking to make sure the preparedstatement 
opened by checking if it was null and to only close it if it was opened. 
Here's the code:

PreparedStatement getStreet =   conn.prepareStatement("SELECT DISTINCT * 
FROM "  + lib   + dmd.getCatalogSeparator() + streetTable       + " WHERE 
"       + strSeq + " = 0"       + " ORDER BY " + orderBy);
rs = getStreet.executeQuery();
while (rs.next()) {
...
}
if (getStreet != null){
        rs.close();
        getStreet.close();
}

So basically, if the prepared statement doesn't execute then I'm leaving 
open the resultset rs?

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




Franco Biaggi <fbiaggi@xxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
2005/06/30 01:50 PM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>
cc

Subject
Re: Help... record locks






>One question though.
>If the preparedstatement returns a null, does the resultset still have to 

>be closed?

Yes,
but I do not understand your "null" result,
is a null field or ?

Ciao.