I have noticed that there can be multiple exceptions that can map to the same standard SQL State. For example, 08003 means "connection does not exist". I have found at least two places where this is valid.

I think it's reasonable to do something like this in SQLState.java

String CONN_ERROR_1 = "08003.C.1";
String CONN_ERROR_2 = "08003.C.2";

The code that extracts severity from the message id would not be impacted, as it only looks at the 7th character.

This seems reasonable to me, but looks like a break from what has been done in the past. Is there anything I'm missing that I should be aware of before I take this approach?

Thanks,

David
begin:vcard
fn:David W Van Couvering
n:Van Couvering;David W
org:Sun Microsystems, Inc.;Database Technology Group
email;internet:[EMAIL PROTECTED]
title:Senior Staff Software Engineer
tel;work:510-550-6819
tel;cell:510-684-7281
x-mozilla-html:TRUE
version:2.1
end:vcard

Reply via email to