Manoj,
Are you trying to run this servlet code as an application from the command
line?
Since it extends HttpServlet, you need to run it in a servlet container.
Regards,
Richard
At 04:32 PM 9/25/2002 +0000, you wrote:
>hi,
>
>i am having simplest of Servlet program (DBServlet.java) which is trying to
>connect to my ORCL DB.
>
>My Application and DB Server are on different machines. I am having my JDBC
>Drivers (in ZIP format) on my App Server installed with CLASSPATH.
>
>when I try to run i get below errors:
># java DBServlet
>Exception in thread "main" java.lang.NoSuchMethodError: main
>#
>
>import java.io.*;
>import java.sql.*;
>import javax.servlet.*;
>import javax.servlet.http.*;
>
>public class DBServlet extends HttpServlet {
>
>private Connection con;
>private PrintWriter out;
>private String url = "jdbc:oracle:thin:@MY_IP_ADDRESS:1521:MY_SID";
>
>
>public void init(ServletConfig conf)
> throws ServletException {
> super.init(conf);
> try{
>
> //Class.forName("oracle.jdbc.OracleDriver");
> //con =DriverManager.getConnection(url, "scott", "tiger");
> }catch(Exception e) {
> System.err.println(e);
> }
>}
>
>public void service(HttpServletRequest req, HttpServletResponse res)
> throws ServletException, IOException {
> res.setContentType("text/html");
> try {
> out = res.getWriter();
> out.println("<html>");
> out.println("<head>");
> out.println("<title> Sample JDBC Servlet Demo" + "</title>");
> out.println("</head>");
> out.println("<body>");
>
> Class.forName("oracle.jdbc.OracleDriver");
> con =DriverManager.getConnection(url, "scott", "tiger");
> Statement stmt = con.createStatement();
> ResultSet rs = stmt.executeQuery("select * from emp");
> out.println("<UL>");
> while(rs.next()) {
> out.println("<LI>" + rs.getString("EName"));
> }
> out.println("</UL>");
> rs.close();
> stmt.close();
> } catch(Exception e) { System.err.println(e); }
> out.println("</body>");
> out.println("</html>");
> out.close();
>}
>
>
>_________________________________________________________________
>Join the world's largest e-mail service with MSN Hotmail.
>http://www.hotmail.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
>
___________________________________________________________________________
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
