Jose Luis Faria writes:
> Hello,
>
> this my first approach to mysql++.
>
> I have installed
> -----------------------------
> redhat 7.0
> MySQL-shared-3.23.33-1
> MySQL-client-3.23.33-1
> MySQL-3.23.33-1
> MySQL-devel-3.23.33-1
> mysql++-1.7.8-1
>
>
> when I try to build the first example(simpe1.cc attached) this giv me
> some errors, like this:
>
>--------------------------------------------------------------------------------------------
>
> /tmp/ccFoGsdT.o: In function `main':
> /tmp/ccFoGsdT.o(.text+0x30): undefined reference to
> `MysqlConnection::MysqlConnection(char const *, char const *, char const
>
> *, char const *, bool)'
> /tmp/ccFoGsdT.o(.text+0x5bd): undefined reference to `operator<<(ostream
>
> &, mysql_ColData<const_string> const &)'
> /tmp/ccFoGsdT.o(.text+0x6a5): undefined reference to
> `MysqlConnection::~MysqlConnection(void)'
> /tmp/ccFoGsdT.o(.text+0x815): undefined reference to
> `MysqlConnection::~MysqlConnection(void)'
> /tmp/ccFoGsdT.o: In function `MysqlRes::~MysqlRes(void)':
> /tmp/ccFoGsdT.o(.gnu.linkonce.t._._8MysqlRes+0x1d): undefined reference
> to `MysqlResUse::~MysqlResUse(void)'
> /tmp/ccFoGsdT.o: In function `MysqlQuery::preview(void)':
> /tmp/ccFoGsdT.o(.MysqlQuery::gnu.linkonce.t.preview(void)+0x18):
> undefined reference to `SQLQuery::str(SQLQueryParms const &) const'
> /tmp/ccFoGsdT.o: In function `MysqlResUse::num_fields(void) const':
> /tmp/ccFoGsdT.o(.MysqlResUse::gnu.linkonce.t.num_fields(void)
> const+0x10): undefined reference to `mysql_num_fields'
> /tmp/ccFoGsdT.o: In function `MysqlRes::num_rows(void) const':
> /tmp/ccFoGsdT.o(.MysqlRes::gnu.linkonce.t.num_rows(void) const+0x10):
> undefined reference to `mysql_num_rows'
> /tmp/ccFoGsdT.o: In function `MysqlQuery::store(SQLQueryParms &,
> query_reset)':
> /tmp/ccFoGsdT.o(.MysqlQuery::gnu.linkonce.t.store(SQLQueryParms &,
> query_reset) +0x42): undefined reference to `SQLQuery::str(SQLQueryParms
>
> const &, query_reset)'
> /tmp/ccFoGsdT.o: In function
> `MysqlFieldNames::MysqlFieldNames(MysqlResUse const *)':
> /tmp/ccFoGsdT.o(.MysqlFieldNames::gnu.linkonce.t.(MysqlResUse const
> *)+0x42): undefined reference to `MysqlFieldNames::init(MysqlResUse
> const *)'
> /tmp/ccFoGsdT.o: In function `MysqlRes::fetch_row(void) const':
> /tmp/ccFoGsdT.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xba):
> undefined reference to `mysql_fetch_row'
> /tmp/ccFoGsdT.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xce):
> undefined reference to `mysql_fetch_lengths'
> /tmp/ccFoGsdT.o: In function `MysqlRes::data_seek(unsigned int) const':
> /tmp/ccFoGsdT.o(.MysqlRes::gnu.linkonce.t.data_seek(unsigned int)
> const+0x1a): undefined reference to `mysql_data_seek'
> /tmp/ccFoGsdT.o: In function `MysqlConnection::store(basic_string<char,
> string_char_traits<char>, __default_alloc_template<true, 0> > const &)':
>
> /tmp/ccFoGsdT.o(.MysqlConnection::gnu.linkonce.t.store(basic_string<char,
>
> string_char_traits<char>, __default_alloc_template<true, 0> >
> const &)+0x19): undefined reference to
> `MysqlConnection::store(basic_string<char, string_char_traits<char>,
> __default_alloc_template<true, 0> > const &, bool)'
> /tmp/ccFoGsdT.o: In function `FieldTypes::FieldTypes(MysqlResUse const
> *)':
> /tmp/ccFoGsdT.o(.FieldTypes::gnu.linkonce.t.(MysqlResUse const *)+0x42):
>
> undefined reference to `FieldTypes::init(MysqlResUse const *)'
> collect2: ld returned 1 exit status
>
>--------------------------------------------------------------------------------------------
>
> if you can, help me.
>
> thank you very much!
>
> --
>
> --
>
> :) cumprimentos
> ---------------------------------------
> Jose Luis Faria
> Tec. Superior Informatica - Administrador de Sistemas
>
> /\
> /\/\ Departamento de Informatica
> Universidade do Minho
> http://www.di.uminho.pt/jose
>
>
> #include <iostream>
> #include <iomanip>
> #include <sqlplus.hh>
> #include <define_short>
>
> int main() {
> // The full format for the Connection constructor is
> // Connection(cchar *db, cchar *host="",
> // cchar *user="", cchar *passwd="")
> // You may need to specify some of them if the database is not on
> // the local machine or you database username is not the same as your
> // login name, etc..
> try {
> Connection con("ADMIN","127.0.0.1","jose","diogojose");
> Query query = con.query();
> // This creates a query object that is bound to con.
>
> query << "select * from testes";
> // You can write to the query object like you would any other ostrem
>
> Result res = query.store();
> // Query::store() executes the query and returns the results
>
> cout << "Query: " << query.preview() << endl;
> // Query::preview() simply returns a string with the current query
> // string in it.
>
> cout << "Records Found: " << res.size() << endl << endl;
>
> Row row;
> cout.setf(ios::left);
> cout << setw(15) << "ip"
> << setw(5) << "data"
> << "descricao" << endl
> << endl;
>
> Result::iterator i;
> // The Result class has a read-only Random Access Iterator
> for (i = res.begin(); i != res.end(); i++) {
> row = *i;
> cout << setw(17) << row[0].c_str()
> << setw(4) << row[1].c_str()
> << setw(7) << row["weight"].c_str()
> // you can use either the index number or column name
>when
> // retrieving the colume data as demonstrated above.
> << setw(7) << row[3].c_str()
> << row[4] << endl;
> }
> } catch (BadQuery &er) { // handle any connection or
> // query errors that may come up
> #ifdef USE_STANDARD_EXCEPTION
> cerr << "Error: " << er.what() << endl;
> #else
> cerr << "Error: " << er.error << endl;
> #endif
> return -1;
> } catch (BadConversion &er) { // handle bad conversions
> #ifdef USE_STANDARD_EXCEPTION
> cerr << "Error: " << er.what() << "\"." << endl
> << "retrieved data size: " << er.retrieved
> << " actual data size: " << er.actual_size << endl;
> #else
> cerr << "Error: Tried to convert \"" << er.data << "\" to a \""
> << er.type_name << "\"." << endl;
> #endif
> return -1;
> } catch (exception &er) {
> cerr << "Error: " << er.what() << endl;
> return -1;
> }
> return 0;
> }
HI!
You can not use gcc 2.96 supplied with RH 7.0.
You have to downgrade to gcc 2.95.2.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
