prolem in calling mysql C API in C++ project

[Manpreet]

Hi all,

I am using mysql C API in my C++ project. I am using
mysql-4.1.4-gamma and gcc 3.2.2.

Problem with this code is that when add_data(i) is called second time
SEGMENTATION FAULT occurs at mysql_real_query(). First time it
executes the add_data() function successfully.
My Code is

MYSQL db is declared in main.cpp and database connection is also made
in main.cpp.

//main.cpp
add_carrier();

//carrier.cpp
add_carrier()
{
for(i=0;i<3;i++)
{
add_data(i);
}
}
//country.cpp
extern MYSQL db;
add_data(int i)
{
char sqlquery[500];
sprintf(sqlquery,"Select rateid from RATES where carrierid=%d",i);

//*** CAUSES SEGMENTATION FAULT WHEN add_data() IS CALLED SECOND
TIME
mysql_real_query(&db,sqlquery,strlen(sqlquery)); //SEGMENTATION
FAULT
...
...
...

}

Thanx in advance.

Regards,
Manpreet Dhanjal

[Victor Bazarov]

[answering in comp.lang.c++]
Manpreet wrote:

I am using mysql C API in my C++ project. I am using
mysql-4.1.4-gamma and gcc 3.2.2.

Problem with this code is that when add_data(i) is called second time
SEGMENTATION FAULT occurs at mysql_real_query(). First time it
executes the add_data() function successfully.
My Code is

MYSQL db is declared in main.cpp and database connection is also made
in main.cpp.

//main.cpp
add_carrier();

//carrier.cpp
add_carrier()
{
for(i=0;i<3;i++)
{
add_data(i);
}
}
//country.cpp
extern MYSQL db;
add_data(int i)
{
char sqlquery[500];
sprintf(sqlquery,"Select rateid from RATES where carrierid=%d",i);

//*** CAUSES SEGMENTATION FAULT WHEN add_data() IS CALLED SECOND
TIME
mysql_real_query(&db,sqlquery,strlen(sqlquery)); //SEGMENTATION
FAULT
...
...
...

}

The code you posted is neither C nor C++. If I add all the necessary
elements to make it compilable, it still contains plenty of "..." which
doesn't help.

Segmentation faults are usually due to accessing memory using invalid
pointers. Either some pointer gets stumped over, or you cross some array
boundary, or both. In the presented code there is no problem, so I say
it's somewhere in the code you didn't post.

Run your program under a debugger and examine the cause of the seg fault.

V