List:MySQL++« Previous MessageNext Message »
From:gary clark Date:February 23 2007 8:51pm
Subject:Re: UPDATE routine giving exception
View as plain text  
Hello,

Other than James and myself has anyone else had
problems with the 2.2.0 and it query UPDATE routine on
Windows.

I would really appreciate if somebody else has seen
this problem prior to myself diving into this code.

Much appreciated,
Garyc

--- gary clark <burslem2001@stripped> wrote:

> I havent tried multiples yet. James there are
> several
> problems with 2.1.1 some of which I didnt identify I
> hope you have all the patches. A major one I hit was
> the memory leak a real charmer. 
> 
> Cheers,
> Garyc
> --- James Vanns <james.vanns@stripped>
> wrote:
> 
> > To be honest I rolled back to 2.1.1 almost as soon
> > as I upgraded 2.2.0 due a change not apparent in
> the
> > Changelog. I saw such a catastrophic (damn near
> > every statement - thats ~1000/s) no. of failures
> to
> > execute blah blah (majority are UPDATEs) I had to
> > reinstall the old .so. Never had any problems with
> > that one. However, it could well be because all
> > statements executed on the server with MySQL++ end
> > in a semicolon (';'). This had never been a
> problem
> > before. I have not yet found time to test another
> > installation with this modification (removing the
> > ';'). How are multi-queries handled now if a
> > semicolon is deemed erroneous?
> > 
> > Just my tuppence.
> > 
> > Jim
> > 
> > ----- Original Message -----
> > From: "gary clark" <burslem2001@stripped>
> > To: plusplus@stripped
> > Sent: 18 February 2007 01:59:58 o'clock (GMT)
> > Europe/London
> > Subject: Re: UPDATE routine giving exception
> > 
> > Thanks for the response.
> > 
> > With the 2.2.0 mysql++ build in Windows I see a
> > failure.
> > 
> > query << "UPDATE clienttransfer SET seq=1";
> > 
> > I still see a failure to perform an update, is
> > anybody
> > else seeing this problem?
> > 
> > Much appreciated,
> > Garyc
> > 
> > 
> > --- Jonathan Wakely <mysql@stripped> wrote:
> > 
> > >
> >
>
http://dev.mysql.com/doc/refman/5.0/en/mysql-real-query.html
> > > 
> > > "Normally, the string must consist of a single
> SQL
> > > statement and you
> > > should not add a terminating semicolon (';') or
> \g
> > > to the statement."
> > > 
> > > remove the semi-colon at the end of your query
> > > 
> > > jon
> > > 
> > > 
> > > On 16/02/07, gary clark <burslem2001@stripped>
> > > wrote:
> > > > Hi,
> > > >
> > > > I use to have in 2.1.1 the following
> statement:
> > > >
> > > > try
> > > > {
> > > >    mysqlpp::Query query = _con.query();
> > > >
> > > >    query << "UPDATE clienttransfer SET seq=1;"
> > > <<endl;
> > > >     cout << query.preview() << endl;
> > > >     query.execute();
> > > > }
> > > > catch{
> > > >    cerr << "Error setCompletedEntries:" <<
> > > er.what()
> > > > << endl;
> > > > }
> > > > return SUCCESS;
> > > > }
> > > >
> > > > I now get with 2.2.0 version an error:
> > > >
> > > > Error setCompletedEntries: You have an error
> in
> > > your
> > > > SQL syntax that corresponds to your MYSQL
> server
> > > > version for the right syntax to use near '; '
> at
> > > line
> > > > 1
> > > >
> > > > Huh? If somebody would be so kind to point to
> me
> > > the
> > > > correct syntax, that would be great. I've been
> > > using
> > > > MYSQL Server version 5.0.27.
> > > >
> > > > Much appreciated,
> > > > Garyc
> > > >
> > > >
> > > > --
> > > > MySQL++ Mailing List
> > > > For list archives:
> > http://lists.mysql.com/plusplus
> > > > To unsubscribe:   
> > >
> >
>
http://lists.mysql.com/plusplus?unsub=1
> > > >
> > > >
> > > 
> > > -- 
> > > MySQL++ Mailing List
> > > For list archives:
> http://lists.mysql.com/plusplus
> > > To unsubscribe:   
> > >
> >
>
http://lists.mysql.com/plusplus?unsub=1
> > > 
> > > 
> > 
> > 
> > -- 
> > MySQL++ Mailing List
> > For list archives: http://lists.mysql.com/plusplus
> > To unsubscribe:   
> >
>
http://lists.mysql.com/plusplus?unsub=1
> > 
> > 
> > 
> > -- 
> > James Vanns
> > Systems Programmer
> > Framestore CFC Ltd.
> > 
> > 
> > -- 
> > MySQL++ Mailing List
> > For list archives: http://lists.mysql.com/plusplus
> > To unsubscribe:   
> >
>
http://lists.mysql.com/plusplus?unsub=1
> > 
> > 
> 
> 
> -- 
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:   
>
http://lists.mysql.com/plusplus?unsub=1
> 
> 

Thread
Two bugs in 2.2.0Joseph Artsimovich12 Feb
  • Column sizesgary clark12 Feb
    • Re: Column sizesWarren Young13 Feb
      • Re: Column sizesgary clark16 Feb
        • Re: Column sizesWarren Young16 Feb
          • Re: Column sizesgary clark16 Feb
            • UPDATE routine giving exceptiongary clark16 Feb
              • Re: UPDATE routine giving exceptionJonathan Wakely17 Feb
                • Re: UPDATE routine giving exceptiongary clark18 Feb
                  • Re: UPDATE routine giving exceptionJames Vanns19 Feb
                    • Re: UPDATE routine giving exceptiongary clark19 Feb
                      • Re: UPDATE routine giving exceptiongary clark23 Feb
                        • Re: UPDATE routine giving exceptionWarren Young23 Feb
                          • Re: UPDATE routine giving exceptiongary clark23 Feb
                            • Re: UPDATE routine giving exceptionWarren Young24 Feb
                              • Re: UPDATE routine giving exceptionIan Miller24 Feb
                              • Re: UPDATE routine giving exceptiongary clark24 Feb
                                • Re: UPDATE routine giving exceptiongary clark28 Feb
                                  • Re: UPDATE routine giving exceptionWarren Young1 Mar
                                    • Re: UPDATE routine giving exceptiongary clark1 Mar
                                    • Re: UPDATE routine giving exceptiongary clark19 Mar
                                      • Re: UPDATE routine giving exceptionWarren Young19 Mar
                                        • Re: UPDATE routine giving exceptiongary clark19 Mar
                                          • Re: UPDATE routine giving exceptionWarren Young19 Mar
                                            • Re: UPDATE routine giving exceptiongary clark20 Mar
  • Re: Two bugs in 2.2.0Warren Young20 Feb
    • Re: Two bugs in 2.2.0Joseph Artsimovich20 Feb
      • Re: Two bugs in 2.2.0Jonathan Wakely20 Feb
        • Re: Two bugs in 2.2.0Joseph Artsimovich20 Feb
          • Re: Two bugs in 2.2.0Jonathan Wakely20 Feb
            • Re: Two bugs in 2.2.0Joseph Artsimovich20 Feb
              • Re: Two bugs in 2.2.0Jonathan Wakely20 Feb
        • Re: Two bugs in 2.2.0Warren Young20 Feb