Gurus-
I am struggling for this over ten days. Please help me.(^_^)
Everything else is fine, except for the
java runtime part (towards the end of the file). The purpose of GQL.java is to take user input from the web interface and query the Oracle DB in my account, then save the SQL query result into a text file called "foo.txt" into my public_html directory; then I need to call a Perl script "newfup.cgi" which resides under the same path as GQL.java, to take the file "foo.txt" as input and generate a GIF file called "plotfile.gif" and put this GIF file to my public_html directory so that the user can see this image file as the final query result.
There must be something wrong with the runtime call. I could execuate the Perl script on the command line by "/usr/bin/perl newfup.cgi". I could get the image file plotfile.gif generated and saved under my public_html directory this way. But it just wouldn't work out from execuating the
servlet code.
------
import java.net.*;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import oracle.jdbc.driver.*;
public class GQL extends HttpServlet
{
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
...
try
{
String cmd = "/usr/bin/perl newfup.cgi";
Runtime r = Runtime.getRuntime();
Process p = r.exec(cmd);
BufferedReader in = new BufferedReader(new InputStreamReader(p.getInputStream()));
String tmp = new String();
while (tmp != null)
{
tmp = in.readLine();
}
out.println("<P>");
out.println("<CENTER>");
out.println("<img src=\"http://...myAccount.../plotfile.gif\">");
out.println("<P>");
out.println("<img src=\"http://...myAccount.../bully.gif\">");
out.println("</CENTER>");
}
catch (Exception e)
{
e.printStackTrace();
}
...
}
}
[This message has been edited by Henry Zhang (edited February 24, 2001).]
