wood burning stoves 2.0*
The moose likes JDBC 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 » Databases » JDBC
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: 24183
    
  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]
Anand Satchin
Greenhorn

Joined: Mar 24, 2005
Posts: 10
Hi guys ,

I have sorted out the problem! yahooooooooooo

code

try
{
Statement st = conn.createStatement();
// Load the data
String filename = "c:\\\\spares_import.csv";
String tablename = "fujitsu_spare_import";

// If the file is comma-separated, use this statement
st.executeUpdate("LOAD DATA INFILE \"" + filename + "\" INTO TABLE " + tablename + " FIELDS TERMINATED BY ','");
}
catch(Exception e)
{
e.printStackTrace();
st = null;
}


Thanks anyway

Cheers,
Anand
 
jQuery in Action, 2nd edition
 
subject: LOAD DATA INFILE problem
 
Similar Threads
Resultset to flat file.
To Get the Number of Matches Found in the Database
LOAD DATA INFILE problem
Database access, potential threading problem?
Load Data Infile Issues