List:MySQL++« Previous MessageNext Message »
From:gary clark Date:February 19 2007 2:18pm
Subject:Re: UPDATE routine giving exception
View as plain text  
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
> 
> 

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