You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Gu...@eircom.ie on 2003/12/10 14:57:43 UTC

RE:Sorry for posting twice. Tomcat not recognizing JDB drivers - 4.1.29!-Please Help

sorry about posting it twice. It seem a long delay in getting the mails
through.
 
 
Thanks & Regards,
 
Divya

-----Original Message-----
From: GuptaD@eircom.ie [mailto:GuptaD@eircom.ie]
Sent: 10 December 2003 12:25
To: tomcat-user@jakarta.apache.org
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:jakarta@trollingers.com
<ma...@trollingers.com> ] 
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: GuptaD@eircom.ie [ mailto:GuptaD@eircom.ie <ma...@eircom.ie> ]

Sent: Tuesday, December 09, 2003 9:42 AM 
To: tomcat-user@jakarta.apache.org 
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>> 




Re: Sorry for posting twice. Tomcat not recognizing JDB drivers - 4.1.29!-Please Help

Posted by Ben Souther <bs...@fwdco.com>.
Put the driver in:
 TOMCAT_HOME/common/lib

You will also need to change the extension to ".jar".


On Wednesday 10 December 2003 08:57 am, GuptaD@eircom.ie wrote:
> sorry about posting it twice. It seem a long delay in getting the mails
> through.
>
>
> Thanks & Regards,
>
> Divya
>
> -----Original Message-----
> From: GuptaD@eircom.ie [mailto:GuptaD@eircom.ie]
> Sent: 10 December 2003 12:25
> To: tomcat-user@jakarta.apache.org
> 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:jakarta@trollingers.com
> <ma...@trollingers.com> ]
> 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: GuptaD@eircom.ie [ mailto:GuptaD@eircom.ie <ma...@eircom.ie>
> ]
>
> Sent: Tuesday, December 09, 2003 9:42 AM
> To: tomcat-user@jakarta.apache.org
> 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>>

-- 
Ben Souther
F.W. Davison & Company, Inc.



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org