Re: Oralce exp doesn't work with Java runtime

Boxer wrote:
> I was trying to run oracle exp through the java, code was like:
>
> ....
> Runtime runtime = Runtime.getRuntime();
> Process p = runtime.exec("exp scott/tiger File=scott.dmp TABLES=(scott.
> %)");
> p.waitFor(); //this line will make the p hang!!! p can exit normally
> without it.
> ...
>
> But the program hang there never get finished.
>
> I tried this:
>
> ....
> Runtime runtime = Runtime.getRuntime();
> Process p = runtime.exec("exp scott/tiger File=scott.dmp TABLES=(scott.
> %)");
> Thread.sleep(10000); //obviously p has exited after this
> System.out.println(""+p.exitValue());
> ...
> the last line throws an exception saying the process has not exit yet.
>
> The environment is Eclipse, Java 1.5, Junit
>
> But I didn't find such behavior with calling sqlplus this way. Any
> idea what make this EXP utility not working with java runtime?

If the exp command outputs any text, then you should read that (and printing it may actually help you troubleshoot).

Arne Received on Sat May 12 2007 - 18:24:44 CDT