Database connection recovery

Asked Feb 07 '12 at 10:43

Active Feb 07 '12 at 10:48

Viewed 54 times

Possible Duplicate:
How to reuse code that reopens connection?

I have a .NET application that makes frequent updates to a database. Sometimes, the database is restarted without any prior notification. In that case the application stops working because of an exception being thrown.

I have to devise a method to make it auto-recover from a lost connection. For that I have written code like this:

while(true)
{
    try
    {
        //Query
        break;
    }
    catch (Exception objException)
    {
        if (!objException.Message.Contains("A transport-level error"))
        {
            throw;
        }
    }
}

Do you think it is effective way to auto-recover?

edited May 23 '17 at 12:11

Community

asked Feb 07 '12 at 10:43

harrisunderwork

2

Check out this question http://stackoverflow.com/questions/9120614/how-to-reuse-code-that-reopens-connection – Roy Goode Feb 07 '12 at 10:45
1

My question is not about whether it works or not, I am more inclined towards working and efficient method. Perhaps there may be a better solution for this :) – harrisunderwork Feb 07 '12 at 10:46
AT-Shai - I dont think transaction is relevant here. AT-Roy - checking it out, thanks. :) – harrisunderwork Feb 07 '12 at 10:48
I would not use this, you will have endless loops on transport-level errors. How often do you see them? – Peter Feb 07 '12 at 10:49
Have also a look at my comments on above linked question. http://stackoverflow.com/questions/9120614/how-to-reuse-code-that-reopens-connection#comment11460850_9120614 – Tim Schmelter Feb 07 '12 at 10:51
@shai - sorry I am not getting what you mean to say. – harrisunderwork Feb 07 '12 at 10:52
@peer - thats the whole point, you remain in loop unless a connection is made, you constantly poke a person unless he/she listens to you :) – harrisunderwork Feb 07 '12 at 10:53
1

@TimSchmelter - I guess thats the solution I needed. – harrisunderwork Feb 07 '12 at 10:54

Database connection recovery

0 Answers0