Hi guys,
I have got a question regarding LOAD DATA INFILE. Can some one save my day.
1. I want to import a txt file into mysql database.
when I use the following query in the mysql> prompt its fine.
which is
query
---------
LOAD DATA INFILE 'C:\\spares_import.txt'
INTO TABLE
fujitsu_spare_import (date_temp,time,scan_type,fujitsu_order_number,tec hnician_or_shippiment)
But when I do it
java I am getting error
Error
-----------
java.sql.sqlException: General error message from server: "File 'C:spares_import.txt' not found <ErrCode: 2>"
1. The file and table exists
2. When I use Load query, its working fine
I dont know why its say like that and another thing,
why does it say C:spares_import.txt, instead of C:\spares_import.txt ?
Can anyone help me out in this
Thanks,
Anand
Code
----------
public Vector updateImportSparePartsBean()
throws ComponentFailureException, IllegalSupplyChainPCIStateException
{
Connection conn = null;
Statement st;
PreparedStatement stmt;
ResultSet rs;
Vector return_vec = new Vector();
FujitsuSparePartsBean fujitsuSparePartsBean = null;
int result = 0;
try{
conn = getConnection();
}
catch (Exception e){
}
String filename = "C:\\spares_import.txt";
try
{
st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITI VE,ResultSet.CONCUR_UPDATABLE);
String query = "LOAD DATA INFILE '"+filename+"' INTO TABLE fujitsu_spare_import (date_temp,time,scan_type,fujitsu_order_number,tec hnician_or_shippiment);";
System.out.println("string load file " + query);
st.executeUpdate(query);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Error in loading file into fujitsu_spare_import \n");
st = null;
}
...
try
{
conn.close();
}catch (SQLException sqle)
{
//reportError("getSAGECustomerBean","SQLException raised whilst closing connection");
throw new ComponentFailureException("SQLException raised whilst closing connection" + sqle);
}
return return_vec;
}// end of method updateImportSparePartsBean
Details
----------
j2sdk1.4.2_04
MySQL 4.0.20