Get output of powershell script

[xychen7]

Hi, I'm trying to execute a powershell script to run psql to create database.
I purposely give a invalid IP address to get the error message but getCommandOutput() return nothing although isLastCommandInError () return True .
How can I get the actual output of the script ?

My code :

try  {
	PowerShell powerShell = PowerShell.openSession("C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe");
	PowerShellResponse response = powerShell.executeScript("D:\\scripts\\test.ps1",param);
			 
	 if (powerShell.isLastCommandInError ()) {
		System.out.print(response.getCommandOutput());
	 }	 
	System.out.print("Successfully initialize database.");	
}catch (Exception e) {
	System.out.print( e.getMessage());
}

My powershell script :

$output =  & $psql $params -t -A -c "create database $dbName;"  

if  ($LastExitCode -ne 0) {
    $output |Out-File -filepath $log
    write-output "Database initialize incomplete. Please refer to $log for details."
    return "Database initialize incomplete.$output"
}

The error message if I execute the script in powershell :

Database initialize incomplete. Please refer to D:\scripts\201812211503.err for details.
Database initialize incomplete.psql: could not connect to server: Connection timed out (0x0000274C/10060)       
Is the server running on host "10.0.xx.xx" and accepting TCP/IP connections on port 5432?

Any help appreciated.

[xychen7]

nvm, I turn to processBuilder and it works perfectly. In case anyone face same issue, below is my code :

try  {
	String powershell = "C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe";
	String scripts = System.getProperty("user.dir")+"\\scripts\\test.ps1";
	String msg= "";

	ProcessBuilder builder = new ProcessBuilder( powershell, "\""+scripts+" "+param+"\"");
	builder.redirectErrorStream(true);
	Process p = builder.start();
	BufferedReader r = new BufferedReader(new InputStreamReader(p.getInputStream()));
	String line;
	while (true) {
		line = r.readLine();
		if (line == null)  break; 
		msg = msg+line.trim();
	}
	r.close();
	if (p.exitValue() != 0 )
		System.out.print(msg);
	else System.out.print("Successfully execute script.");
}catch (Exception e) {
	System.out.print(e.getMessage());
}