mysqlcppapi-main

[Mysqlcppapi-main] Simplifying Connection

[Jonathan W. <co...@co...>]

In addition to removing the 2-stage construction (see other thread) I'd
like to further simplify the Connection by using the initialisation list
in the default constructor:

   Connection::Connection()
   : m_bLocked(new bool(false)), m_bSuccess(new bool(false))
   // etc. etc.
   { }

The copy ctor and assignment operator should be OK using the
compiler-generated one, rather than explicitly defining it, as all
members are builtins or types with correct destructors.

All comments welcome, especially if I've missed some reason this won't
work!

jon

-- 
"There is nothing noble in being superior to your fellow men -
 true nobility is being superior to your former self."
	- www.radiohead.com

[Mysqlcppapi-main] Remove 2-stage allocation in smart pointer

[Jonathan W. <co...@co...>]

Inspecting the code I think I've found a problem, or at least an
unnecessary complication.

Firstly, Allocator_Zeroed is only suitable for allocating certain types,
since it creates a new instance and then zeroes its bytes.

This is used to allocate objects of type MYSQL and initialise them to
zero. This makes assumptions about struct MYSQL and is not portable if
the struct contains a pointer, since there's no guarantee that the NULL
pointer is represented by an all-zero bit pattern (although on most
real-world systems it is). I think the only _truly_ portable way to
initialise a pointer is by assinging 0 to it.

This code shows how that allocator breaks a class' invariants:

    #include <cassert>
    #include "mysqlcppapi/smartpointer/SharedPtr.h"

    struct Five
    {
        const int i;
        Five() : i(5) {}
    };

    using namespace mysqlcppapi;

    int main()
    {
        SharedPtr<Five, Allocator_Zeroed<Five> > sp;
        assert( sp->i == 5 );
    }


This problem stems from the fact that a default constructed SharedPtr
contains a default constructed pointee, rather than being NULL. This
requirement means that the pointee type must be default constructable
and must not mind being zeroed if Allocator_Zeroed is used.


Allocator_Connection uses Allocator_Zeroed, and so contains the above
problem. Since the zeroed MYSQL structure is passed immediately to
mysql_init() (which initialises it correctly) there is no danger of
using the zeroed (incorrectly initialised) structure. Therefore it's
not wrong, per se - but it smells a bit. I would prefer not to have a
template that is only safe to use for POD types.

I believe this could be avoided by making Allocator_Connection
not use Allocator_Zeroed at all, but let mysql_init() allocate the
structure. This would mean that mysql_close() must be called
unconditionally in deallocate(), so the structure will be deallocated.
This would greatly simplify the SharedPtr code by removing the 2-stage
allocate+initialise combination, and therefore remove the need
for the Do2ndStageDeallocation feature.

deallocate() would call mysql_close() whether the connection was
opened or not (which is correct, since it must free the memory that
mysql_init() reserved).

The attached patch shows basically what I mean, but is not complete (*)

Comments, thoughts?

jon


(*) the SharedPtr class still stores the do2ndStageDeallocation member,
it just doesn't pass it to the allocator's deallocate() function ...

... changing that would mean the Connection can't tell if it's
connected, but that's easy to change by adding a new shared_ptr<bool>
in Connection  ...

... but since Collection is basically an aggregation of several
shared_ptr objects we could simplify it further by making Collection
just a wrapper around a single shared_ptr<Collection::Impl> and make
Collection::Impl hold actual types
e.g.
    class Collection {
      // ...
      class Impl;  // fwd decl
      shared_ptr<Impl> m_pimpl;
    };

    class Collection::Impl {
      // ...
      std::string unixsocketstr;
      int  port;
      int  timeout;
      bool locked;
      bool success;
      bool connected;
    };

but this is all for later discussion.


--
To conquer oneself is a greater task than conquering others.
	- Buddha 

Re: [Mysqlcppapi-main] MySQL dependencies

[Jonathan W. <co...@co...>]

On Wed, Sep 22, 2004 at 11:38:49AM +0200, Marc Sturm wrote:

> Hello,
> 
> I'm just testing the mysqlcppapi library and have a question:
> Is it right that it needs libmysqlclient in version 3.23 as stated on
> http://freshmeat.net/projects/mysqlcppapi/ , or should it work with
> version 4.0.18 as well?

No, it will work fine with 4.0, and I believe 4.1 (someone recently sent
a bug report that prevented compiling against 4.1, so it's fixed in
CVS)

> Is there an update planned for MySQL 4.0?

The CVS version will work fine, I'm not 100% sure the latest release
will - you can try though. If it compiles it should work fine.

I will make another release soon which will definitely woork with 4.x
and I'll update the freshmeat page, thanks for pointing it out.

jon

-- 
"Sell your cleverness and buy bewilderment:
 Cleverness is mere opinion, bewilderment is intuition."
	- Jalal-uddin Rumi

[Mysqlcppapi-main] MySQL dependencies

[Marc S. <st...@in...>]

Hello,

I'm just testing the mysqlcppapi library and have a question:
Is it right that it needs libmysqlclient in version 3.23 as stated on
http://freshmeat.net/projects/mysqlcppapi/ , or should it work with
version 4.0.18 as well?
Is there an update planned for MySQL 4.0?

Thanks in advance,
  Marc Sturm

Re: [Mysqlcppapi-main] RE: install problems

[Jonathan W. <co...@co...>]

> From: Jonathan Wakely [mailto:jw...@mi...] 
> 
> I've downloaded the 4.1.3 sources and that fix won't work,
> SHUTDOWN_DEFAULT is an enum, not a macro
> (bah! who uses all-caps for enums?!)
> 
> but something like this should work ok:
> 
> #if MYSQL_VERSION_ID >= 40103
>   bool suc = !(mysql_shutdown(m_sharedptr_connection.obj(),
> SHUTDOWN_DEFAULT));
> #else
>   bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));
> #endif

For the record ...

I considered making the signature of Connection::shutdown() vary
depending on the MySQL version (so you could pass in an
enum_shutdown_level if compiling against 4.1.3 or higher)

I decided against it for several reasons, including

* Would make the mysqlcppapi API different depending what headers you
  compile it against. This seems like a recipe for ODR violations.
  (Might not be an issue since the libmysqlclient ABI changed anyway)

* There's currently only one value for that enum, so no point in
  allowing different values to be passed in.

If alternative shutdown arguments are added in the future mysqlcppapi
might support them, but not right now.

jon

-- 
"In times like these, it helps to recall that there have always been
 times like these."
	- Paul Harvey

Re: [Mysqlcppapi-main] RE: install problems

['Jonathan W. <co...@co...>]

On Tue, Aug 10, 2004 at 05:05:53PM -0600, Neil Chakrabarty wrote:

> Sorry to keep bothering, but I can't figure this error out when making the
> library:

That's OK. I misunderstood earlier and thought you meant you had built
mysqlcppapi but couldn't link your own program, so wasn't very clear.

> /usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/../../../crtn.o  -Wl,-soname
> -Wl,libmysqlcppapi-1.9-1.9.so.4 -o .libs/libmysqlcppapi-1.9-1.9.so.4.0.0
> /usr/bin/ld: cannot find -lmysqlclient
               ^^^^^^^^^^^^^^^^^^^^^^^^^
This is the only bit of interest, when creating the mysqlcppapi library
the linker tries to find the MySQL client library, so you need to tell
the linker how to find the file libmysqlclient.so

You must specify the path to your mysql installation when you configure
the library, by using --with-mysql
e.g.
    ./configure --with-mysql=/usr/local/mysql --other-args ...

If make still fails then you can tell the linker exactly where to find
the lib by setting the LDFLAGS variable when running configure. The value
of that variable will be passed directly to the linker.
e.g.
    LDFLAGS=-L/usr/local/mysql/lib ./configure --other-args ...

The directory you specify with -L in the LDFLAGS variable should be the
one that contains libmysqlclient.so, which you should be able to find by
typing "locate libmysqlclient".

Let me know what the output of "locate" is and what options you passed
to configure if you still can't build mysqlcppapi.

jon

-- 
"Probably all laws are useless; for good men do not need laws at all,
 and bad men are made no better by them."
	- Demonax the Cynic

RE: [Mysqlcppapi-main] RE: install problems

[Neil C. <nch...@uc...>]

Sorry to keep bothering, but I can't figure this error out when making the
library:

/bin/sh ../libtool --mode=link g++ -I/usr/share/mysql/include -g -O2   -o
libmysqlcppapi-1.9.la -rpath /usr/local/lib -version-info 4:0:0 -release 1.9
ColData.lo Connection.lo Allocator_Connection.lo string_util.lo
datetime/libdatetime.la exceptions/libexceptions.la fields/libfields.la
query/libquery.la query_results/libquery_results.la row/librow.la -lnsl
-lintl  -L/usr/share/mysql/lib/mysql -lmysqlclient -L/usr/share/lib/mysql
-lmysqlclient
g++ -shared -nostdlib
/usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/../../../crti.o
/usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/crtbeginS.o  .libs/ColData.o
.libs/Connection.o .libs/Allocator_Connection.o .libs/string_util.o
-Wl,--whole-archive datetime/.libs/libdatetime.a
exceptions/.libs/libexceptions.a fields/.libs/libfields.a
query/.libs/libquery.a query_results/.libs/libquery_results.a
row/.libs/librow.a -Wl,--no-whole-archive  -lnsl /usr/lib/libintl.so
-L/usr/share/mysql/lib/mysql -L/usr/share/lib/mysql -lmysqlclient
-L/usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2
-L/usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/../../.. -lstdc++ -lm -lc
-lgcc_s /usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/crtendS.o
/usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/../../../crtn.o  -Wl,-soname
-Wl,libmysqlcppapi-1.9-1.9.so.4 -o .libs/libmysqlcppapi-1.9-1.9.so.4.0.0
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make[3]: *** [libmysqlcppapi-1.9.la] Error 1
make[3]: Leaving directory `/home/creus/mysqlcppapi-1.9.3/mysqlcppapi'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/home/creus/mysqlcppapi-1.9.3/mysqlcppapi'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/creus/mysqlcppapi-1.9.3'
make: *** [all] Error 2

-----Original Message-----
From: Jonathan Wakely [mailto:co...@co...] 
Sent: Tuesday, August 10, 2004 10:09 AM
To: Neil Chakrabarty
Cc: mys...@li...
Subject: Re: [Mysqlcppapi-main] RE: install problems

(back on my usual email address now)

On Tue, Aug 10, 2004 at 09:50:34AM -0600, Neil Chakrabarty wrote:

> The code you have provided prevents the compiler error.

Cool, thanks for testing it. I'll commit that this evening.

> But now I get the following error:
> /usr/bin/ld: cannot find -lmysqlclient
> 
> I have installed the client and library for 4.1.3.0

Then you need to tell the compiler/linker where to find
libmysqlclient.so with a -L switch.

It's often installed in /usr/local/lib/mysql or /usr/local/mysql/lib

jon

> 
> -----Original Message-----
> From: Jonathan Wakely [mailto:jw...@mi...] 
> Sent: Tuesday, August 10, 2004 8:25 AM
> To: Neil Chakrabarty
> Cc: mys...@li...
> Subject: RE: install problems
> 
> 
> I've downloaded the 4.1.3 sources and that fix won't work,
> SHUTDOWN_DEFAULT is an enum, not a macro
> (bah! who uses all-caps for enums?!)
> 
> but something like this should work ok:
> 
> #if MYSQL_VERSION_ID >= 40103
>   bool suc = !(mysql_shutdown(m_sharedptr_connection.obj(),
> SHUTDOWN_DEFAULT));
> #else
>   bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));
> #endif
> 
> I *think* that's the right ID for 4.1.3, it's defined in the installed
> mysql_version.h
> 
> jon
> 
> 
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Mysqlcppapi-main mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlcppapi-main

-- 
"Political satire became obsolete when Henry Kissinger was awarded the
 Nobel Prize."
	- Tom Lehrer

[Mysqlcppapi-main] [patch] Simplify Connection.cc

[Jonathan W. <co...@co...>]

I propose committing this patch to mysqlcppapi/Connection.cc

It introduces two inline utility functions that simplify the rest of the
file by making std::string to const char* conversions where an empty
string becomes a null pointer and vice versa.

Also adds the mysql_error() msg to the exception thrown when connection
fails.

I'll commit soon, after waiting for any comments.

jon


-- 
"Strange how potent cheap music is."
	- Noël Coward

Re: [Mysqlcppapi-main] RE: install problems

[Jonathan W. <co...@co...>]

(back on my usual email address now)

On Tue, Aug 10, 2004 at 09:50:34AM -0600, Neil Chakrabarty wrote:

> The code you have provided prevents the compiler error.

Cool, thanks for testing it. I'll commit that this evening.

> But now I get the following error:
> /usr/bin/ld: cannot find -lmysqlclient
> 
> I have installed the client and library for 4.1.3.0

Then you need to tell the compiler/linker where to find
libmysqlclient.so with a -L switch.

It's often installed in /usr/local/lib/mysql or /usr/local/mysql/lib

jon

> 
> -----Original Message-----
> From: Jonathan Wakely [mailto:jw...@mi...] 
> Sent: Tuesday, August 10, 2004 8:25 AM
> To: Neil Chakrabarty
> Cc: mys...@li...
> Subject: RE: install problems
> 
> 
> I've downloaded the 4.1.3 sources and that fix won't work,
> SHUTDOWN_DEFAULT is an enum, not a macro
> (bah! who uses all-caps for enums?!)
> 
> but something like this should work ok:
> 
> #if MYSQL_VERSION_ID >= 40103
>   bool suc = !(mysql_shutdown(m_sharedptr_connection.obj(),
> SHUTDOWN_DEFAULT));
> #else
>   bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));
> #endif
> 
> I *think* that's the right ID for 4.1.3, it's defined in the installed
> mysql_version.h
> 
> jon
> 
> 
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Mysqlcppapi-main mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlcppapi-main

-- 
"Political satire became obsolete when Henry Kissinger was awarded the
 Nobel Prize."
	- Tom Lehrer

[Mysqlcppapi-main] RE: install problems

[Neil C. <nch...@uc...>]

The code you have provided prevents the compiler error.

But now I get the following error:
/usr/bin/ld: cannot find -lmysqlclient

I have installed the client and library for 4.1.3.0

-----Original Message-----
From: Jonathan Wakely [mailto:jw...@mi...] 
Sent: Tuesday, August 10, 2004 8:25 AM
To: Neil Chakrabarty
Cc: mys...@li...
Subject: RE: install problems


I've downloaded the 4.1.3 sources and that fix won't work,
SHUTDOWN_DEFAULT is an enum, not a macro
(bah! who uses all-caps for enums?!)

but something like this should work ok:

#if MYSQL_VERSION_ID >= 40103
  bool suc = !(mysql_shutdown(m_sharedptr_connection.obj(),
SHUTDOWN_DEFAULT));
#else
  bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));
#endif

I *think* that's the right ID for 4.1.3, it's defined in the installed
mysql_version.h

jon

[Mysqlcppapi-main] RE: install problems

[Jonathan W. <jw...@mi...>]

I've downloaded the 4.1.3 sources and that fix won't work,
SHUTDOWN_DEFAULT is an enum, not a macro
(bah! who uses all-caps for enums?!)

but something like this should work ok:

#if MYSQL_VERSION_ID >= 40103
  bool suc = !(mysql_shutdown(m_sharedptr_connection.obj(),
SHUTDOWN_DEFAULT));
#else
  bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));
#endif

I *think* that's the right ID for 4.1.3, it's defined in the installed
mysql_version.h

jon

RE: [Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Liu, Y. <Yig...@an...>]

Hi Jonathan,

Thanks for your reply. It happens during connection setup. I added a
pair of printout statements before and after each line in the code. Here
are what I got:

bash-2.03$ ./simple1
before mysqlcppapi::Connection con;...
after mysqlcppapi::Connection con;...
before con.connect();...
Bus Error (core dumped)
bash-2.03$

And I got the stack trace here:

#0  0xff0422f0 in _free_unlocked () from /usr/lib/libc.so.1
(gdb) bt
#0  0xff0422f0 in _free_unlocked () from /usr/lib/libc.so.1
#1  0xff0422a8 in free () from /usr/lib/libc.so.1
#2  0xff307490 in mysql_close () from
/usr/local/lib/libmysqlclient.so.10
(gdb) q

And exception handling works for my c++ program. I can throw and catch
exceptions.

Thanks a lot for your kind help!

Yigong


-----Original Message-----
From: Jonathan Wakely [mailto:co...@co...]=20
Sent: Tuesday, August 10, 2004 7:36 AM
To: Liu, Yigong
Cc: mys...@li...
Subject: Re: [Mysqlcppapi-main] where to find libmysqlclient.so for
Solaris 2.8 with gcc 3.3

On Thu, Aug 05, 2004 at 11:16:43AM -0400, Liu, Yigong wrote:

> Hi there,

hi again, yigong

> Thanks for the reply.
>=20
> Another question, I tried simple1 (the first example) and I have no
> database server running locally, so it fails. However, it will crash
the
> whole program, not close down gracely. I check simple1.cc, although
> there are catch statement for exceptions and I also add catch(...) to
> catch all other exceptions, it still crashes. Does exception-handling
> work in mysqlcppapi?

It works for me - if the connection is not opened an exception is
thrown and caught by the first catch() block.

Have you debugged the program to see where the crash is?
It could be before the exception is even thrown, or it could be a
problem with exception-handling in your environment.
If you can send a stacktrace I might be able to figure it out.

jon


--=20
"Nothing is true. Everything is permissible."
	- Hassan i Sabbah


---------------------------------------------------------------------------=
---------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information. =20
If you have received it in error, please notify the sender
immediately and delete the original.  Any unauthorized use of
this email is prohibited.
---------------------------------------------------------------------------=
---------------------
[mf2]

[Mysqlcppapi-main] RE: install problems

[Jonathan W. <jw...@mi...>]

Hi Neil,

According to http://dev.mysql.com/doc/mysql/en/mysql_shutdown.html the
second argument was added in MySQL 4.1.3

I've been compiling and testing against 4.0 (since I'm still cautious
about using beta code from mysql)

Could you change the offending line in mysqlcppapi/Connection.cc to this
and let me know if it works?

#ifdef SHUTDOWN_DEFAULT
  bool suc = !(mysql_shutdown(m_sharedptr_connection.obj(),
SHUTDOWN_DEFAULT));
#else
  bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));
#endif

I'll look for a better way of detecting which form to use before
committing, but this should let you compile against the 4.1 API

regards,

jon







"Neil Chakrabarty" <nch...@uc...> on 10/08/2004 15:00:08

To:   Jonathan Wakely/MINTEL/GB@MINTEL,
      mys...@li...
cc:
Subject:  RE: install problems



Jon,

Thanks for the help, I am using gcc 3.3.2.   I am currently trying
v1.9.3
but I now get the following error when running make.

g++ -DHAVE_CONFIG_H -I. -I. -I.. -I.. -I/usr/share/mysql//mysql/include
-g
-O2 -MT Connection.lo -MD -MP -MF .deps/Connection.Tpo -c Connection.cc
-fPIC -DPIC -o .libs/Connection.o
/usr/include/mysql/mysql.h: In member function `bool
mysqlcppapi::Connection::shutdown()':
/usr/include/mysql/mysql.h:458: error: too few arguments to function
`int
mysql_shutdown(MYSQL*, enum_shutdown_level)'
Connection.cc:215: error: at this point in file

When I look at Connection.cc line 215, I see the following:

bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));

The compiler is correct in saying it is missing an argument.

-Neil

-----Original Message-----
From: Jonathan Wakely [mailto:jw...@mi...]
Sent: Tuesday, August 10, 2004 4:20 AM
To: mys...@li...
Cc: nch...@uc...
Subject: Re: install problems


Neil,

You don't say so, but I inferred from the errors you posted that you're
using GCC 3.3

mysqlcppapi 1.9.0 uses too many non-standard C++ features (such as
stdlib headers with .h appended)

Please try v1.9.3 which contains numerous fixes to work with GCC 3.3

regards,

jon




http://www.mintel.com

London Office:
Mintel International Group Ltd (Mintel)
18-19 Long Lane
London
EC1A 9PL
UK

Tel: 020 7606 4533
Fax: 020 7606 5932

Chicago Office:
Mintel International Group Ltd (Mintel)
213 West Institute Place
Suite #208
Chicago
IL 60610
USA

Tel: 312 932 0400
Fax: 312 932 0469

Notice
********
This email may contain information that is privileged,
confidential or otherwise protected from disclosure. It
must not be used by, or its contents copied or disclosed
to, persons other than the addressee. If you have received
this email in error please notify the sender immediately
and delete the email. Any views or opinions expressed in
this message are solely those of the author, and do not
necessarily reflect those of Mintel.

No Mintel staff are authorised to make purchases using
email or over the internet, and any contracts so performed
are invalid.

Warning
**********
It is the responsibility of the recipient to ensure that
the onward transmission, opening or use of this message
and any attachments will not adversely affect their systems
or data. Please carry out such virus and other checks, as
you consider appropriate.

[Mysqlcppapi-main] RE: install problems

[Neil C. <nch...@uc...>]

Jon,

Thanks for the help, I am using gcc 3.3.2.   I am currently trying v1.9.3
but I now get the following error when running make.

g++ -DHAVE_CONFIG_H -I. -I. -I.. -I.. -I/usr/share/mysql//mysql/include -g
-O2 -MT Connection.lo -MD -MP -MF .deps/Connection.Tpo -c Connection.cc
-fPIC -DPIC -o .libs/Connection.o
/usr/include/mysql/mysql.h: In member function `bool
mysqlcppapi::Connection::shutdown()':
/usr/include/mysql/mysql.h:458: error: too few arguments to function `int
mysql_shutdown(MYSQL*, enum_shutdown_level)'
Connection.cc:215: error: at this point in file

When I look at Connection.cc line 215, I see the following:

bool suc = !(mysql_shutdown(m_sharedptr_connection.obj()));

The compiler is correct in saying it is missing an argument.

-Neil

-----Original Message-----
From: Jonathan Wakely [mailto:jw...@mi...] 
Sent: Tuesday, August 10, 2004 4:20 AM
To: mys...@li...
Cc: nch...@uc...
Subject: Re: install problems


Neil,

You don't say so, but I inferred from the errors you posted that you're
using GCC 3.3

mysqlcppapi 1.9.0 uses too many non-standard C++ features (such as
stdlib headers with .h appended)

Please try v1.9.3 which contains numerous fixes to work with GCC 3.3

regards,

jon




http://www.mintel.com

London Office:
Mintel International Group Ltd (Mintel)
18-19 Long Lane
London
EC1A 9PL
UK

Tel: 020 7606 4533
Fax: 020 7606 5932

Chicago Office:
Mintel International Group Ltd (Mintel)
213 West Institute Place
Suite #208
Chicago
IL 60610
USA

Tel: 312 932 0400
Fax: 312 932 0469

Notice
********
This email may contain information that is privileged,
confidential or otherwise protected from disclosure. It
must not be used by, or its contents copied or disclosed
to, persons other than the addressee. If you have received
this email in error please notify the sender immediately
and delete the email. Any views or opinions expressed in
this message are solely those of the author, and do not
necessarily reflect those of Mintel.

No Mintel staff are authorised to make purchases using
email or over the internet, and any contracts so performed
are invalid.

Warning
**********
It is the responsibility of the recipient to ensure that
the onward transmission, opening or use of this message
and any attachments will not adversely affect their systems
or data. Please carry out such virus and other checks, as
you consider appropriate.

Re: [Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Jonathan W. <co...@co...>]

On Thu, Aug 05, 2004 at 11:16:43AM -0400, Liu, Yigong wrote:

> Hi there,

hi again, yigong

> Thanks for the reply.
> 
> Another question, I tried simple1 (the first example) and I have no
> database server running locally, so it fails. However, it will crash the
> whole program, not close down gracely. I check simple1.cc, although
> there are catch statement for exceptions and I also add catch(...) to
> catch all other exceptions, it still crashes. Does exception-handling
> work in mysqlcppapi?

It works for me - if the connection is not opened an exception is
thrown and caught by the first catch() block.

Have you debugged the program to see where the crash is?
It could be before the exception is even thrown, or it could be a
problem with exception-handling in your environment.
If you can send a stacktrace I might be able to figure it out.

jon


-- 
"Nothing is true. Everything is permissible."
	- Hassan i Sabbah

[Mysqlcppapi-main] Re: install problems

[Jonathan W. <jw...@mi...>]

Neil,

You don't say so, but I inferred from the errors you posted that you're
using GCC 3.3

mysqlcppapi 1.9.0 uses too many non-standard C++ features (such as
stdlib headers with .h appended)

Please try v1.9.3 which contains numerous fixes to work with GCC 3.3

regards,

jon




http://www.mintel.com

London Office:
Mintel International Group Ltd (Mintel)
18-19 Long Lane
London
EC1A 9PL
UK

Tel: 020 7606 4533
Fax: 020 7606 5932

Chicago Office:
Mintel International Group Ltd (Mintel)
213 West Institute Place
Suite #208
Chicago
IL 60610
USA

Tel: 312 932 0400
Fax: 312 932 0469

Notice
********
This email may contain information that is privileged,
confidential or otherwise protected from disclosure. It
must not be used by, or its contents copied or disclosed
to, persons other than the addressee. If you have received
this email in error please notify the sender immediately
and delete the email. Any views or opinions expressed in
this message are solely those of the author, and do not
necessarily reflect those of Mintel.

No Mintel staff are authorised to make purchases using
email or over the internet, and any contracts so performed
are invalid.

Warning
**********
It is the responsibility of the recipient to ensure that
the onward transmission, opening or use of this message
and any attachments will not adversely affect their systems
or data. Please carry out such virus and other checks, as
you consider appropriate.

[Mysqlcppapi-main] Install problems

[Neil C. <nch...@uc...>]

Hi,

 

I am trying to install v 1.9.0 and configure runs without error.

 

However when I run make, I get the following errors:

 

make  all-recursive

make[1]: Entering directory
`/home/creus/mysqlcppapi-1.9.0/mysqlcppapi-1.9.0'

Making all in mysqlcppapi

make[2]: Entering directory
`/home/creus/mysqlcppapi-1.9.0/mysqlcppapi-1.9.0/mysqlcppapi'

Making all in datetime

make[3]: Entering directory
`/home/creus/mysqlcppapi-1.9.0/mysqlcppapi-1.9.0/mysqlcppapi/datetime'

/bin/sh ../../libtool --mode=compile g++ -DHAVE_CONFIG_H -I. -I. -I../..
-I../..    -g -O2 -I/usr/share/mysql/mysql/include
-I/usr/share/mysql/mysql/include -c Date.cc

rm -f .libs/Date.lo

g++ -DHAVE_CONFIG_H -I. -I. -I../.. -I../.. -g -O2
-I/usr/share/mysql/mysql/include -I/usr/share/mysql/mysql/include -c Date.cc
-fPIC -DPIC -o .libs/Date.lo

In file included from datetime_base.h:4,

                 from date_base.h:4,

                 from Date.h:5,

                 from Date.cc:1:

stream2string.h:4:23: strstream.h: No such file or directory

In file included from datetime_base.h:4,

                 from date_base.h:4,

                 from Date.h:5,

                 from Date.cc:1:

stream2string.h: In function `Strng mysqlcppapi::stream2string(const T&)':

stream2string.h:14: error: syntax error before `;' token

In file included from date_base.h:4,

                 from Date.h:5,

                 from Date.cc:1:

datetime_base.h:7:23: strstream.h: No such file or directory

In file included from date_base.h:4,

                 from Date.h:5,

                 from Date.cc:1:

stream2string.h: In function `Strng mysqlcppapi::stream2string(const T&)
[with Strng = std::string, T = mysqlcppapi::datetime_base]':

datetime_base.h:27:   instantiated from here

stream2string.h:15: error: `str' undeclared (first use this function)

stream2string.h:15: error: (Each undeclared identifier is reported only once
for each function it appears in.)

stream2string.h:16: error: `ends' undeclared (first use this function)

In file included from Date.h:5,

                 from Date.cc:1:

date_base.h: At global scope:

date_base.h:22: error: syntax error before `&' token

In file included from ../exceptions/ex_BadNullConversion.h:4,

                 from ../null.h:4,

                 from ../ColData.h:8,

                 from Date.h:6,

                 from Date.cc:1:

../exceptions/ex_base.h:26: error: 'string' is used as a type, but is not
defined as a type.

../exceptions/ex_base.h:21: error: looser throw specifier for `virtual
mysqlcppapi::ex_base::~ex_base()'

/usr/include/c++/3.3.2/exception:56: error:   overriding `virtual
std::exception::~exception() throw ()'

../exceptions/ex_base.h:21: error: looser throw specifier for `virtual
mysqlcppapi::ex_base::~ex_base()'

/usr/include/c++/3.3.2/exception:56: error:   overriding `virtual
std::exception::~exception() throw ()'

../exceptions/ex_base.h:21: error: looser throw specifier for `virtual
mysqlcppapi::ex_base::~ex_base()'

/usr/include/c++/3.3.2/exception:56: error:   overriding `virtual
std::exception::~exception() throw ()'

make[3]: *** [Date.lo] Error 1

make[3]: Leaving directory
`/home/creus/mysqlcppapi-1.9.0/mysqlcppapi-1.9.0/mysqlcppapi/datetime'

make[2]: *** [all-recursive] Error 1

make[2]: Leaving directory
`/home/creus/mysqlcppapi-1.9.0/mysqlcppapi-1.9.0/mysqlcppapi'

make[1]: *** [all-recursive] Error 1

make[1]: Leaving directory `/home/creus/mysqlcppapi-1.9.0/mysqlcppapi-1.9.0'

make: *** [all-recursive-am] Error 2

 

Any suggestions?

 

-Neil

[Mysqlcppapi-main] why simple1.cc doesn't catch exception correctly

[Liu, Y. <Yig...@an...>]

Hi there,

I still have the problem with example simple1.cc.=20

In original simple1.cc code, it connect to a local server. Locally, I
didn't run mysql database daemon/server because of other reason. So when
I run simple1, it should fail to connect and throw some exception, which
should be caught by one of the "catch" statements ( and I added
catch(...) which suppose to catch all uncaught exceptions ) and exit
gracely. However, it always crashes. Does mysqlcppapi throw exceptions
when it cannot connect to mysql server?

Thanks

Yigong

-----Original Message-----
From: Jonathan Wakely [mailto:co...@co...]=20
Sent: Thursday, August 05, 2004 1:16 PM
To: Liu, Yigong
Cc: mys...@li...
Subject: Re: [Mysqlcppapi-main] where to find libmysqlclient.so for
Solaris 2.8 with gcc 3.3

On Thu, Aug 05, 2004 at 11:21:58AM -0400, Liu, Yigong wrote:

> Also for some reasons I cannot start mysql daemon locally. So I tried
to
> connect to a remote server with simple changes to simple1.cc.
>=20
> I added con.set_Host, set_User, set_Passwd(). It still crashes. Any
> clue?

Hello again,

I'll take a look at your problems when I get home in a couple of hours.
Sorry for the delay,

jon

>=20
> I tried mysql++, at least it allows me to connect to the remote
server;
> although it has the same issue of exception handling.
>=20
> Thanks
>=20
> Yigong
>=20
>=20
> -----Original Message-----
> From: Liu, Yigong=20
> Sent: Thursday, August 05, 2004 11:23 AM
> To: 'Jonathan Wakely'
> Cc: mys...@li...
> Subject: RE: [Mysqlcppapi-main] where to find libmysqlclient.so for
> Solaris 2.8 with gcc 3.3
>=20
> Hi there,
>=20
> Thanks for the reply.
>=20
> Another question, I tried simple1 (the first example) and I have no
> database server running locally, so it fails. However, it will crash
the
> whole program, not close down gracely. I check simple1.cc, although
> there are catch statement for exceptions and I also add catch(...) to
> catch all other exceptions, it still crashes. Does exception-handling
> work in mysqlcppapi?
>=20
> Thanks a lot
> Yigong
>=20
>=20
> -----Original Message-----
> From: Jonathan Wakely [mailto:co...@co...]=20
> Sent: Thursday, August 05, 2004 5:25 AM
> To: Liu, Yigong
> Cc: mys...@li...
> Subject: Re: [Mysqlcppapi-main] where to find libmysqlclient.so for
> Solaris 2.8 with gcc 3.3
>=20
> On Wed, Aug 04, 2004 at 06:09:59PM -0400, Liu, Yigong wrote:
>=20
> > Hi there, Murray and any other experts,
>=20
> Hi,
>=20
> > I am building mysqlcppapi1.9.3 on Solaris2.8 with gcc3.3.2.
Everything
> > went good until I hit "ld : cannot find -lmysqlclient."
>=20
> I assume this is when linking, not when running, the program?
>=20
> > Could you please give me some hints about where I can find it?
>=20
> On a number of systems mysql libs are installed in
${prefix}/lib/mysql/
> rather than ${prefix}/lib
>=20
> So you might want to try -L/usr/local/mysql/lib/mysql or similar.
>=20
> These pages might help too:
> http://dev.mysql.com/doc/mysql/en/Solaris.html
> http://dev.mysql.com/doc/mysql/en/Solaris_2.7.html
> http://dev.mysql.com/doc/mysql/en/Installation_layouts.html
>=20
> Hope that helps,
>=20
> jon
>=20
> --=20
> "More computing sins are committed in the name of efficiency
>  (without necessarily achieving it) than for any other single reason
>  - including blind stupidity."
> 	- W.A. Wulf
>=20
>=20
>
------------------------------------------------------------------------
------------------------
> This message is for the designated recipient only and may
> contain privileged, proprietary, or otherwise private information. =20
> If you have received it in error, please notify the sender
> immediately and delete the original.  Any unauthorized use of
> this email is prohibited.
>
------------------------------------------------------------------------
------------------------
> [mf2]

--=20
"Death to all fanatics!"
	- Mal2


---------------------------------------------------------------------------=
---------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information. =20
If you have received it in error, please notify the sender
immediately and delete the original.  Any unauthorized use of
this email is prohibited.
---------------------------------------------------------------------------=
---------------------
[mf2]

Re: [Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Jonathan W. <co...@co...>]

On Thu, Aug 05, 2004 at 11:21:58AM -0400, Liu, Yigong wrote:

> Also for some reasons I cannot start mysql daemon locally. So I tried to
> connect to a remote server with simple changes to simple1.cc.
> 
> I added con.set_Host, set_User, set_Passwd(). It still crashes. Any
> clue?

Hello again,

I'll take a look at your problems when I get home in a couple of hours.
Sorry for the delay,

jon

> 
> I tried mysql++, at least it allows me to connect to the remote server;
> although it has the same issue of exception handling.
> 
> Thanks
> 
> Yigong
> 
> 
> -----Original Message-----
> From: Liu, Yigong 
> Sent: Thursday, August 05, 2004 11:23 AM
> To: 'Jonathan Wakely'
> Cc: mys...@li...
> Subject: RE: [Mysqlcppapi-main] where to find libmysqlclient.so for
> Solaris 2.8 with gcc 3.3
> 
> Hi there,
> 
> Thanks for the reply.
> 
> Another question, I tried simple1 (the first example) and I have no
> database server running locally, so it fails. However, it will crash the
> whole program, not close down gracely. I check simple1.cc, although
> there are catch statement for exceptions and I also add catch(...) to
> catch all other exceptions, it still crashes. Does exception-handling
> work in mysqlcppapi?
> 
> Thanks a lot
> Yigong
> 
> 
> -----Original Message-----
> From: Jonathan Wakely [mailto:co...@co...] 
> Sent: Thursday, August 05, 2004 5:25 AM
> To: Liu, Yigong
> Cc: mys...@li...
> Subject: Re: [Mysqlcppapi-main] where to find libmysqlclient.so for
> Solaris 2.8 with gcc 3.3
> 
> On Wed, Aug 04, 2004 at 06:09:59PM -0400, Liu, Yigong wrote:
> 
> > Hi there, Murray and any other experts,
> 
> Hi,
> 
> > I am building mysqlcppapi1.9.3 on Solaris2.8 with gcc3.3.2. Everything
> > went good until I hit "ld : cannot find -lmysqlclient."
> 
> I assume this is when linking, not when running, the program?
> 
> > Could you please give me some hints about where I can find it?
> 
> On a number of systems mysql libs are installed in ${prefix}/lib/mysql/
> rather than ${prefix}/lib
> 
> So you might want to try -L/usr/local/mysql/lib/mysql or similar.
> 
> These pages might help too:
> http://dev.mysql.com/doc/mysql/en/Solaris.html
> http://dev.mysql.com/doc/mysql/en/Solaris_2.7.html
> http://dev.mysql.com/doc/mysql/en/Installation_layouts.html
> 
> Hope that helps,
> 
> jon
> 
> -- 
> "More computing sins are committed in the name of efficiency
>  (without necessarily achieving it) than for any other single reason
>  - including blind stupidity."
> 	- W.A. Wulf
> 
> 
> ------------------------------------------------------------------------------------------------
> This message is for the designated recipient only and may
> contain privileged, proprietary, or otherwise private information.  
> If you have received it in error, please notify the sender
> immediately and delete the original.  Any unauthorized use of
> this email is prohibited.
> ------------------------------------------------------------------------------------------------
> [mf2]

-- 
"Death to all fanatics!"
	- Mal2

RE: [Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Liu, Y. <Yig...@an...>]

Also for some reasons I cannot start mysql daemon locally. So I tried to
connect to a remote server with simple changes to simple1.cc.

I added con.set_Host, set_User, set_Passwd(). It still crashes. Any
clue?

I tried mysql++, at least it allows me to connect to the remote server;
although it has the same issue of exception handling.

Thanks

Yigong


-----Original Message-----
From: Liu, Yigong=20
Sent: Thursday, August 05, 2004 11:23 AM
To: 'Jonathan Wakely'
Cc: mys...@li...
Subject: RE: [Mysqlcppapi-main] where to find libmysqlclient.so for
Solaris 2.8 with gcc 3.3

Hi there,

Thanks for the reply.

Another question, I tried simple1 (the first example) and I have no
database server running locally, so it fails. However, it will crash the
whole program, not close down gracely. I check simple1.cc, although
there are catch statement for exceptions and I also add catch(...) to
catch all other exceptions, it still crashes. Does exception-handling
work in mysqlcppapi?

Thanks a lot
Yigong


-----Original Message-----
From: Jonathan Wakely [mailto:co...@co...]=20
Sent: Thursday, August 05, 2004 5:25 AM
To: Liu, Yigong
Cc: mys...@li...
Subject: Re: [Mysqlcppapi-main] where to find libmysqlclient.so for
Solaris 2.8 with gcc 3.3

On Wed, Aug 04, 2004 at 06:09:59PM -0400, Liu, Yigong wrote:

> Hi there, Murray and any other experts,

Hi,

> I am building mysqlcppapi1.9.3 on Solaris2.8 with gcc3.3.2. Everything
> went good until I hit "ld : cannot find -lmysqlclient."

I assume this is when linking, not when running, the program?

> Could you please give me some hints about where I can find it?

On a number of systems mysql libs are installed in ${prefix}/lib/mysql/
rather than ${prefix}/lib

So you might want to try -L/usr/local/mysql/lib/mysql or similar.

These pages might help too:
http://dev.mysql.com/doc/mysql/en/Solaris.html
http://dev.mysql.com/doc/mysql/en/Solaris_2.7.html
http://dev.mysql.com/doc/mysql/en/Installation_layouts.html

Hope that helps,

jon

--=20
"More computing sins are committed in the name of efficiency
 (without necessarily achieving it) than for any other single reason
 - including blind stupidity."
	- W.A. Wulf


---------------------------------------------------------------------------=
---------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information. =20
If you have received it in error, please notify the sender
immediately and delete the original.  Any unauthorized use of
this email is prohibited.
---------------------------------------------------------------------------=
---------------------
[mf2]

RE: [Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Liu, Y. <Yig...@an...>]

Hi there,

Thanks for the reply.

Another question, I tried simple1 (the first example) and I have no
database server running locally, so it fails. However, it will crash the
whole program, not close down gracely. I check simple1.cc, although
there are catch statement for exceptions and I also add catch(...) to
catch all other exceptions, it still crashes. Does exception-handling
work in mysqlcppapi?

Thanks a lot
Yigong


-----Original Message-----
From: Jonathan Wakely [mailto:co...@co...]=20
Sent: Thursday, August 05, 2004 5:25 AM
To: Liu, Yigong
Cc: mys...@li...
Subject: Re: [Mysqlcppapi-main] where to find libmysqlclient.so for
Solaris 2.8 with gcc 3.3

On Wed, Aug 04, 2004 at 06:09:59PM -0400, Liu, Yigong wrote:

> Hi there, Murray and any other experts,

Hi,

> I am building mysqlcppapi1.9.3 on Solaris2.8 with gcc3.3.2. Everything
> went good until I hit "ld : cannot find -lmysqlclient."

I assume this is when linking, not when running, the program?

> Could you please give me some hints about where I can find it?

On a number of systems mysql libs are installed in ${prefix}/lib/mysql/
rather than ${prefix}/lib

So you might want to try -L/usr/local/mysql/lib/mysql or similar.

These pages might help too:
http://dev.mysql.com/doc/mysql/en/Solaris.html
http://dev.mysql.com/doc/mysql/en/Solaris_2.7.html
http://dev.mysql.com/doc/mysql/en/Installation_layouts.html

Hope that helps,

jon

--=20
"More computing sins are committed in the name of efficiency
 (without necessarily achieving it) than for any other single reason
 - including blind stupidity."
	- W.A. Wulf


---------------------------------------------------------------------------=
---------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information. =20
If you have received it in error, please notify the sender
immediately and delete the original.  Any unauthorized use of
this email is prohibited.
---------------------------------------------------------------------------=
---------------------
[mf2]

Re: [Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Jonathan W. <co...@co...>]

On Wed, Aug 04, 2004 at 06:09:59PM -0400, Liu, Yigong wrote:

> Hi there, Murray and any other experts,

Hi,

> I am building mysqlcppapi1.9.3 on Solaris2.8 with gcc3.3.2. Everything
> went good until I hit "ld : cannot find -lmysqlclient."

I assume this is when linking, not when running, the program?

> Could you please give me some hints about where I can find it?

On a number of systems mysql libs are installed in ${prefix}/lib/mysql/
rather than ${prefix}/lib

So you might want to try -L/usr/local/mysql/lib/mysql or similar.

These pages might help too:
http://dev.mysql.com/doc/mysql/en/Solaris.html
http://dev.mysql.com/doc/mysql/en/Solaris_2.7.html
http://dev.mysql.com/doc/mysql/en/Installation_layouts.html

Hope that helps,

jon

-- 
"More computing sins are committed in the name of efficiency
 (without necessarily achieving it) than for any other single reason
 - including blind stupidity."
	- W.A. Wulf

[Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Liu, Y. <Yig...@an...>]

Hi there, Murray and any other experts,

=20

I am building mysqlcppapi1.9.3 on Solaris2.8 with gcc3.3.2. Everything
went good until I hit "ld : cannot find -lmysqlclient."

=20

Could you please give me some hints about where I can find it?

=20

Thanks

=20

yigong

[Mysqlcppapi-main] where to find libmysqlclient.so for Solaris 2.8 with gcc 3.3

[Liu, Y. <Yig...@an...>]

Hi there, Murray and any other experts,

=20

I am building mysqlcppapi1.9.3 on Solaris2.8 with gcc3.3.2. Everything
went good until I hit "ld : cannot find -lmysqlclient."

=20

Could you please give me some hints about where I can find it?

=20

Thanks

=20

yigong

[Mysqlcppapi-main] Re: mysqlcppapi: developer help offer

[<be...@sm...>]

On Friday 07 May 2004 13:23, Jonathan Wakely wrote:
> On Fri, May 07, 2004 at 12:25:36PM +0200, Philipp Berndt wrote:
> > FYI: I have submitted patches along with the bug reports already. I also
> > ported mysql++ 1.7.9 to gcc3.2 and supplied the patches and rpms on the
> > mysql++ site. But I've grown tired of submitting patches to unmaintained
> > code, that's why I asked for cvs access.
>
> The code isn't unmaintained, but I have been neglecting it recently due
> to other commitments. I will go over your patches tomorrow and apply them
> as appropriate.
>
> > I am really willing to help on stabilizing mysqlcppapi but please
> > understand that I don't have time to maintain my own version of
> > mysqlcppapi in my own cvs, create patches against your tree, keep track
> > of the different versions and submit a bug report for every bug I find
> > instead of just fixing it.
>
> I understand, but ask you to be patient for a little longer and I will
> be more responsive to any bugs/patches/suggestions you submit. It's
> obviously in everyone's interest to avoid another fork of the library,
> and I will consider granting CVS access after looking over the bugs and
> patches you've submitted, but I hope you will understand that I won't
> grant it simply because you ask for it.
>
> Thanks for your contributions, and I'm sorry you've had a bad first
> impression of me as maintainer of the project.
>
> jon

Thank you very much! Please excuse my former frustration, certainly no 
offense intended!

Kind regards,
Philipp