Exception: Can not issue SELECT via executeUpdate!

[asenthil]

Hai to all,

Now i'm trying to export Mysql table to a file By using the

following program...

itz sucessfully compiled... but it throws the above Exception..

[CODE]import java.io.*;
import java.sql.*;
public class ExportData {
public static void main(String args[]) {
        String Driver;
        Statement stmt; 
         ResultSet rs; 
 
         Driver = "com.mysql.jdbc.Driver";
         Connection con = null;
 
try {
Class.forName(Driver);
con = DriverManager.getConnection("jdbc:mysql://192.168.0.01/senthil","root","");
 if(!con.isClosed()){
System.out.println("Successfully connected to MySQL DataBase \n");
      stmt = con.createStatement(); 
      String filename = "C:/2.txt";
      String tablename = "employees";
      String sql;
stmt.executeUpdate("SELECT * INTO OUTFILE \"" + filename + "\" FROM " + tablename);
  }
} catch(Exception e) {
 System.err.println("Exception: " + e.getMessage());
    } 
finally {
      try {
        if(con != null)
          con.close();
      } catch(SQLException e) {}
 }
}
}[/CODE]

Can anyone plzz help me....

thanks and regards..
senthil

[CornedBee]

The exception says it all. You cannot issue SELECT statements with executeUpdate(). Use executeQuery() instead.