bug in Connector/J 3.0.6

------=_NextPart_000_0027_01C2F8FA.11833880
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hallo,

with Connector/J 3.0.6 try this statements:

stmt.executeUpdate("select * into outfile "filename" from "tablename");
stmt.executeQuery("select * into outfile "filename" from "tablename");

both commands raise error


Adrian

------=_NextPart_000_0027_01C2F8FA.11833880--

Re: bug in Connector/J 3.0.6

with Connector/J 3.0.6 try this statements:

stmt.executeUpdate("select * into outfile "filename" from "tablename");
stmt.executeQuery("select * into outfile "filename" from "tablename");

both commands raise error


Adrian


Hi!

Quotes should be used for the filename, but not for the tablename.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: bug in Connector/J 3.0.6

Regarding your problem in executing the following statements:

with Connector/J 3.0.6 try this statements:

stmt.executeUpdate("select * into outfile "filename" from "tablename");
stmt.executeQuery("select * into outfile "filename" from "tablename");


Please do note that currently Connector/J is not capable of using
either of the above methods in executing a SELECT query that does not
return a result set.


There is a workaround, you can just do Statement.execute().


--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org