Display the entire stack trace. Mark
-----Original Message----- From: Manoj Kithany [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:33 PM To: [EMAIL PROTECTED] Subject: 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
