wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes sqlldr issues... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "sqlldr issues..." Watch "sqlldr issues..." New topic
Author

sqlldr issues...

nandini lagunia
Ranch Hand

Joined: May 05, 2009
Posts: 57
Hi,

I am using sqlldr utility in my java application.
The only hitch is when I try to load data in the database making one field null where the
column in the database corresponding to that field is not nullable, it simply logs the error
message in the log file and doesn't tell me if any error has occurred.

If I wish to find if any error has occurred during loading, will I have to dive into the
created log file and search for the error(s) ???

I don't think it's a smart way of doing things.
Do you know any workaround???

Thanks in advance.
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14687
    
  16

Isn't a ".bad" file generated ?


[My Blog]
All roads lead to JavaRanch
nandini lagunia
Ranch Hand

Joined: May 05, 2009
Posts: 57
Yeah... a bad file is generated.
But my question is will I have to skim through the generated .bad file in order to find if any error has occurred during data loading??
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14687
    
  16

No. You just have to remove the file before loading, and after calling sqlldr, check if the file is there. If it's there, then an error occurred.
nandini lagunia
Ranch Hand

Joined: May 05, 2009
Posts: 57
okk...

That means I'll have to skim through .bad and .log file to display the errors.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sqlldr issues...