This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes Java in General and the fly likes Trouble in executing sqlldr through java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Java in General
Bookmark "Trouble in executing sqlldr through java" Watch "Trouble in executing sqlldr through java" New topic
Author

Trouble in executing sqlldr through java

chetan phanse
Greenhorn

Joined: Jun 13, 2011
Posts: 1
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
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

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
Sheriff

Joined: Oct 13, 2005
Posts: 39084
    
  23
Welcome to the Ranch

We quote that article by Michael Daconta at least once a week.
 
GeeCON Prague 2014
 
subject: Trouble in executing sqlldr through java