The problem is not probably in HTML code
It is in Java code
Because the calass file named sun.jdbc.odbc.JdbcOdbcDriver might not be in
servlets class path thats why it might be giving error.
-----Original Message-----
From: Punam Chordia <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, March 16, 2000 2:06 PM
Subject: Re: problem during accessing database...
>I guess the body tag is missing
>
>Punam Chordia
>ITL Infosys
>Pune Infotech Park
>91-02139-32800 Extn. 2025
>
>> -----Original Message-----
>> From: J Krishna Rao [SMTP:[EMAIL PROTECTED]]
>> Sent: Wednesday, March 15, 2000 PM 05:41
>> To: [EMAIL PROTECTED]
>> Subject: problem during accessing database...
>>
>> 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
>
>___________________________________________________________________________
>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
