RE: unsuccessful queries and lost connection

You could lose connection for various reason such as how the server is configured, timeouts, etc.

catch is the correct way to deal with it. What you do then is application specific.

Search the mailing list for "connection" or "retry" since there has been quite a few postings on retry methods. I posted my try/catch macros some time back. If you can't find them e-mail me and I'll send you a sample of what I do.

-----Original Message-----
From: Albert Sanchez [mailto:ouferrat@gmail.com] Sent: Wednesday, July 25, 2007 4:16 AM
To: plusplus@lists.mysql.com
Subject: unsuccessful queries and lost connection

Hi all,

I'm programming a piece of software that continuously looks up if it has pending sql queries (UPDATE and INSERT) and executes them. I should also control if I lost the db connection or if a sql query was unsuccessful.

My question is:

in what circumstances could I lose the connection to the db and how would I realize it?

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

I have found in the refman a mysqlpp::BadQuery class.

Just something like this?

try {

    mysqlpp::Query sqlQuery = sqlConn.query();     sqlQuery << q;
} catch(mysqlpp::BadQuery ex) {

}

Is there a better way to deal with errors?

I only want to know if it occurred an error, I am not interested in other stats or results.

Thanks in advance,
Albert

-- 
MySQL++ Mailing List
For list archives: 
http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=lists@pantek.com

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek