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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 24168
    
  30

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
 
wood burning stoves
 
subject: LOAD DATA INFILE problem
 
Similar Threads
Database access, potential threading problem?
LOAD DATA INFILE problem
To Get the Number of Matches Found in the Database
Load Data Infile Issues
Resultset to flat file.