Re: Query insert() Seg Faulting using SSQLS, not sure why...

Sorry for the sequential emails.:

I was able to narrow it down to this:

In the sql_create_N macro I have a blob entry:

mysqlpp::sql_blob, my_blob

If the sql_blob type is in the sql_create call it seg. faults, otherwise it succeeds.

Am I using this wrong?

Thanks,
Graham

On Aug 8, 2007, at 11:03 PM, Graham Reitz wrote:

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

> Here is the call stack:
>
> #0 0x0043e2f7 in std::type_info::operator==
> #1 0x0042c381 in mysqlpp::mysql_type_info::escape_q
> #2 0x004203f2 in
> mysqlpp::ColData_Tmpl<mysqlpp::const_string>::escape_q
> #3 0x004357d8 in mysqlpp::_manip<mysqlpp::const_string>
> #4 0x0042416c in mysqlpp::operator<<
> <mysqlpp::ColData_Tmpl<mysqlpp::const_string> >
> #5 0x00008ccc in operator<< <mysqlpp::quote_type0> at my_tables.hpp:17
> #6 0x000094fc in mysqlpp::Query::insert<clients> at query.h:740
> #7 0x000031a9 in my_db::insert at my_db.cpp:138
> #8 0x0000280e in main at main.cpp:21
>
>
>
>
>
> On Aug 8, 2007, at 10:49 PM, Graham Reitz wrote:
>
>> I broke up the insertion calls as follows:
>>
>> MYSQLPP_QUERY_THISPTR << std::setprecision(16) << "INSERT INTO ";
>> MYSQLPP_QUERY_THISPTR << v.table() << " (";
>> MYSQLPP_QUERY_THISPTR << v.field_list() << ") VALUES (";
>> // It seg. faults on the following line
>> MYSQLPP_QUERY_THISPTR << v.value_list() << ')';
>>
>> Thanks,
>> Graham
>>
>> On Aug 8, 2007, at 10:17 PM, Graham Reitz wrote:
>>
>>> I am using large SSQLS (>50 entries, custom.pl was updated) and
>>> when an insert is performed the program seg. faults in the below
>>> function of query.h:
>>>
>>> template <class T>
>>> Query& insert(const T& v)
>>> {
>>> reset();
>>> // Seg. faults in the section below:
>>> MYSQLPP_QUERY_THISPTR << std::setprecision(16) <<
>>> "INSERT INTO " << v.table() << " (" <<
>>> v.field_list() << ") VALUES (" <<
>>> v.value_list() << ')';
>>> return *this;
>>> }
>>>
>>> Calling code looks like this:
>>> {
>>> Query client_query = m_connection.query();
>>> clients a_client;
>>> populate_client_info(a_client);
>>> client_query.insert(a_client); // seg faults in this call, see
>>> above
>>> }
>>>
>>> When I debug the code it goes for a long while through the
>>> overloaded insertion operators and then eventual seg. faults on
>>> sql_create_53() macro call.
>>>
>>> I am do this on Mac OS X 10.4.10 with Xcode 2.4.1.
>>>
>>> Has anyone else have this problem? I can't help but wonder if
>>> it's somehow related to using MYSQLPP_SSQLS_NO_STATICS.
>>>
>>> Thanks in advance,
>>> Graham
>>>
>>
>
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe: http://lists.mysql.com/plusplus?
> unsub=grahamreitz@mac.com
>
Received on Thu Aug 9 00:14:42 2007