Run Oracle import Command from Java and see Console output

Question

I am running an Oracle database Command for a .dmp file like this:

String impcmd = "imp askul/askul@askdb file=mydumpfile.dmp log=mylogfile.log fromuser=askul touser=askul full=N ignore=Y grants=Y indexes=Y";
Process p = Runtime.getRuntime().exec(impcmd);
p.waitFor();
BufferedReader br = new BufferedReader(new InputStreamReader(p.getInputStream()));
String line = br.readLine();
while(line != null){
System.out.println(line);
line = br.readLine();
}

The database import is Happening Fine on the Background, but I want to be Able to see the console output as the Import goes on as I now have to guess whether it is complete or not. What Am I missing here?

score 1 · Accepted Answer · edited May 23 '17 at 10:27

1

You need to capture the stdout and stderr in separate threads (to prevent blocking) and output this as you get it, whilst waiting for the process to complete.

Note that you may need to read both stdout and stderr. Or your output may be going to the configured log file instead.

See this answer for more info and references to example code. Also check this article, which discusses common pitfalls when using Runtime.exec()

edited May 23 '17 at 10:27

Community

1
1

answered Jan 29 '14 at 14:19

Brian Agnew

268,207
37
334
440

Man I cant get a thing out of that article. – Stanley Mungai Jan 29 '14 at 14:37
What precisely is the issue ? – Brian Agnew Jan 29 '14 at 15:10

score 0 · Answer 2 · answered Jan 29 '14 at 14:21

0

I believe you just want to move the call to waitFor.

// p.waitFor();
BufferedReader br = new BufferedReader(new InputStreamReader(p.getInputStream()));
String line = br.readLine();
while(line != null){
  System.out.println(line);
  line = br.readLine();
}
p.waitFor(); // <-- to here.

answered Jan 29 '14 at 14:21

Elliott Frisch

198,278
20
158
249

Still happenning in the BAckground even after I moved `p.waitFor();` to after the while loop. – Stanley Mungai Jan 29 '14 at 14:29
Are you sure there's console output to get? – Elliott Frisch Jan 29 '14 at 14:30
If I went to cmd and executed this command, it will show importing table...... 23rows.. Something like this. This is what I want to see. – Stanley Mungai Jan 29 '14 at 14:42
could the output have gone to stderr? – Jan 29 '14 at 15:03

Run Oracle import Command from Java and see Console output

2 Answers2

Linked