RE: query does not affect database

I do something very similar and it works. I'd move the "user added" message after the commit since if you catch an exception, it still will say user added. It's also not clear that conn and Configuration::conn() are the same.

-----Original Message-----
From: Jack Monflower [mailto:jack.monflower@gmail.com] Sent: Wednesday, September 26, 2007 5:31 AM To: plusplus@lists.mysql.com
Subject: 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."<
}

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.

-- 
MySQL++ Mailing List
For list archives: 
http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=lists@pantek.com
Received on Wed Sep 26 07:58:13 2007