Manoj, Put the classes12.zip file in your WEB-INF/lib directory. Depending on your app server, you might need to change the name to classes12.jar.
-Richard At 06:03 PM 9/25/2002 +0000, you wrote: >Hi Friends, > >THANKS for sharing your thoughts on my problmes. > >I tried to run my Servlet-JDBC from Browser also on which I get following >Error at my command console - wonder why. >---------------------------------------------------------------- >11:53:15,713 INFO [MainDeployer] Successfully completed deployment of >package: file:/jboss-3.0.0_tomcat-4.0.3/server/default/deploy/ki >thany.war >11:53:22,531 INFO [Engine] DBServlet: init >11:53:22,562 ERROR [STDERR] java.lang.ClassNotFoundException: >oracle.jdbc.OracleDriver >--------------------------------------------------------------- > >As mentioned earlier, I have my App Server and DB Servere on DIFFERENT >machines. I have loadede my JDBC Drivers (both ZIP and JAR) on my App. >Server and have included them in CLASSPATH as well. > >Any relevanet infor. on this is appreciated. > >THANKS EXPERTS. > >Manoj G. Kithany > >>From: Chris Pratt <[EMAIL PROTECTED]> >>Reply-To: "A mailing list for discussion about Sun Microsystem's Java >> Servlet API Technology." <[EMAIL PROTECTED]> >>To: [EMAIL PROTECTED] >>Subject: Re: simplest Servlet-JDBC not working >>Date: Wed, 25 Sep 2002 10:53:29 -0700 >> >>You can do it, but it's a royal pain. You have to create dummy >>HttpServletRequest and HttpServletResponse objects to pass into doGet or >>doPost, which is a big job just to be able to run it from the command line. >> (*Chris*) >> >>----- Original Message ----- >>From: "Mike Marchywka" <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]> >>Sent: Wednesday, September 25, 2002 10:45 AM >>Subject: Re: [SERVLET-INTEREST] 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(); > > > >_________________________________________________________________ >MSN Photos is the easiest way to share and print your photos: >http://photos.msn.com/support/worldwide.aspx > >___________________________________________________________________________ >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
