I am using mysql++-2.1.1 I am trying to set the query (execute) timeout
so my program doesn't hang indefinitely when the table is locked. I am
using the set_options function with the opt_write_timeout argument. The
code compiles without error but the opt_write_timeout option doesn't
change a thing. Here are some relevant snippets from my code:
unsigned int time_out = 1;
mysqlpp::Connection con(mysqlpp::use_exceptions);
con.set_option(mysqlpp::Connection::opt_write_timeout, time_out);
con.set_option(mysqlpp::Connection::opt_read_timeout, time_out);
.
.
.
mysqlpp::Query query = con.query();
.
.
.
query.insert(point);
query.execute();
Why is this opt_write_timeout option not working? Was this fixed in a
later version? Is this the best way to set the query-execute timeout?
Also, what is the best way (within the API) to find out if the table is
locked?
Thanks,
Seth
--
Seth Linden
Software Engineer
Research Applications Laboratory (RAL)
National Center for Atmospheric Research
Foothills Laboratory
Building 2
3450 Mitchell Lane
Boulder, CO 80301 USA
Ph: 303-497-8433
