Red Gate forums :: View topic - Question - what to do with results?
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Exception Hunter 1
Exception Hunter 1 forum

Question - what to do with results?

Search in Exception Hunter 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 15 Sep 2006
Posts: 6

PostPosted: Wed Dec 19, 2007 4:48 pm    Post subject: Question - what to do with results? Reply with quote

I have a couple questions about the Exception Hunter program. First of all, let me tell you the program looks great. You guys do a fantastic job with the UI. I have the SQL compare program and the same goes for that. Nice job.

1. My question is, after I go through all of the analysis, what do I do? It gives me a giant list of unhandled exceptions which I am not sure what to do with. Then you click on each exception and it takes you to the location in the code. So what do you do then? And why does it show a (seemingly) neverending list of stack? Does this help?

Maybe some more info in the help documentation would be what is needed. ...or maybe I'm just a little dense! I'm not sure if I need to handle ALL of the exceptions that are listed. I do have general try/catch exception handling in all my procedures.
Back to top
View user's profile Send private message
James Moore

Joined: 21 Nov 2005
Posts: 245

PostPosted: Wed Dec 19, 2007 5:16 pm    Post subject: Reply with quote

Hi Jim,

There are some .NET methods which throw an extra ordinary amount of exceptions (There is at least one which can throw more than 500 different types of exception), this can make it difficult when choosing which ones to handle.

When I use the tool I do not catch all exceptions thrown by every method, some of the exceptions will be caused by one off start up code and probably don't need to be handled every time you call a function.

The value for the tool for me is allowing me to choose which exceptions I really want to handle rather than handing code off to a tester and them coming back, normally, thanks to sods law, a few hours before release, having done somthing which caused an exception I didn't expect.

I normally have Reflector open at the same time as using the tool and then look at the stack trace the program reports in reflector to understand when and if the exception will be thrown and then make a decision on if I want to deal with it there, somewhere else or if it is highly unlikely ever to be thrown in which case crashing hard and fast might be the best option.

Hope this helps a little,

James Moore
Head of DBA Tools
Red Gate Software Ltd
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group