hi friends, thanking you for sending email.
I tried runnin my Servlet-JDBC from Browser also on which I getting following Error at my command console. ---------------------------------------------------------------- 11:53:15,713 INFO [MainDeployer] Successfully completed deployment of package: file:/jboss-3.0.0_tomcat-4.0.3/server/default/deploy/app.war 11:53:22,531 INFO [Engine] DBServlet: init 11:53:22,562 ERROR [STDERR] java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver --------------------------------------------------------------- I having my App Server and DB Servere on DIFFERENT machines. I having loaded my JDBC Drivers (both ZIP and JAR) on my App. Server and have included them in CLASSPATH as well. police helping me thought. --HARI >From: Vivek Chopra <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Tomcat Users List <[EMAIL PROTECTED]> >Subject: Re: Simplest Servlet-JDBC not working >Date: Wed, 25 Sep 2002 10:39:14 -0700 (PDT) > >Hari, > >You don't typically try to execute a servlet >directly.. it is invoked by the servlet engine when >you browse over to the appropriate URL. The error you >see is due to the fact that the JRE is looking for a >main() method. Since this is a servlet, it doesnt have >one! > >Please read the Tomcat app developer's guide at >http://jakarta.apache.org/tomcat/tomcat-4.1-doc/appdev/index.html >on how to deploy a servlet in Tomcat. > >- Vivek > >--- hari hari <[EMAIL PROTECTED]> wrote: > > hi my many freinds, > > > > i having simplest of Servlet program > > (DBServlet.java) which is trying to > > connecting to my ORCL DB. > > > > my Application and DB Server are sit on different > > machines. I having my JDBC > > Drivers (in ZIP format) on my App Server installed > > with CLASSPATH. > > > > when I trying to run i getting below errors: police > > helping me > > # 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(); > > } _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
