geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Jencks <david_jen...@yahoo.com>
Subject Re: J2CA logging/exception handling around SQLException
Date Fri, 17 Sep 2004 00:44:52 GMT
OK, so I implemented the framework and entered a tracking issue

http://nagoya.apache.org/jira/browse/GERONIMO-306

thanks
david jencks

On Sep 16, 2004, at 4:53 PM, David Blevins wrote:

> On Thu, Sep 16, 2004 at 04:14:29PM -0700, David Jencks wrote:
>>
>> On Sep 16, 2004, at 3:49 PM, David Blevins wrote:
>>
>>> So I'm in the process of cleaning up the OpenEJB itest output as it
>>> spits out an excessive amount of stack traces.  The exceptions are
>>> just SQLExceptions that are being thrown as business method app
>>> exceptions.
>>>
>>> Seems any exceptions (e.g. SQLException) thrown from an RA is being
>>> logged on INFO by GeronimoConnectionEventListener.  Can't quite tell,
>>> but at first glance it looks like it flags the connection handle for
>>> removal as well.
>>>
>>> Is this right and is this what we really want?
>> At the moment this is the correct behavior.  The solution is, for each
>> driver, implement an "exception sorter" that  can determine if a
>> particular exception means the connection is no longer usable.  Then
>> "table doesn't exist" exceptions can be distinguished from "your db
>> disk just exploded".  Unfortunately the jdbc spec has not seen fit to
>> require drivers to distinguish these in a generic fashion.
>>
>
> Good idea.  Any thoughts on how to actually implement the sorting
> "framework"?
>
> If we had that in place, the actual act of implementing a sorter and
> classifying exceptions for each driver is something that could keep
> many a contributor busy for quite a while.
>
> -David
>


Mime
View raw message