Re: Prepared Statements not getting closed

[James Barajas]

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