Re: closing statements when connection is closed

(I forgot to CC the list)
----- Original Message -----
From: "Iain" <iain@mst.co.jp>
To: <EAdelaRosa@smart.com.ph>
Sent: Tuesday, February 10, 2004 2:49 PM
Subject: Re: [JDBC] closing statements when connection is closed


> > Could you post the exact compile time error for this particular block?
> > You may be forgetting to enclose the close() method further
> > in a try-catch block :)
>
> The message was some complaint that the variable might not be initialized.
>
> It created the situation where I couldn't close the statement if there was
> an exception. I think I understand what you mean though, I need to put the
> close() statement in a second try block after the one the caused the
error?
> Or just use a try close block nested in the first catch block. I'll give
it
> a try.
>
> I'll dig up the code and the message for you. I'll have to switch my
windows
> setting back to English though - unless you can read Japanese (I can't but
I
> still have to work with it - if I switch my windows language setting to
> English then my other M$ apps don't work correctly :-( )
>
> Thanks
> iain
>