Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sqlldr issues...

 
nandini lagunia
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Isn't a ".bad" file generated ?
 
nandini lagunia
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
okk...

That means I'll have to skim through .bad and .log file to display the errors.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic