[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    Re: problems with mm.mysql
From:       "Mark Matthews" <mmatthew () thematthews ! org>
Date:       2002-04-19 18:40:20
[Download RAW message or body]

Ahh, it appears he's using a relatively old version of MySQL server that
doesn't support quoted identifiers. I'll put a check for that in 2.0.13.
OTOH, jwl really should upgrade his server :)

    -Mark
----- Original Message -----
From: "Tim Endres" <time@trustice.com>
To: <jwl@sgi.com>; <java@lists.mysql.com>
Sent: Friday, April 19, 2002 12:07 PM
Subject: Re: problems with mm.mysql


> Looks to me like the driver is quoting table and column names, along with
> quoting the values to be assigned or compared. Should be easy enough to
> find in PreparedStatement.
>
> tim.
>
> > Hi, I've installed version 12 of mm.mysql and have been getting random
> > errors from the test suite.  Here is one of them.  Some of the tests
> > work, some don't  and some partially work.  I think I understand what
> > this one is trying to do and I seem to be able to duplicate it in sql,
> > but I'm in the dark here.  Any suggestions?  I couldn't find the
> > archives for this list and my goggle search didn't turn anything up.
> >
> > Thanks,
> > Jim.
> >
> > java -classpath mm.mysql-2.0.12-bin.jar testsuite/Updatability
> > Create test data: passed
> > Selecting result set
> > Modifying result set in-place
> > Before modification: 0,0,StringData0,
> > Exception in thread "main" java.sql.SQLException: Syntax error or access
> > violation: You have an error in your SQL syntax near '`UPDATABLE` SET
> > `pos1`='0',`pos2`='0',`char_field`='New Data100' WHERE `pos1`='0' at
> > line 1
> >         at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
> >         at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
> >         at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
> >         at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown
> > Source)
> >         at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown
> > Source)
> >         at org.gjt.mm.mysql.jdbc2.ResultSet.updateRow(Unknown Source)
> >         at testsuite.Updatability.main(Unknown Source)
> >
> > mysql -u jwl
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 22 to server version: 3.22.32-log
> >
> > Type 'help' for help.
> >
> > mysql> use test
> > Database changed
> > mysql> select * from UPDATABLE where pos1=0;
> > +------+------+-------------+
> > | pos1 | pos2 | char_field  |
> > +------+------+-------------+
> > |    0 |    0 | StringData0 |
> > +------+------+-------------+
> > 1 row in set (0.00 sec)
> >
> > mysql> update UPDATABLE set char_field='New Data100', pos1=0 where
> > pos1=0
> >     -> ;
> > Query OK, 1 row affected (0.00 sec)
> > Rows matched: 1  Changed: 1  Warnings: 0
> > mysql> select * from UPDATABLE where pos1=0;
> > +------+------+-------------+
> > | pos1 | pos2 | char_field  |
> > +------+------+-------------+
> > |    0 |    0 | New Data100 |
> > +------+------+-------------+
> > 1 row in set (0.00 sec)
> >
> > mysql>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail java-thread3628@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail java-unsubscribe@lists.mysql.com instead.
>
>


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail java-thread3629@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail java-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]