	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

10/23/2009 at 10:05AM PDT, ID: 24838620

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.6

Thrown exception not being caught in C++

Asked by edc in C++ Programming Language

Hello all,
Im experiencing a strange issue. I am building a static library, and I have an executable as a test harness that I am using to test various functionality of the library. Below is the complete code of the test harness, (because it is small), and the function in the library which is causing the problem.

The issue is that the exception thrown when the username is not found in the database is not caught by the catch block in the test harness. Thus far this is the only exception that is behaving in this fashion. Every other exception, (that I have tested so far) works as expected, (i.e. is caught by the catch block in the test harness code). The offending lines are:

result = sqlite3_step(stmt);
if( result != SQLITE_ROW )
{
throw MyException("Test");
}

I am using gcc (GCC) 3.4.5 (mingw-vista special) on Windows XP (SP2).

I am really stumped here. Thanks for any help you can offer.

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:

           
           
             Test Harness Code:
int main()
{
    try
    {
        MyServerDatabase database;
        database.CreateDatabase(NULL);
 
        database.OpenDatabase();
        MyUserData *user = new MyUserData();
        database.GetUser("jsmith", user);
    }
 
    catch( MyException e )
    {
        std::string s = e.what();
    }
 
    return 0;
}
 
/*************************************************************************************************************/
 
Library Code Function:
 
void MyServerDatabase::GetUser(std::string userName, MyUserData *user)
{
    if( !m_DatabaseIsOpen )
    {
        throw MyException("The database is not open.  Call OpenDatabase() before attempting to access data.");
    }
 
	sqlite3_stmt *stmt;
	const char *tail;
 
	std::string querySql("SELECT Id, UserName, FullName, Password, Description, State, DeviceId, Lock FROM Users WHERE UserName='" + userName + "';");
 
	int result = sqlite3_prepare_v2(m_Database, querySql.c_str(), querySql.length(), &stmt, &tail);
	if( result != SQLITE_OK )
	{
		throw MyException(sqlite3_errmsg(m_Database));
	}
 
	result = sqlite3_step(stmt);
	if( result != SQLITE_ROW )
	{
        throw MyException("Test");
	}
 
	user->SetDescription((char*)sqlite3_column_text(stmt, 4));
	user->SetFullName((char*)sqlite3_column_text(stmt, 2));
	user->SetPassword((char*)sqlite3_column_text(stmt, 3));
	user->SetDeviceId(sqlite3_column_int(stmt, 6));
	user->SetIsLocked(sqlite3_column_int(stmt, 7));
	user->SetRowIdentifier(sqlite3_column_int(stmt, 0));
	user->SetState((UserState)sqlite3_column_int(stmt, 5));
	user->SetUserName((char*)sqlite3_column_text(stmt, 1));
 
	result = sqlite3_step(stmt);
	if( result != SQLITE_DONE )
	{
		throw MyException("The database is corrupt.  Multiple users with username " + userName + " were found in the database.");
	}
 
	result = sqlite3_finalize(stmt);
	if( result != SQLITE_OK )
	{
		throw MyException(sqlite3_errmsg(m_Database));
	}
}

           
         

20090824-EE-VQP-74 - Hierarchy / EE_QW_3_20080625

1. jkr621,554
2. Infinity08428,105
3. evilrix386,063
4. itsmeandn...345,939
5. mrjoltcola136,370
6. pgnatyuk80,095
7. Zoppo69,160
8. alb6660,430
9. AndyAins...48,452
10. trinitrotolu...48,102
11. DanRollins45,961
12. Let_Me_Be43,756
13. ozo40,128
14. Gideon737,720
15. jaime_oliv...36,480
16. pepr30,816
17. ikework23,327
18. sunnycoder20,168
19. masheik18,698
20. LordOfPo...18,490
21. JohnGaby18,296
22. johnnash...17,769
23. josgood17,000
24. abel16,556
25. Gurudenis16,260

1. jkr7,897,645
2. itsmeandn...2,356,347
3. Infinity081,955,516
4. Axter1,467,234
5. evilrix1,041,001
6. nietod859,677
7. AlexFM732,762
8. DanRollins729,138
9. jaime_oliv...725,383
10. rstaveley524,876
11. grg99392,524
12. efn329,300
13. chensu313,112
14. AlexViroc...263,393
15. Zoppo255,353
16. Salte247,544
17. ikework219,121
18. wayside215,557
19. jhance207,462
20. rajeev_d...207,388
21. ambience183,231
22. AndyAins...183,072
23. sunnycoder180,898
24. bcladd171,128
25. SteH170,387

Thrown exception not being caught in C++

Asked by edc in C++ Programming Language

About this solution