Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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


Win a copy of The Software Craftsman this week in the Agile forum!
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: 19359
    
  10

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: 41629
    
  31
Welcome to the Ranch

We quote that article by Michael Daconta at least once a week.
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: Trouble in executing sqlldr through java