I am executing sqlldr shell command through my java application using Process and Runtime.
The command runs successfully when the file to be loaded in Oracle is small. However when I have a large file (about 4 million records) the sqlldr process just hangs
However if I run the same sqlldr command through my command prompt on shell it works fine
The process is not killed, but but just stuck and I get njo response in java
Has anybody faced similar problems with executing a shell command process through java.
Any help is appreciated
chetan phanse wrote:Has anybody faced similar problems with executing a shell command process through java.
Absolutely. Even 10 years ago that was a common enough problem that somebody wrote a comprehensive article in JavaWorld explaining how to make that work properly. You should read it: When Runtime.exec() won't.