mysqlcppapi-main

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

[Jonathan W. <re...@ka...>]

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

Re: [Mysqlcppapi-main] my_global.h

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

On Tue, Mar 30, 2004 at 06:11:49PM +0400, Dmitry Konnov wrote:

> Hi to everybody,
> 
> I trying to compile MysqlCC project 0.9.4 under MSVS and Qt.

Hi, Dmitry

MySQLCC and mysql++ are developed by MySQL AB, and are supported by
the mailing lists at http://lists.mysql.com/

This mailing list is for the development of mysqlcppapi, a fork
of mysql++ that is developed independently and is significantly
different.

> MysqlCC uses MySQL++ library.I found in documentation
> to MysqlCC nothing about MySQL++. But after i installed MySQL++
> the MysqlCC almost compiled. But i still have problem not having
> my_global.h.

If you're unable to compile it why don't you try an official binary
version of MySQLCC from
http://www.mysql.com/products/mysqlcc/install.html#binarywin


> Probably i use old version MySQL++ - 1.7.1.-1-win32-vc
> But i can not download newer version of MySQL++.
> 
> Please help.

I recommend you try one of the lists here: http://lists.mysql.com/

Good luck,

jon


-- 
"When a true genius appears in the world you may know him by this sign: 
 that all the dunces are in confederacy against him."
	- Jonathan Swift

[Mysqlcppapi-main] my_global.h

[Dmitry K. <ko...@le...>]

Hi to everybody,

I trying to compile MysqlCC project 0.9.4 under MSVS and Qt.

MysqlCC uses MySQL++ library.I found in documentation
to MysqlCC nothing about MySQL++. But after i installed MySQL++
the MysqlCC almost compiled. But i still have problem not having
my_global.h.

Probably i use old version MySQL++ - 1.7.1.-1-win32-vc
But i can not download newer version of MySQL++.

Please help.

  

-- 
Best regards,
 Dmitry                          mailto:kon...@ma...

[Mysqlcppapi-main] Is mysqlcppapi reentrant

[Rajesh R. <raj...@ya...>]

Hi,

I wanted to know whether the mysqlcppapi is reentrant
or not.

Thanks,
Rajesh.

__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster
http://search.yahoo.com

Re: [Mysqlcppapi-main] Re: mysqlcppapi needs a new maintainer

[Howard C. <how...@se...>]

As Jonathan Wakely and Sinisa Milivojevic point out, the license for
mysqlcppapi is irrelevant when the underlying library has changed from LGPL
tp GPL.

I know that employees of MySQL AB contribute to this mailing list. Can any
of them get a company viewpoint on the development of a LGPL version of the
API to further the development of mysqlcppapi as a LGPL only project.

I assume the reasoning behind the change from LGPL to GPL is commercial, and
it was not just a typo! It is great to have MySQL as an open-source project,
but I do feel that changing the licence is perhaps taking advantage of the
goodwill of all the software community. Sort of doing a SCO on the SQL world
by putting doubt on the commercial use of the library!

Please, to make life easier, just make the MySql libraries LGPL again!

Howard Cole

P.S.  My congratulations go out to the people in charge of the licensing of
MySQL clients for generating the most confusing licensing guidelines in the
world! I am under the impression that the guidelines are there to make
people think that they always need a commercial licence "when in doubt".
Just to add to the confusion, finding a price for client licenses on the
website is impossible!

Re: [Mysqlcppapi-main] Re: mysqlcppapi needs a new maintainer

[Sinisa M. <si...@be...>]

On Sat, 13 Dec 2003 11:01:22 -0600
"Bryan W. Headley" <bwh...@ea...> wrote:

> 
> No, one library having a dependency on another does not make it a 
> derivative library. What would make it a 'derivative' is, if library A 
> is based off of a branch of the source code to library B...
> 
> -- 
> ____               .:.                 ____
> Bryan W. Headley - bwh...@ea...
> 
> 


No, it is not derivative of our C API, but that is not relevant.

What is relevant here is licensing.

As mysqlcppapi (just as MySQL++) use our C API, which is GPL, then it's
LGPL license is irrelevant.

--

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <si...@my...>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus

Re: [Mysqlcppapi-main] Re: mysqlcppapi needs a new maintainer

[Bryan W. H. <bwh...@ea...>]

Jonathan Wakely wrote:
> On Fri, Dec 12, 2003 at 02:51:45PM +0200, Sinisa Milivojevic wrote:
>>
>>As our C API is GPL, you can label MySQL++ (or mysqlcppapi) license LGPL 
>>(or put as many L as you like), still program requires our C API.
> 
> 
> But isn't mysqlcppapi a derivative work, since it makes use of the C
> API and builds another library on top of it?

No, one library having a dependency on another does not make it a 
derivative library. What would make it a 'derivative' is, if library A 
is based off of a branch of the source code to library B...

-- 
____               .:.                 ____
Bryan W. Headley - bwh...@ea...

Re: [Mysqlcppapi-main] Re: mysqlcppapi needs a new maintainer

[Sinisa M. <si...@be...>]

On Fri, 12 Dec 2003 14:39:00 +0000
Jonathan Wakely <co...@co...> wrote:

> On Fri, Dec 12, 2003 at 02:51:45PM +0200, Sinisa Milivojevic wrote:
> 
> > On the other hand, this is truly irrelevant.
> > 
> > As our C API is GPL, you can label MySQL++ (or mysqlcppapi) license
> > LGPL (or put as many L as you like), still program requires our C API.
> 
> But isn't mysqlcppapi a derivative work, since it makes use of the C
> API and builds another library on top of it?
> 
> jon
> 
> --
> "Immorality: the morality of those who are having a better time."
> 	- H.L. Mencken


Yes it is.

--

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <si...@my...>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus

[Mysqlcppapi-main] Re: mysqlcppapi needs a new maintainer

[Benjamin P. <ben...@pf...>]

Hello.

On Fri 2003-12-12 at 13:10:04 +0100, you wrote
[...]
> I do not give any other project permission to relicense the
> mysqlcppapi LGPL code as GPL. I am not a lawyer, but I thinking that
> permission is necessary.

IANAL, neither. Just to prevent other readers from a possible
misunderstanding: IMHO, you already gave that permission implicitly by
chosing the LGPL as license. From the LGPL-2.1 (the LGPL-2 contains
the same wording):

----------------------------------------------------------------------
  3. You may opt to apply the terms of the ordinary GNU General Public
License instead of this License to a given copy of the Library.  To do
this, you must alter all the notices that refer to this License, so
that they refer to the ordinary GNU General Public License, version 2,
instead of to this License.  (If a newer version than version 2 of the
ordinary GNU General Public License has appeared, then you can specify
that version instead if you wish.)  Do not make any other change in
these notices.

  Once this change is made in a given copy, it is irreversible for
that copy, so the ordinary GNU General Public License applies to all
subsequent copies and derivative works made from that copy.
----------------------------------------------------------------------

So, the LGPL explicitly allows other to relicense the work as GPL.

Regards,

	Benjamin.

Re: [Mysqlcppapi-main] Re: mysqlcppapi needs a new maintainer

[Howard C. <how...@se...>]

Regarding the licence change...

Would a simpler solution be to integrate the LGPL version of the C API into
mysql++ , or build a branch of libmysql from the LGPL version? Looking at
the code, there is not much too it. Emulating the later mysql developments
would be easy since we can see exactly what changes have been made!

We can all then use the library freely and not have to worry about MySQL AB
playing around with the licence. A sort of WINE equivalent for the MySQL
API.

Sorry to offend any GPL purists, but seemingly inoccuous changes to
licencing have a big financial knock on effect to many of us developers.

Howard Cole
www.selestial.com

Re: [Mysqlcppapi-main] Re: mysqlcppapi needs a new maintainer

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

On Fri, Dec 12, 2003 at 02:51:45PM +0200, Sinisa Milivojevic wrote:

> On the other hand, this is truly irrelevant.
> 
> As our C API is GPL, you can label MySQL++ (or mysqlcppapi) license LGPL 
> (or put as many L as you like), still program requires our C API.

But isn't mysqlcppapi a derivative work, since it makes use of the C
API and builds another library on top of it?

jon

--
"Immorality: the morality of those who are having a better time."
	- H.L. Mencken

Re: [Mysqlcppapi-main] How can I get the MYSQL pointer?

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

On Thu, Nov 06, 2003 at 01:53:03PM +0100, Wolfgang Gutjahr wrote:

> in order to be able to use the mysql_real_escape_string() function, I 
> need the MYSQL pointer of the connection, but it is private in the 
> Connection class and the obj() function to get it is outcommented.

Yes.

> Is there a possibility to get the pointer or another way to call 
> mysql_real_escape_string() (without opening another connection)?

Good question! :-)
I might be missing something (i'm still new to the source myself) but
there should probably be a Connection::escape_string() function that
uses the Connection's MYSQL*.

The only place in mysqlcppapi that escapes a string uses
mysql_escape_string() so doesn't need the MYSQL* (and doesn't respect
the current character set)

Murray, I'll prepare a patch that adds an escape_string() or escape()
function (any preference of name?) as I already have something similar
in my mysql wrapper. Some other DB API wrappers I've seen provide an
escape_string_literal() function that escapes a string and encloses it
in quotes, but I think this is redundant - how hard is it to add quotes
manually?

jon

-- 
"MTV Awards - a bunch of rich people showing off and getting
 patted on the back for stuff that they should be doing anyway."
	- Method Man 

[Mysqlcppapi-main] How can I get the MYSQL pointer?

[Wolfgang G. <gu...@kn...>]

Hi,

in order to be able to use the mysql_real_escape_string() function, I 
need the MYSQL pointer of the connection, but it is private in the 
Connection class and the obj() function to get it is outcommented.

Is there a possibility to get the pointer or another way to call 
mysql_real_escape_string() (without opening another connection)?

Any help appreciated,
best regards,

Wolfgang

Re: [Mysqlcppapi-main] mysqlcppapi link error

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

On Sat, Nov 01, 2003 at 04:30:30AM +0200, Dmitry Katemirov wrote:

> Hello team, could you advise?
> 
> I'm compiling the library on SPARC Solaris 8 with gcc 3.3 and mysql 4.0.15
> (64-bit build). These are my configuration options:
> 
> ./configure CFLAGS=-m64 CXXFLAGS=-m64 --with-mysql='/usr/local'
> 
> Compilation fails with the following error:
> 
> ../../libtool: .:
> /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3/../../../sparcv9/libstdc++.l
> a: cannot execute binary file
> libtool: link: cannot find name of link library for
> `/usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3/../../../sparcv9/libstdc++.
> la'
> make: *** [libdatetime.la] Error 1

I'm guessing as to the problem here, but it looks like a
cross-compilation error. Is libstdc++ compiled 64bit?
Does it need to be to link to 64bit mysql libraries?

> Could you tell what's wrong? libstdc++.la exists at specified location.
> 
> BTW note that I had to fix mysqlcppapi_internal.h by removing mysql/ prefix
> from #include <mysql/mysql.h>

Ah, this bit I can help with :-)

This depends on how MySQL was installed. Most installation layouts put
the mysql headers in ${prefix}/include/mysql/ so if ${prefix}/include is
in your include path then <mysql/mysql.h> will find the header.

Hope that helps,

jon

-- 
"It is absurd to divide people into good and bad.  People are either 
 charming or tedious."
	- Oscar Wilde

[Mysqlcppapi-main] mysqlcppapi link error

[Dmitry K. <dm...@ka...>]

Hello team, could you advise?

I'm compiling the library on SPARC Solaris 8 with gcc 3.3 and mysql 4.0.15
(64-bit build). These are my configuration options:

./configure CFLAGS=-m64 CXXFLAGS=-m64 --with-mysql='/usr/local'

Compilation fails with the following error:

../../libtool: .:
/usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3/../../../sparcv9/libstdc++.l
a: cannot execute binary file
libtool: link: cannot find name of link library for
`/usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3/../../../sparcv9/libstdc++.
la'
make: *** [libdatetime.la] Error 1

Could you tell what's wrong? libstdc++.la exists at specified location.

BTW note that I had to fix mysqlcppapi_internal.h by removing mysql/ prefix
from #include <mysql/mysql.h>

TIA,
Dmitry

[Mysqlcppapi-main] Missing WIN32 files

[Howard C. <how...@se...>]

Hi,

I am attempting to build mysqlcppapi using Visual C++ 7.0 but there appear
to be some files missing from the 1.9.3 zip. The files are referenced in
"windows_includes.h" are:
    #include <Windows32/Base.h>
    #include <Windows32/Defines.h>
    #include <Windows32/Structures.h>

Does anybody know what these files are and where they are?

Thanks in advance,

Howard.

RE: [Mysqlcppapi-main] Docs

[<Mur...@Co...>]

From: Jonathan Traxler [mailto:jo...@tr...] 
> Thanks for the tip.  I did just that and got a fairly clean set of HTML
files.  
> I need to tweak the ini a little more to reflect version etc...

If you do it like libxml++ (or gtkmm, or libsigc++, etc), using a
doxyfile.in and the build file changes, that will happen automatically. They
also show how to make the HTML prettier with headers and footers. They also
hide private API, and use the standard JavaDoc commenting format.

> But on a whole it helped greatly!
> I am more than happy to submit the html files to the project or at least
post them for review.
>
>
> Again thanks for help and let me know how I can contribute ;)

Please do look at something like libxml++ and submit a patch. That way the
html will be always up-to-date.

Here is some help on creating patches:
http://www.gtkmm.org/bugs.shtml

Murray Cumming
www.murrayc.com
mu...@us...

[Mysqlcppapi-main] Docs

[Jonathan T. <jo...@tr...>]

Murray-

Thanks for the tip.  I did just that and got a fairly clean set of HTML =
files. =20

I need to tweak the ini a little more to reflect version etc... But on a =
whole it helped greatly!

I am more than happy to submit the html files to the project or at least =
post them for review.

Again thanks for help and let me know how I can contribute ;)

-Jon

[Mysqlcppapi-main] Docs/Manual? Function List

[Jonathan T. <jo...@tr...>]

I'm working with a class that is learning C++ and MySQL.  We want to use =
these libraries to help them.

Is there docs that list all the functions or some type of=20
synopsis?   I compiled the examples and looked at them but=20
am still trying to find all the function calls available in this=20
library.  I did not see a docs dir or manual dir.  Can someone point me =
in the right direction.

Thanks in advance

Jon

Re: [Mysqlcppapi-main] con.Create_Query() does not reset query object

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

On Tue, Sep 09, 2003 at 03:53:02PM +0100, Brian Butcher wrote:

> The following code appends the two queries rather than creates two distinct 
> queries.
> 
>     mysqlcppapi::Query query = con.create_Query();
>     query << "UPDATE W32 SET who=who2";
>     con.create_Query();
>     query << "UPDATE B32 SET who=who2";
>     cout << "Query: " << query.preview() << endl;
> 
> ie it generates:
> Query: UPDATE W32 SET who=who2UPDATE B32 SET who=who2

I've submitted a patch for this first problem to the SF patch manager:

https://sf.net/tracker/index.php?func=detail&aid=804260&group_id=7869&atid=307869

Tested by modifying the reference_counting.cc file to be similar to the
example code above. With this patch the queries were not run together.

jon

-- 
"They that can give up essential liberty to obtain a little temporary safety
 deserve neither liberty nor safety"
	- Benjamin Franklin

Re: [Mysqlcppapi-main] con.Create_Query() does not reset query object

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

On Tue, Sep 09, 2003 at 03:53:02PM +0100, Brian Butcher wrote:

> I have been using mysqlcppapi for the last two or three weeks and in general I 
> find it much cleaner than mysqlc++. Thanks to the developers.
> 
> Two bugs or features though:
> The following code appends the two queries rather than creates two distinct 
> queries.
> 
>     mysqlcppapi::Query query = con.create_Query();
>     query << "UPDATE W32 SET who=who2";
>     con.create_Query();
     ^^^^

Is this what you meant?
This will simply discard the return value of con_Query() and therefore
the << operation writes to the same Query object and the text is
appended.

If the line was supposed to be

     query = con.create_Query();

then yes, the stream contents are not changed by Query::operator=.

I have a patch to copy the stream contents, but can't get a diff because
the sourceforge CVS server is being annoying.
The patch involves calling this->str(src.str()) in SQLQuery::operator=
and initialising the stringstream member in the SQLQuery copy ctor with
std::stringstream(src.str()).

I've been planning to submit this patch for a while. Murray, shall I put
it in the patch mgr as soon as I can get a diff from CVS?

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] con.Create_Query() does not reset query object

[Brian B. <bri...@fa...>]

I have been using mysqlcppapi for the last two or three weeks and in general I 
find it much cleaner than mysqlc++. Thanks to the developers.

Two bugs or features though:
The following code appends the two queries rather than creates two distinct 
queries.

    mysqlcppapi::Query query = con.create_Query();
    query << "UPDATE W32 SET who=who2";
    con.create_Query();
    query << "UPDATE B32 SET who=who2";
    cout << "Query: " << query.preview() << endl;

ie it generates:
Query: UPDATE W32 SET who=who2UPDATE B32 SET who=who2

The second problem is that I have not been able to get the  con.set_Timeout() 
to actually alter the timeout for connection. This is a difficult one to test.

	Brian Butcher

[Mysqlcppapi-main] Patches for mysqlcppapi 1.9.2 with GCC 3.3.1

[Pat D. <p.d...@ps...>]

Greetings mysqlcppapi list.

I've been using and enjoying the lib for about two months now - good
stuff :)

I installed GCC 3.3.1 on an i686 linux box today (upgrading from
3.2.something). On top of some minor problems with constness I had
gotten before (in Connection.cc), I experience some errors with the
Row::size() method while compiling or linking (can't quite recall which
as I was in the throes of a battle with mysterious intermitent errors
that turned out to be faulty RAM).  


I fixed the const troubles and, althought it probably isn't the most
efficient solution, I just got rid of the 'inline' for size() to solve
my compilation troubles.  I am including the diff file for interested
parties.


Regards,
-- 
Pat Deegan
http://www.psychogenic.com/
PGP Key: http://www.keyserver.net 0x03F86A50

[Mysqlcppapi-main] Patches for mysqlcppapi 1.9.2 with GCC 3.3.1

[Pat D. <cod...@ps...>]

Greetings mysqlcppapi list.

I've been using and enjoying the lib for about two months now - good
stuff :)

I installed GCC 3.3.1 on an i686 linux box today (upgrading from
3.2.something). On top of some minor problems with constness I had
gotten before (in Connection.cc), I experience some errors with the
Row::size() method while compiling or linking (can't quite recall which
as I was in the throes of a battle with mysterious intermitent errors
that turned out to be faulty RAM).  


I fixed the const troubles and, althought it probably isn't the most
efficient solution, I just got rid of the 'inline' for size() to solve
my compilation troubles.  I am including the diff file for interested
parties.


Regards,
-- 
Pat Deegan
http://www.psychogenic.com/
PGP Key: http://www.keyserver.net 0x03F86A50

[Mysqlcppapi-main] Password et al during connect

[Steffen N. <sne...@Te...>]

Hi,

We have been using the mysql++ so far,
but I agree that a cleaner Interface is
something to be cared for before theoptimisation.

Before we migrate, I have a question about t
he philosophy of authentication.

AFAICS I have to hard code the password in my applictaion
or provide means to read it interactively. Is that correct ?

I have a patch for mysql++ that reads the ~/.my.cnf 
and uses defaults from there unless specified otherwise.

Is this something one could introduce into mysqlcppapi as well,
or what other method is planned ?

Yours,
Steffen