It's a servlet, it doesn't have a main(), so you can't run it using the java
command at the command line. You have to run it under a Servlet Engine.
(*Chris*)
----- Original Message -----
From: "Manoj Kithany" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 25, 2002 9:32 AM
Subject: [SERVLET-INTEREST] simplest Servlet-JDBC not working
> 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
