Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

LOAD DATA INFILE problem

 
Anand Satchin
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ernest Friedman-Hill
author and iconoclast
Marshal
Pie
Posts: 24212
35
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Welcome to JavaRanch!

We have a forum devoted to JDBC; I'm going to move this there for you. Check the link at the top of this page.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic