aspose file tools*
The moose likes Java in General and the fly likes LOAD DATA INFILE problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "LOAD DATA INFILE problem" Watch "LOAD DATA INFILE problem" New topic
Author

LOAD DATA INFILE problem

Anand Satchin
Greenhorn

Joined: Mar 24, 2005
Posts: 10
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

Joined: Jul 08, 2003
Posts: 24187
    
  34

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.


[Jess in Action][AskingGoodQuestions]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: LOAD DATA INFILE problem