Re: select into outfile via mysql-connector-3.0.10 throws Exception

[Mark Matthews]

tkettenb wrote:
> While doing a "SELECT * FROM TABLE INTO OUTFILE
> '/tmp/file' " the mysql JDBC connector throws an
> Exception with ErrorCode = 0 and Message="Can not
> issue INSERT/UPDATE/DELETE with executeQuery()"
>
> I am going to ignore this exception, since the
> statement gets executed and the data is available
> in the given file. But this can't be the proper
> way to handle this.
>
> Any ideas?

Tkettenb,

The server is returning metadata that makes the driver think you've executed a DDL statement (even though it uses 'SELECT' in the query). The JDBC spec requires that an exception is thrown in this case.

The correct way to execute DDL statements is to use either executeUpdate() or execute().

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html