query does not affect database

Hello,

I am trying to add a row to a database.
Connection goes fine (I check if connect returns false, and it does not). I use the following simple code:

if (!conn.connect("mydb", "localhost", "root", "")) {

        cerr<<"could not connect to database. Check databa ngs."<<endl;

       return 0;
}

try {

        Transaction trans(Configuration::conn());
        Query query = Configuration::conn().query();

        user row(userId, userName.c_str());

        query.insert(row);
        query.execute();
        query.reset();
        trans.commit();

catch (const Exception& er) {

        cerr<<er.what()<<endl;

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

        return 0;
}

cerr<<"user added."<<endl;

Everything goes well, compilation as well execution, and the program exits with the message "user added". Still, when I check if anything was added to the database, I see no new rows.

I followed the "xaction.cpp" example, I don't think I missed anything (?)

Any ideas what's wrong?

Thanks for your help.

Jack. Received on Wed Sep 26 05:30:47 2007