Hello,

        I'm using this command into a Java servlet 

LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INTO TABLE news";

        It runs well with mysql-3.23.45 but not with  mysql-3.23.55

The error message is :

java.sql.SQLException: General error: The used command is not allowed with this MySQL 
version
        at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
        at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
        at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
        at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
        at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
        at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
        at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
...

        I compiled  mysql-3.23.55 with the option --enable-local-infile
        and runs it with the argument!
 --local-i
nfile=1.

If I use the mysql client, it runs but not inside my Java servlet.

        Could you help me to find a solution ?

                                Thank you
                                Cédric.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to