I do this all the time for testing purposes. -----Original Message----- From: Mike Marchywka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:45 PM To: [EMAIL PROTECTED] Subject: Re: simplest Servlet-JDBC not working
It can be nice to ADD a main to a derived class - for testing from a more controlled environment. I've never tried this with a servlet but it works for applets. You could even create a debug super class I guess. > -----Original Message----- > From: Galbreath, Mark [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 12:58 PM > To: [EMAIL PROTECTED] > Subject: Re: simplest Servlet-JDBC not working > > > Yeah, and he's calling super.init( config ) too. > > -----Original Message----- > From: Chris Pratt [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 12:44 PM > To: [EMAIL PROTECTED] > Subject: Re: simplest Servlet-JDBC not working > > > 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 > > ______________________________________________________________ > _____________ > 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
