Hi,
I tried to use the following code to retrieve meta data. However, the code crashes when it leaves the try clause (after the for loop finishes). The error message is "Debug Assertion Failed" at dbgdel.cpp line 52. Could anyone please help me resolve the problem?
Thanks.
int main()
{
Environment * env;
Connection * conn;
Statement * stmt;
ResultSet * resultSet;
try
{
env = Environment::createEnvironment(Environment::OBJECT);
conn = env->createConnection("xxx", "xxx", "xxx");
stmt = conn->createStatement("select * from training_security");
resultSet = stmt->executeQuery();
vector<MetaData> selectcols = resultSet->getColumnListMetaData();
int columnCount = selectcols.size();
for (int i = 0; i < columnCount; i++)
{
cout << "column name" << selectcols[i].getString(MetaData::ATTR_NAME) << endl;
cout << "column type" << selectcols[i].getInt(MetaData::ATTR_DATA_TYPE) << endl;
}
}
catch (SQLException &ex)
{//cleanup
cout << "Error, cleaning up..." << ex.getMessage() << endl;
}
// Close ResultSet and Statement
stmt->closeResultSet(resultSet);
conn->terminateStatement(stmt);
env->terminateConnection(conn);
Environment::terminateEnvironment(env);
}