MySQL Forums
Forum List  »  Connector/C++

Re: Prepared Statements not getting closed
Posted by: James Barajas
Date: August 03, 2012 06:29AM

Andrii,
Thank you for the response.
I added the close and delete calls to the catch clause but it does not solve the problem.
I don't think that part gets executed because an exception is never thrown at least not until I exceed the number of prepared statements and at that point the program aborts.

now the code looks like this:

try {
cout << "executing prepared stmt\n";
res = pstmt->executeQuery();
cout << " closing prepared stmt\n;"
pstmt->close();
delete pstmt;
}
catch (SQLException &e) {
cout << "ERROR: SQLException in " << __FILE__;
cout << " (" << __func__<< ") on line " << __LINE__ << endl;
cout << "ERROR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
if (pstmt != NULL)
{
pstmt->close();
delete pstmt;
}

}


-James

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Prepared Statements not getting closed
3349
August 03, 2012 06:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.