Issues with waitFor () : Quick reply should be appreciated

[AdithyaChivukula]

hi,

This is regarding the threading.

while I am trying to do bcp 19 files in the order , it is trying to start bcp the fist file and waiting for a long time and not even releasing.

I dont know why p.waitFor() is going into indefinite loop.

String prepareQuery = "cmd /c "+"c:\\sybase\\bin\\bcp "+archdatabasename+".."+tableName+" in "+processingDirectoryPath+"\\"+file_Name+" -S"+database+" -U"+username+" -P"+password+" -f "+"D:\\2048240\\mapfiles\\"+formatFileName+" -b"+batchCount;

String cmd = prepareQuery;

System.out.println(prepareQuery);
Process p = Runtime.getRuntime().exec(cmd);

p.waitFor();

BufferedReader bcpoutput = new BufferedReader(new InputStreamReader(p.getInputStream()));
BufferedReader stdError = new BufferedReader(new InputStreamReader(p.getErrorStream()));

String thisLine;
while ((thisLine = bcpoutput.readLine()) != null) { // while loop begins here
log.debug(thisLine);
} // end while
s = stdError.readLine();

Err = p.exitValue();
p.destroy();

Thanks,
Adithya

[masijade]

Read this. It is old but still contains good information. For a second thing, I would advise changing to ProcessBuilder. The problem here is probably that the output/error buffer is filling up, and so the "execed" command will hang until it is able to write to them again, but it can't since you are not reading those until the program finishes. You need to read those in separate threads and start reading from them immediately, not when the program ends.