Tomcat not recognizing JDB drivers

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Struts - A MVC web framework

Tomcat - JSP/Servlet container

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

JSP - A mailing list about Java Server Pages specification and reference

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Oracle Connection Pooling in 3 2 2
•	Servlet : Session invalidate
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Tomcat and webapplication specific java library path
•	Running a Simple JMS Example
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	Cannot find message resources under key org apache struts action MESSAGE
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	url string for connecting jboss to oracle
•	Value attribute of <html:checkbox
•	javax servlet ServletException: BeanUtils populate
•	HTTP Status 404 The requested resource is not available
•	5 0 18: Windows XP Pro vs Windows 2000

Tomcat not recognizing JDB drivers - 4.1.29!-Please Help

Tomcat not recognizing JDB drivers - 4.1.29!-Please Help

2003-12-10 - By GuptaD@(protected)

Back

Reply: 1 2 3 4

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@(protected)
<mailto:jakarta@(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: GuptaD@(protected) [ mailto:GuptaD@(protected) <mailto:GuptaD@(protected)> ]

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

Source code of 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

(this.getClass().getClassLoader(),
"PVDatabase");
^
3 errors

at
org.apache.jasper.compiler.DefaultErrorHandler

Source code of org.apache.jasper.compiler.DefaultErrorHandler

(DefaultErrorHa
ndler.java:130)
at
org.apache.jasper.compiler.ErrorDispatcher

Source code of org.apache.jasper.compiler.ErrorDispatcher

(ErrorDispatcher.ja
va:293)
at
org.apache.jasper.compiler.Compiler

Source code of org.apache.jasper.compiler.Compiler

(Compiler.java:353)
at
org.apache.jasper.compiler.Compiler

(Compiler.java:370)
at
org.apache.jasper.JspCompilationContext

Source code of org.apache.jasper.JspCompilationContext

(JspCompilationContext.ja
va:473)
at
org.apache.jasper.servlet.JspServletWrapper

Source code of org.apache.jasper.servlet.JspServletWrapper

(JspServletWrapper.ja
va:190)
at
org.apache.jasper.servlet.JspServlet

Source code of org.apache.jasper.servlet.JspServlet

(JspServlet.java:295)

at
org.apache.jasper.servlet.JspServlet

(JspServlet.java:241)
at javax.servlet.http.HttpServlet

Source code of javax.servlet.http.HttpServlet

(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain

Source code of org.apache.catalina.core.ApplicationFilterChain

(Applica
tionFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain

(ApplicationFilt
erChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve

Source code of org.apache.catalina.core.StandardWrapperValve

(StandardWrapperValv
e.java:256)
at
org.apache.catalina.core.StandardPipeline

Source code of org.apache.catalina.core.StandardPipeline

$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase

Source code of org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve

Source code of org.apache.catalina.core.StandardContextValve

(StandardContextValv
e.java:191)
at
org.apache.catalina.core.StandardPipeline

$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext

Source code of org.apache.catalina.core.StandardContext

(StandardContext.java:241
7)
at
org.apache.catalina.core.StandardHostValve

Source code of org.apache.catalina.core.StandardHostValve

(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

Source code of org.apache.catalina.valves.ErrorReportValve

(ErrorReportValve.java
:172)
at
org.apache.catalina.core.StandardPipeline

$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve

Source code of org.apache.catalina.core.StandardEngineValve

(StandardEngineValve.
java:174)
at
org.apache.catalina.core.StandardPipeline

$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter

Source code of org.apache.coyote.tomcat4.CoyoteAdapter

(CoyoteAdapter.java:193)
at
org.apache.coyote.http11.Http11Processor

Source code of org.apache.coyote.http11.Http11Processor

(Http11Processor.java:78
1)
at
org.apache.coyote.http11.Http11Protocol

Source code of 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

Source code of org.apache.tomcat.util.threads.ThreadPool

$ControlRunnable.run(ThreadPool
.java:666)
at java.lang.Thread

(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>>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>RE: Tomcat error while using a class with JSP!</TITLE>

<META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD>
<BODY>
<DIV>Hi
everybody,</DIV>
<DIV> </DIV>
<DIV>   I'm really new to Tomact and I'm facing this problem.
</DIV> 
     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
[<A
href="mailto:jakarta@(protected)">mailto:jakarta@(protected)</A>]
 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@(protected) [<A href="mailto:GuptaD@(protected)">mailto:GuptaD@(protected)</A>
]
 Sent: Tuesday, December 09, 2003 9:42 AM
 To: tomcat-user@(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

(this.getClass().getClassLoader(),
 "PVDatabase");             
      
^ 3 errors 
        at org.apache.jasper.compiler.DefaultErrorHandler

(DefaultErrorHa

 ndler.java:130)         at org.apache.jasper.compiler.ErrorDispatcher

(ErrorDispatcher.ja

 va:293)         at org.apache.jasper.compiler.Compiler

(Compiler.java:353)
         at
 org.apache.jasper.compiler.Compiler

(Compiler.java:370)
         at
 org.apache.jasper.JspCompilationContext

(JspCompilationContext.ja

 va:473)         at org.apache.jasper.servlet.JspServletWrapper

(JspServletWrapper.ja

 va:190)         at org.apache.jasper.servlet.JspServlet

(JspServlet.java:295)


        at org.apache.jasper.servlet.JspServlet

(JspServlet.java:241)
         at
javax.servlet.http.HttpServlet

(HttpServlet.java:853)         at org.apache.catalina.core.ApplicationFilterChain

(Applica

 tionFilterChain.java:247)         at org.apache.catalina.core.ApplicationFilterChain

(ApplicationFilt

 erChain.java:193)         at org.apache.catalina.core.StandardWrapperValve

(StandardWrapperValv

 e.java:256)         at org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4

 80)         at org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
         at
 org.apache.catalina.core.StandardContextValve

(StandardContextValv

 e.java:191)         at org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4

 80)         at org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
         at
 org.apache.catalina.core.StandardContext

(StandardContext.java:241

 7)         at org.apache.catalina.core.StandardHostValve

(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

(ErrorReportValve.java

 :172)         at org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4

 80)         at org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
         at
 org.apache.catalina.core.StandardEngineValve

(StandardEngineValve.

 java:174)         at org.apache.catalina.core.StandardPipeline

(StandardPipeline.java:4

 80)         at org.apache.catalina.core.ContainerBase

(ContainerBase.java:995)
         at
 org.apache.coyote.tomcat4.CoyoteAdapter

(CoyoteAdapter.java:193)
         at
 org.apache.coyote.http11.Http11Processor

(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

(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>> 
 </BODY></HTML>

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)