Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oralce exp doesn't work with Java runtime
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?
Thx Received on Sat May 12 2007 - 08:48:55 CDT