sql loader does not load, but no useful info in loader.log
561854May 23 2008 — edited May 25 2008I hope this is the correct forum for this question about sql loader.
We have a Java application that invokes sql loader after building an input file of data to be loaded. After running the application the loader.log shows nothing loaded, i.e.
Control File: C:/digir_client/config/loader.ctl
Data File: C:\digir_client\result.txt
Bad File: C:/digir_client/config/result.bad
Discard File: none specified
Table STATCACHE:
0 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Total logical records skipped: 0
Total logical records read: 0
Total logical records rejected: 0
Total logical records discarded: 0
No records read and no records loaded. I suppose the no records read is the problem but there is no indication of why.
If I run the same loader command that Java is running from a command line the load works.
sqlldr control=C:/digir_client/config/loader.ctl userid=aaa/bbbb
The control file has an absolute path to the data file:
load data
CHARACTERSET UTF8
INFILE 'C:\digir_client\result.txt'
append into table statcache
fields terminated by '|'
TRAILING NULLCOLS
(
Since the problem only occurs when the Java app tries to run the loader the problem is probably is related to Java and has nothing to do with sql loader but if sql loader could tell me why it could not read the records I would be well on my way to figuring out how to fix the problem.
So my question is, can sql loader tell me why it is not reading?
Thanks for any advice,
beeky