MySQL Forums
Forum List  »  Connector/C++

Mysql/mysql++ and C++
Posted by: Jason none
Date: July 01, 2007 08:23AM

Hi there,
I'm getting very confused with mysql/mysql++.
I've managed to install both successfully and am trying to connect to a database on my local machine.
I've successfully created mysql user (serrix) and a database (TestDB) with a table (TestPlayer) in it.

However i've had no luck using mysql++ to compile there examples and to be honest don't completly follow the examples - it doesn't seem to specify a database, table or user/password.

Distro: Linux Gentoo
Versions: Mysql++ 2.2.2
Mysql 5.0.42

I've also tried Mysql++ 1.7.26

Any help getting either this example or your personal example working would be greatly appreciated, i'd especially be regretful for a working example which will allow me to connect to my database and lead me through the steps of connecting to a local database.

Compiling the first example code found in the documention (example below) with the following script returns this error - please note that the library's are linked:

=============== Error: ===============
scons: Reading SConscript files ...
scons: done reading SConscript files.
scons: Building targets ...
g++ -o bin/main src/main.o -L. -lmysqlclient -lmysqlpp -lmysqlclient
src/main.o: In function `main':
main.cpp:(.text+0xae): undefined reference to `connect_to_db(int, char**, mysqlpp::Connection&, char const*)'
collect2: ld returned 1 exit status
scons: *** [bin/main] Error 1
scons: building terminated because of errors.


=============== SConstruct Script: ===============
listinc=[
'include',
'/usr/include/mysql',
'/usr/include/mysql++',
]
debugcflags=['-g']
releasecflags=[]
env=Environment(CPPPATH=listinc, LIBPATH='.', CCFLAGS = releasecflags)



# list of files needed for compiling the program
main_program_list=Split("""
src/main.cpp
""")


# list of libraries needed for linking
libs_list=Split("""
mysqlclient
mysqlpp
libmysqlclient
""")


env.Program('bin/main', main_program_list, LIBS=libs_list, LIBPATH='.')

=============== Program: (main.cpp) ===============
#include <mysql++.h>

#include <iostream>
#include <iomanip>

using namespace std;

int main(int argc, char *argv[])
{
// Connect to the sample database.
mysqlpp::Connection con(false);
if (!connect_to_db(argc, argv, con)) {
return 1;
}

// Retrieve a subset of the sample stock table set up by resetdb
mysqlpp::Query query = con.query();
query << "select item from stock";
mysqlpp::Result res = query.store();

// Display the result set
cout << "We have:" << endl;
if (res) {
mysqlpp::Row row;
mysqlpp::Row::size_type i;
for (i = 0; row = res.at(i); ++i) {
cout << '\t' << row.at(0) << endl;
}
}
else {
cerr << "Failed to get item list: " << query.error() << endl;
return 1;
}

return 0;
}


Please note that contrary to the error, the function is defined in util.h (which is linked)

=============== util.h ===============
#if !defined(MYSQLPP_UTIL_H)
#define MYSQLPP_UTIL_H

#include <mysql++.h>

extern const char* kpcSampleDatabase;

void print_stock_header(int rows);
void print_stock_row(const mysqlpp::Row& r);
void print_stock_row(const mysqlpp::sql_char& item,
mysqlpp::sql_bigint num, mysqlpp::sql_double weight,
mysqlpp::sql_double price, const mysqlpp::sql_date& date);
void print_stock_rows(mysqlpp::Result& res);
void print_stock_table(mysqlpp::Query& query);
void get_stock_table(mysqlpp::Query& query, mysqlpp::Result& res);
void print_usage(const char* program_name,
const char* extra_parms = "");
bool connect_to_db(int argc, char *argv[], mysqlpp::Connection& con,
const char* kdb = 0);

#endif // !defined(MYSQLPP_UTIL_H)

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql/mysql++ and C++
7334
July 01, 2007 08:23AM
4666
July 16, 2007 03:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.