In common/lib -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: woensdag 10 december 2003 11:48 To: [EMAIL PROTECTED] Subject: Tomcat not recognizing JDB drivers - 4.1.29!-Please Help
Hi everybody, I'm really new to Tomact and I'm facing this problem. I have put the classes in the package and Tomcat is now able to recognize that. Now It is not recognizing the Oracle drivers which I have them in C:\Jdbcdrivers as classes12.zip and added in CLASSPATH but When I call it from jsp page , it is giving me error as :- java.sql.SQLException: No suitable driver Could you please point me in the right direction as where it is expecting thoose drivers. -------My Jsp code is----- <%@ page import="java.sql.*" %> <%@ page session="true" %> <%@ page language="java" import="pkgclass.*" %> <jsp:useBean id="PV1" scope="page" class="pkgclass.UserLogin"/> <%-- Statements to stop caching at client site --%> <% response.setHeader("Cache-Control","no-store"); //HTTP 1.1 response.setHeader("Pragma","no-cache"); //HTTP 1.0 response.setDateHeader ("Expires", 0); //prevents caching at the proxy %> <% PV1.setSID("SDGT"); PV1.setHost("dpwdev02") ; PV1.setSID("drpd"); PV1.setUID("crdbweb") ; PV1.setPWD("crdbweb"); String sres = PV1.amplogin(); out.println("Msgback : "+sres); %> <html> <Head><Title>Boots First page</title></head> <html> <body bgcolor="#EBE4DF"> <Table> <TH>Broadband Online Order Tracking system </TH> </Table> </body> </html> -------------------------------------------------------- I'm attaching my class code with this mail but I think the problem is that Tomcat can't recognize the drivers Thanks in advance for your reply.. Regards, Divya -----Original Message----- From: jakarta [ mailto:[EMAIL PROTECTED] Sent: 09 December 2003 15:04 To: 'Tomcat Users List' Subject: RE: Tomcat error while using a class with JSP! I believe that you have to package your class ie boots.PVDatabase as I recall unpackaged classes are not valid John -----Original Message----- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:42 AM To: [EMAIL PROTECTED] Subject: Tomcat error while using a class with JSP! Hi All, I am new to Tomcat so I would really appreciate if somebody could help me in this. I have Tomcat 4.1.29 installed on my windows 2000 machine. At the same level as examples is in Tomcat path, I've created a directory called boots(this is my application directory.) and have a index.jsp under boots and a class called PVDatabase.class under C:\Program Files\Apache Group\Tomcat 4.1\webapps\boots\WEB-INF\classes directory where C:\Program Files\Apache Group\Tomcat 4.1 is my CATALINA_HOME variable. I have modified server.xml to include the context boots there. When I try to call this class from my index.jsp it gives me the following error. org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 2 in the jsp file: /index.jsp Generated servlet error: [javac] Compiling 1 source file C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\boots\index_jsp.java:44: cannot resolve symbol symbol : class PVDatabase location: class org.apache.jsp.index_jsp PVDatabase PV1 = null; ^ An error occurred at line: 2 in the jsp file: /index.jsp Generated servlet error: C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\boots\index_jsp.java:46: cannot resolve symbol symbol : class PVDatabase location: class org.apache.jsp.index_jsp PV1 = (PVDatabase) pageContext.getAttribute("PV1", PageContext.PAGE_SCOPE); ^ An error occurred at line: 2 in the jsp file: /index.jsp Generated servlet error: C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\boots\index_jsp.java:49: cannot resolve symbol symbol : class PVDatabase location: class org.apache.jsp.index_jsp PV1 = (PVDatabase) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "PVDatabase"); ^ 3 errors at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHa ndler.java:130) at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.ja va:293) at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:353) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:370) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.ja va:473) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:190) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241 7) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:78 1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:58 9) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:666) at java.lang.Thread.run(Thread.java:536) I am not really sure as what am I missing here in configuration. I'm sending my server.xml and index.jsp with this mail.. Looking forward to hear from you very soon. Thanks & Regards, Divya <<server.xml>> <<index.jsp>>