Re: Detecting 'socket errors' - closing the Connection object

>  It is not that trivial for JDBC to be able to detect and handle all the
> cases when the connection can be considered "closed" as opposed
> legitimate error conditions...

Why is that the case?  I mean, if the library gets a socket error, rather
than error from the database, it's an I/O error that probably means a TCP
socket won't really be okay anymore, and it could then close it.

> Besides, if isClosed () returned true in such situations, it would be
> lying :-)

Well, not if it closed it after it got an error.  I mean, I don't open the
socket either, but the JDBC library should be able to figure it out, no?

> try
> {
>     c.createStatement ().execute ("select 1;");
>     idlingConnections.add (c);
> }
> catch (Exception e)
> {
>     log ("OOPS: the connection seems dead: ", e);
>     try
>     {
>        c.close (); //Just in case...
>     }
>    catch (Exception e)
>    {
>    }
>
>    numOpenConnections--;
> }

That will work, but doesn't adding an entire call to the backend database on
each use a connection from the pool seem excessive?  I mean, if I'm going to
all that trouble, I might as well not pool the connection at all -- the
overhead can't be that much different.

David