Re: Connector/C++ v 8 and binding parameters

[Walter Oney]

Problem solved: the key lies in keeping the istream that sources the blob around until AFTER executing the update statement. In sketch, suppose you have an unsigned character array "blobdata" of length "bloblen":

sql::Driver* driver = get_driver_instance();
sql::Connection* con = driver->connect("tcp://localhost:3306", <user>, <pw>);
sql::PreparedStatement* stmt = con->prepareStatement(<query string>);
…
std::stringstream* s = new stringstream(string((const char*) blobdata, bloblen), ios::in);
stmt->setBlob(<1-based field # in prepared stmt>, s);
…
stmt->executeUpdate();
delete s;