MySQL connectivity...

[cpiyush]

Hello,

I have query related to MySQL connectivity.

When we make a connection with MySQL and we don't use this connection for some particular amount of time (I don't know what) it automatically get disconnected. I don't want this thing to happen.

I remember one thing of MySQL that it provides a facility for this that whenever we make any connection with server a periodic acknowledgement singal is transferred between server & connection program, but I dont know how to use it.

Can you please help me out for this???

Thanks.

[cpiyush]

Hello,

I have query related to MySQL connectivity.

When we make a connection with MySQL and we don't use this connection for some particular amount of time (I don't know what) it automatically get disconnected. I don't want this thing to happen.

I remember one thing of MySQL that it provides a facility for this that whenever we make any connection with server a periodic acknowledgement singal is transferred between server & connection program, but I dont know how to use it.

Can you please help me out for this???

Thanks.

Hi...

I got the answer...

Its here...


import MySQLdb

def MySqlSample():

""" Python2.4 to MySQL using mysql-python using ping().

"""

# Establish a connection

db=MySQLdb.connection("localhost","root","abcdefgh ","testing")

# Run a MySQL query from Python and get the result set

try:

db.ping()

except ImportError:

pass # No MySQLdb module installed.

except AttributeError:

pass # SQLite connections have not ping() method.

except MySQLdb.OperationalError, e:

if e.args[ 0 ] in ( 2006, 2013 ): # SERVER_GONE or SERVER_LOST error

print 'reconnecting because of', e
db = MySQLdb.connection("localhost","root","","testing" )

db.query("""select dependency from assets where name = 'Java' """)
r = db.store_result()

[bartonc]

Hi...

I got the answer...

Its here...


import MySQLdb

def MySqlSample():

""" Python2.4 to MySQL using mysql-python using ping().

"""

# Establish a connection

db=MySQLdb.connection("localhost","root","abcdefgh ","testing")

# Run a MySQL query from Python and get the result set

try:

db.ping()

except ImportError:

pass # No MySQLdb module installed.

except AttributeError:

pass # SQLite connections have not ping() method.

except MySQLdb.OperationalError, e:

if e.args[ 0 ] in ( 2006, 2013 ): # SERVER_GONE or SERVER_LOST error

print 'reconnecting because of', e
db = MySQLdb.connection("localhost","root","","testing" )

db.query("""select dependency from assets where name = 'Java' """)
r = db.store_result()

There are many examples of MySQL connectivity in the Python > Code Forum.
You are welcome to check those out and post Python related questions in the Python Forum