Re: JDBC and LOAD DATA LOCAL INFILE :

Ahmed S K Anis Wed, 12 Feb 2003 06:14:59 -0800

Thanks Mark,

I tried to work with the latest driver. 3.0.4
Now it gave error shown below .   Also see code snippet below at the
end


Error code is0
estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying
IOExcepti
on:

** BEGIN NESTED EXCEPTION **

java.io.FileNotFoundException
estoredata1.txt (The system cannot find the file specified)

STACKTRACE:

estoredata1.txt (The system cannot find the file specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:59)
        at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:1505)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:964)
        at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:911)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:1777)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:1711)
        at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1293)
        at Sanity.Restore(Sanity.java:138)
        at Sanity.main(Sanity.java:70)


CODE SNIPPET

String  filepath = "sys:\\restore\\data1.txt";
String query = "load data local infile  \'" + filepath + "\' into table
trail";

stmt.executeUpdate(query);

what could be wrong here ?

Anis


---------------------------------------------------------------------
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

Re: JDBC and LOAD DATA LOCAL INFILE :

Reply via email to