Store data from a mysql database into a C++ variable using mysql connector

Question

So I downloaded the c++/mysql connector from http://dev.mysql.com/downloads/connector/cpp/
Now I want to store data that I've retrieved from the database to a variable. This is as far as I've gotten.

string str;
/////////////////////////////////get data from database////////////////////////////////////////////////////////
  sql::Driver *driver;
  sql::Connection *con;
  sql::Statement *stmt;
  sql::ResultSet *res;

  /* Create a connection */
  driver = get_driver_instance();
  con = driver->connect("tcp://127.0.0.1:3306", "root", "");
  /* Connect to the MySQL test database */
  con->setSchema("awesome");

  stmt= con->createStatement();

      res = stmt->executeQuery(

"SELECT * FROM master where choice='Y'");

/////////////////////////////Store it somewhere/////////////////////////////// 
          str= res->getString("rfid");

Any and all help is welcomed

You have stored data in str variable. What is the question about then? Also posting full example source would be helpful. — alexrider
– alexrider, Commented Apr 14, 2013 at 21:36
Error I get >Unhandled exception at 0x75a54b32 in camera.exe: Microsoft C++ exception: sql::InvalidArgumentException at memory location 0x0026e014.. — Tay Moore
– Tay Moore, Commented Apr 14, 2013 at 21:43

alexrider · Accepted Answer · 2013-04-14 21:53:19Z

2

While it is not that easy to guess what is happening without rest of the code and database data, following code should help to at least get better understanding on what went wrong:

  try
  {
    while (res->next())
    {
          str= res->getString("rfid");
    }
  }
  catch (std::exception &e)
  {
    std::cerr << e.what();
  }

answered Apr 14, 2013 at 21:53

alexrider

4,4631 gold badge19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tay Moore Over a year ago

Thank you so very much! I never thought to even do that even though it's right in the documentation. If I had more rep I'd up vote you.

Collectives™ on Stack Overflow

Store data from a mysql database into a C++ variable using mysql connector

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related