Kris Jurka wrote:
>>Being user-friendly when dealing with application errors is nice
>>behaviour to have, but it *is* a separate issue..
>
>
> Separate from what, correctness?
Yes.
> We both agree that a short stream or
> IOException is an error, but I'm not advocating the JDBC equivalent of
> System.exit() as a viable solution. What makes it OK for this
> particular error to destroy a Connection while no other application level
> error can?
The implementation of SQLState (or connectionErrorOccurred) across
different drivers is quite patchy. When writing portable applications
(or even driver-specific applications, to a lesser extent) you have to
assume that any SQLException you don't specifically recognize means your
connection is toast.
I don't see that tearing down the connection for a certain class of
hard-to-handle errors makes this situation any worse.
-O
