cannt read the bad file from java code [message #552430] |
Wed, 25 April 2012 14:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/eb527c1ceaba286e6ceb901921c96921?s=64&d=mm&r=g) |
ssurajita
Messages: 1 Registered: April 2012 Location: bhubaneswar
|
Junior Member |
|
|
We are using sqlldr query to load data into a table. This is handled in a java code. We are uploading an xls file which gets converted into csv and then the sqlloader call works, which in turn creates a bad and log file for error messages.
But I am not able to locate the bad file(in filesystem) within java code.
Below piece of used.
File file =new File(destfilePath);
if(file.exists()){
FileReader fr = new FileReader(file);
LineNumberReader lnr = new LineNumberReader(fr);
linenumber=0;
while (lnr.readLine() != null){
linenumber++;
}
logger.info("Total number of lines : " + linenumber);
lnr.close();
}else{
logger.info("File does not exists!");
}
The above code is able to locate CSV ,but not the bad file(whereas both files created in same path).
Can anybody have any idea, please share it with me.
|
|
|
|