hi ! if any one can tell me how to Call isql or osql (MSSQL SERVER) from java and get the exitvalue for loging !
i am trying this code but the code hangs when i run !i got this code from javaworld link :
http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html ===========================================================================
import java.util.*;
import java.io.*;
class StreamGobbler extends Thread
{
InputStream is;
String type;
StreamGobbler(InputStream is, String type)
{
this.is = is;
this.type = type;
}
public void run()
{
try
{
InputStreamReader isr = new InputStreamReader(is);
BufferedReader br = new BufferedReader(isr);
String line=null;
while ( (line = br.readLine()) != null)
System.out.println(type + ">" + line);
} catch (IOException ioe)
{
ioe.printStackTrace();
}
}
}
public class WindowsExec
{
public static void main(String args[])
{
if (args.length < 1)
{
System.out.println("USAGE: java GoodWindowsExec <cmd>");
System.exit(1);
}
try
{
String osName = System.getProperty("os.name" );
String[] cmd = new String[3];
if( osName.equals( "Windows 2000" ) )
{
cmd[0] = "cmd.exe" ;
cmd[1] = "/C" ;
cmd[2] = args[0];
}
else if( osName.equals( "Windows 95" ) )
{
cmd[0] = "command.com" ;
cmd[1] = "/C" ;
cmd[2] = args[0];
}
Runtime rt = Runtime.getRuntime();
System.out.println("Execing " + cmd[0] + " " + cmd[1]
+ " " + cmd[2]);
Process proc = rt.exec(cmd);
// for error message
StreamGobbler errorGobbler = new
StreamGobbler(proc.getErrorStream(), "ERROR");
// for output
StreamGobbler outputGobbler = new
StreamGobbler(proc.getInputStream(), "OUTPUT");
// kick them off
errorGobbler.start();
outputGobbler.start();
// exit value
int exitVal = proc.waitFor();
System.out.println("ExitValue: " + exitVal);
} catch (Throwable t)
{
t.printStackTrace();
}
}
}//end of class
===========================================================================
The code compiles and runs well for other dos commands like this
$ java WindowsExec "dir *.java" ---> this works fine
but when i try to run it for isql or osql like this the code hangs
$ java GoodWindowsExec "isql.exe /Usa /Psa /i test.sql " where /U = username /P =Password and /i = input sql file
can anyone please help !
