aspose file tools*
The moose likes Web Services and the fly likes Execute sqlldr command from java code. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "Execute sqlldr command from java code." Watch "Execute sqlldr command from java code." New topic
Author

Execute sqlldr command from java code.

Ritu Kapoor
Ranch Hand

Joined: Oct 03, 2004
Posts: 102
Hi,

I am not able to transfer the data from txt to oracle table using sqlldr. If I execute the same command from cmd, it executes fine but does not work if I execute from java code.

Please find the code below






Please help to resolve it.
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12788
    
    5
Process proc = rt.exec(cmd);

Executes one command line. You appear to have multiple commands you want to run. In that case, I would write a .bat file containing all of those commands and exec() the batch file.

You must also provide for consuming the stdOut and stdErr streams created by the process - see the Process JavaDocs.

Bill
 
Consider Paul's rocket mass heater.
 
subject: Execute sqlldr command from java code.