list of sql servers

[Vijay Vaddem]

Hi,

Im trying to get the list of sql servers available. For this,
I wrote a batch file with the command "osql /L > C:\servers.txt"

when i try to read this file from java class, it is able to
read the content successfully (Rather most of the times... )

However, sometimes...... it doesn't ...???
I really wonder what could be the reason....
here is the code...

 
public class RunBatchFile
{
    public static void main (String [] args)
    {
        //        //String path = "C:\ ";
        FileReader rd = null;
        ArrayList aListOfServers =  new ArrayList();
        try
        {
            String [] cmd = { "cmd.exe", "/c", "start", "C:\\listofserver.bat" };
            System.out.println ("BEFORE:");
            Process p = Runtime.getRuntime ().exec (cmd);
            System.out.println ("AFTER");
 
            int exitVal = p.waitFor ();
            System.out.println ("Process exitValue: " + exitVal);
            p.destroy ();
 
            
            BufferedReader in = new BufferedReader(new FileReader("C:\\servers.txt"));
            String str;
            while ((str = in.readLine()) != null) {
                System.out.println ("Server Name:" + str.trim());
            }
            in.close();
 
            //System.out.println ("ArrayList Name:" + aListOfServers);
        }
        catch (IOException e)
        {
            System.out.println ("ERR:" + e.getMessage ());
        }
        catch (InterruptedException e)
        {
            System.out.println ("ERR:" + e.getMessage ());
        }

Thanks in advance

Vijay

[Jeanne Boyarsky]

Vijay,
This question is more about file I/O than JDBC. I'm moving this to our I/O forum.