Hi Krishna,
It's probably because you are closing your PrintWriter
object out, within your while loop of Resultset.
Regards
Mehdi Nawaz.
--- J Krishna Rao <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have written a small program to access database
> from my servlet,Here
> I am using Apache is my web server,The servlet is
> working proper ,but it
> showing all the print statment but it is not showing
> the output
> generated from database query.it not any showing
> error message in the
> browser also.Will any one help to solve this problem
> ??,I have attached
> below my program for your reference.
>
> waiting for your response.
>
> 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");
>
> //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(1));
> out.println("</BODY></HTML>");
> out.close();
>
> }
> catch( SQLException exc){
> System.out.println(exc);
> }
> catch(IOException exe){
> System.out.println(exe);
> }
>
>
> }
> }
>
>
___________________________________________________________________________
> 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
>
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
___________________________________________________________________________
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
