Re: How do I get the session state (and then reconnect)?

[Luis Silva]

Hi!

Your best option is to use the Client class (pool implementation) and get the session just when you need it. It will keep the session open (see client timeout options) and, when getting the session, it will check if the connection is still open and, if not, do a new connection.

Here is a sample:

ClientSettings settings(SessionOption::HOST,"my_host",
SessionOption::PORT, 33060,
SessionOption::USER, "my_user"
);

Client client(settings);


for(int i=0; i<10; ++i)
{

Session s(client);


SqlResult res = s.sql("select @@version").execute();
for(auto row : res)
{
std::cout << row[0] << std::endl;
}

//This will timeout the session (controlled by mysqlx_wait_timeout server variable)
std::this_thread::sleep_for(std::chrono::hours(12));

}


Hope this helps!

Cheers,
Luís Silva