i putting them in "/jdbc" directory and then including that in CLASSPATH as: ------------------------------------------------------------------ CLASSPATH=/usr/java130/lib/tools.jar:/jboss/bin/run.jar:/jboss/catalina/common/lib/servlet.jar:/jdbc/classes12.jar:/jdbc/classes111.jar :/jdbc/nls_charset11.jar:/jdbc/nls_charset12.jar:/hari/WEB-INF/classes:/hari/WEB-INF/classes/mybean ----------------------------------------------------------------
thanking you. HARI >From: "Turner, John" <[EMAIL PROTECTED]> >Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> >To: 'Tomcat Users List' <[EMAIL PROTECTED]> >Subject: RE: Simplest Servlet-JDBC not working >Date: Wed, 25 Sep 2002 14:27:02 -0400 > > >WHERE did you load them on your App server!? > >John > > > > -----Original Message----- > > From: hari hari [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, September 25, 2002 2:07 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Simplest Servlet-JDBC not working > > > > > > 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(); _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
