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?

Community · Accepted Answer · 2017-05-23 10:27:59Z

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, 2017 at 10:27

CommunityBot

11 silver badge

answered Jan 29, 2014 at 14:19

Brian Agnew

273k38 gold badges342 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Stanley Mungai Over a year ago

Man I cant get a thing out of that article.

Brian Agnew Over a year ago

What precisely is the issue ?

Elliott Frisch · Accepted Answer · 2014-01-29 14:21:00Z

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, 2014 at 14:21

Elliott Frisch

202k20 gold badges166 silver badges265 bronze badges

4 Comments

Stanley Mungai Over a year ago

Still happenning in the BAckground even after I moved p.waitFor(); to after the while loop.

Elliott Frisch Over a year ago

Are you sure there's console output to get?

Stanley Mungai Over a year ago

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.

user972946 Over a year ago

could the output have gone to stderr?

Collectives™ on Stack Overflow

Run Oracle import Command from Java and see Console output

2 Answers 2

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related