using LOAD DATA LOCAL INFILE with java.sql

[mho salim]

I am trying to load a file onto a table in a remote database that is running MySQL version 4.04 .
Using the query String
-- LOAD DATA LOCAL INFILE 'myfile.ext' IGNORE INTO TABLE `mytable` -- through java.sql.Statement.execute() method from inside my Java program I get the error message
-- java.sql.SQLException: General error: The used command is not allowed with this MySQL version --

This same query String works fine from a Commercial SQL client on the same machine with the same database (I am using EMS MySQL Manager 3.1.01)

The Java connection is made with
-- Class.forName("org.gjt.mm.mysql.Driver");
-- Connection con = DriverManager.getConnection(db, user, password) --
where -- db="jdbc:mysql://mydatabase:3306/dbname?MYSQL_OPT_LOCAL_INFILE=1&allowUrlInLocalInfile=true" --

has anyone else seen this problem? Is there a trick to this?