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
