Standard Runtime.exec() and Buffer I/O question

>>Process proc = rt.exec("sqlplus *****/*****@***** < \"test.sql\"");

should be

Process proc = rt.exec("cmd.exe start /C sqlplus *****/*****@***** <test.sql");

no ... i dont think thats it

Have you tried it? As far as i can see, the only thing that will stop that from working is sqlplus not being on your PATH (oh and test.sql not being in the current directory).

yes i have tried it ... the problem is that u cant do file redirection in exec

http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html

section 4.6

I didn't know it can't do redirection. Problem solved then?

no ... i cant do any of the basic stuff i said above (such as reading in a file and stuff ... so many different methods, i have no idea which is the best way).

Need your assistants

Underneth it also says

"Nevertheless, you do not redirect the output through this approach. The incorrect assumption here is that the exec() method acts like a shell interpreter; it does not. Instead, exec() executes a single executable (a program or script). If you want to process the stream to either redirect it or pipe it into another program, you must do so programmatically, using the java.io package. Listing 4.7 properly redirects the standard output stream of the jecho process into a file."

>>The incorrect assumption here is that the exec() method acts like a shell interpreter

Not an assumption i've made ;-) cmd.exe *is* the shell interpreter, which is started by my code above:

>>java RunAsync cmd.exe start /C time "<time.txt"

And i would *guess* that redirection out will work as well, which i'll now try, attempting to redirect the output of time /T to file time.txt.

ah ... i need this to work on both windows and unix

Actually that 'out' experiment did hang, but 'in' is fine

Please confirm the Windows version works first

To handle both Windows and Linux using exec() will involve using different commands depending on the os (check system properties to determine os).
Perhaps try writing a script/batch to perform the operation (and required redirection) and calling the batch using exec().

Alternately read the sql and perform the calls using JDBC, this would work on both platforms. Let me know if you need more details.
http://java.sun.com/docs/books/tutorial/jdbc/index.html

                   Runtime rt = Runtime.getRuntime();
                    Process proc = rt.exec("sqlplus *****/*****@*****");
                   
                    OutputStream processStream = proc.getOutputStream();
                    PrintWriter pw = new PrintWriter(processStream);

                    InputStream stderr = proc.getErrorStream();
                    InputStreamReader esr = new InputStreamReader(stderr);
                    BufferedReader besr = new BufferedReader(esr);
                   
                    FileReader fr = new FileReader("O:\\LDN_ERS_EQUOTE\\apps\\qedbbot\\src\\com\\ubs\\equote\\qedbbot\\test.sql");  
                    BufferedReader br2 = new BufferedReader(fr);
                   
                    String currentLine = null;
                    while (br2.ready() && (currentLine = br2.readLine()) != null)
                    {
                        pw.println(currentLine);
                    }

                    String line = null;

                    System.out.println("<ERROR>");
                    while (besr.ready() && (line = besr.readLine()) != null)
                        System.out.println(line);
                    System.out.println("</ERROR>");

                    pw.close();
                    besr.close();

                    int exitVal = proc.waitFor();
                    System.out.println("Process exitValue: " + exitVal);

Solution found ... thanks for your sugguestions ... 100 points will be awarded to CEHJ for effort

I'm 99% certain that my code will work actually. I shall ask someone else to test it. It would be easy to change the command string to get it to work on Unix.