what type of error is comming.
u have not defined the error...
Paresh
J Krishna Rao wrote:
> Hi Pradeep,
> Still it is not working,do you have any other idea why it is not working after
> changing as per your suggestion in the code .
>
> Waiting any other idea or suggestion.....
>
> Thanks
> krishna
>
> import java.io.*;
> import java.sql.*;
>
> import javax.servlet.*;
> import javax.servlet.http.*;
>
> /**
> * This is a simple example of an HTTP Servlet. It responds to the GET
> * and HEAD methods of the HTTP protocol.
> */
> public class Hello extends HttpServlet
> {
> /**
> * Handle the GET and HEAD methods by building a simple web page.
> * HEAD is just like GET, except that the server returns only the
> * headers (including content length) not the body we write.
> */
> public void doGet (HttpServletRequest request,
> HttpServletResponse response)
> throws ServletException, IOException
> {
> PrintWriter out;
>
> String title = "Example Apache JServ Servlet";
>
> // set content type and other response header fields first
> response.setContentType("text/html");
>
> try{
>
> // then write the data of the response
> out = response.getWriter();
>
> out.println("<HTML><HEAD><TITLE>");
> out.println(title);
> out.println("</TITLE></HEAD><BODY bgcolor=\"#FFFFFF\">");
> out.println("<H1>" + title + "</H1>");
> out.println("<H2> Congratulations! ApacheJServ 1.1 is
> working!<br>");
>
> // Load the Oracle JDBC driver
> try {
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> }catch(java.lang.ClassNotFoundException e) {
> System.err.print("ClassNotFoundException: ");
> System.err.println(e.getMessage());
> }
>
> //Connect to the Database
> Connection con =
> DriverManager.getConnection("jdbc:odbc:local123","scott","tiger");
> //Driver drv=DriverManager.getDriver("jdbc:odbc:local123");
>
> //Create a Statement
> Statement stmt = con.createStatement();
>
> //Query
> ResultSet rset = stmt.executeQuery("select EMPNAME from EMP1");
>
> // Iterate through the result and print the employee names
> while(rset.next())
> out.println(rset.getString("EMPNAME"));
>
> }
> catch( SQLException exc){
> System.out.println(exc);
> }
> catch(IOException exe){
> System.out.println(exe);
> }
> finally{
> System.out.println("</BODY></HTML>");
> System.out.close();
> }
>
> }
> }
>
> pradeep wrote:
>
> > Hi
> >
> > put this piece of code
> > > out.println("</BODY></HTML>");
> > > out.close();
> >
> > outside(if possible in finally block / at the end of the program ) the
> >
> > >while (rs.next())
> >
> > loop statement.....
> >
> > HTH
> >
> > -pradeep
> >
> > -
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
