Re: Error 2013 Lost connection ... using stored procedures

[Arnon Jalon]

I think that I found the reason. The c api, which mysql++ wraps, treats result sets being returned by stored procedures as if they were returned by multiple query executions, and thus as multiple result sets. MySQL++ seems to have no way of dealing with multiple results sets from a multiple query execution. Even though the stored procedure above, get_mysql_sp_test_rec, only returns one result set as a result of one query, it appears that you still have to do some form of cleanup for each query by iterating through the potential result sets and freeing them, which mysql++ seems to have no mechanism for. On to the mysql++ forum ...