Trouble in executing sqlldr through java

[chetan phanse]

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

[Paul Clapham]

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.

[Campbell Ritchie]

Welcome to the Ranch

We quote that article by Michael Daconta at least once a week.