Restoring a MySQL database connection

Question

0.00/5 (No votes)

See more:

In my software I have a connection module which makes a connection to the MySQL database connection. It passed the handle back to the main module. This module then passes the handle to any module that requires database access.

Thats all very well, but if the system is idle for any length of time the connection closes and causes a crash when the next access is attempted.

Apart from good old fashioned 'return' what are my options if one of these low level modules is forced to re establish the connection when it comes to passing the new handle back to the main module so that usage can continue?

Posted 30-Nov-11 8:52am

Ger Hayden

Updated 30-Nov-11 8:53am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**AmitGajjar** · Answer 1 · 2011-12-01T01:57:00

Hi,

i don't know this solution works for you,

Create one class that holds connection object as lazy loading
like myconn.ExecuteCommand
here ExecuteCommand property is lazy loading when we call, it will create connection with database with myconn object property like connectionstring, sql command etc.

so you can say for every attempt to execute command new connection will be created. if you connection is lost with database it will form new connection at the time of ExecuteCommand.

hope this will help you.

thanks
-amit.