Re: [JDBC] Implementing setQueryTimeout()

From: Oliver Jowett <oliver(at)opencloud.com>
Date: Tue Feb 19 2008 - 03:41:10 EST

Till Toenges wrote:
> Oliver Jowett wrote:

>>> A network timeout or anything worse is handled in an entirely 
>>> different part of the code. That is not the responsibility of the 
>>> driver, and doesn't event need to be part of the database related 
>>> code at all.
>>
>> I'm not sure what you mean here - if the connection to the DB fails, 
>> the driver will certainly handle that and tell you about it via a 
>> SQLException!

>
> Sorry. Of course the driver must handle failed connections. I meant the
> code in my application, which handles the two cases (timeout but usable
> connection vs broken connection for whatever reason) differently.

You can check the SQLState of any exception thrown to tell the difference, right?

-O

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Tue Feb 19 03:45:09 2008