| View previous topic :: View next topic |
| Author |
Message |
smoo Guest
|
Posted: Wed Jan 07, 2004 4:55 pm Post subject: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
Hello all. This is my first post here on this board, I did cross post
since I was not sure if it would be more a Java or Oracle question.
I am getting the error message in the subject and cannot locate the
oracle.jdbc.driver path. Does anyone know what the location of this
class is so I can add it to my classpath variable?
I am using windows 2000 professional
java j2sdk1.4.2_03 and tomcat-4.1.27
also oracle8i for the database.
I have added a data source in the ODBC sources, within the control
panels in addition to the other sources.
|
|
| Back to top |
|
 |
Galen Boyer Guest
|
Posted: Wed Jan 07, 2004 5:57 pm Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
On Wed, 07 Jan 2004, [email]smoo (AT) uh (DOT) no.com[/email] wrote:
| Quote: | I am getting the error message in the subject and cannot locate
the oracle.jdbc.driver path. Does anyone know what the
location of this class is so I can add it to my classpath
variable?
|
This is usually found $ORACLE_HOME/jdbc/lib/classes12.zip
--
Galen Boyer
|
|
| Back to top |
|
 |
smoo Guest
|
Posted: Wed Jan 07, 2004 6:28 pm Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
did i mention that i love you?
|
|
| Back to top |
|
 |
Galen Boyer Guest
|
Posted: Wed Jan 07, 2004 6:37 pm Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
On Wed, 07 Jan 2004, [email]smoo (AT) uh (DOT) no.com[/email] wrote:
| Quote: | did i mention that i love you?
|
Well, I'd rather get cash.
--
Galen Boyer
|
|
| Back to top |
|
 |
Olaf Heimburger Guest
|
Posted: Wed Jan 07, 2004 7:10 pm Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
smoo <smoo (AT) uh (DOT) no.com> writes:
| Quote: | Hello all. This is my first post here on this board, I did cross post
since I was not sure if it would be more a Java or Oracle question.
I am getting the error message in the subject and cannot locate the
oracle.jdbc.driver path. Does anyone know what the location of this
class is so I can add it to my classpath variable?
I am using windows 2000 professional
java j2sdk1.4.2_03 and tomcat-4.1.27
also oracle8i for the database.
I have added a data source in the ODBC sources, within the control
panels in addition to the other sources.
|
The JDBC driver is in the directory %ORACLE_HOME%/jdbc/lib as the file
classes12.jar or classes12.zip. I prefer to use an application
specific CLASSPATH than setting the system wide CLASSPATH environment
variable (ie. java -cp %ORACLE_HOME%/jdbc/lib/classes12.jar).
--olaf
|
|
| Back to top |
|
 |
smoo Guest
|
Posted: Fri Jan 09, 2004 1:44 am Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
<snip>
I have been able to add these items to my classpaths. I have added the
following:
c:oracleora81bin
c:oracleora81jdbcclasses12.zip
c:oracleora81jdbcclasses12_01.zip
to the following paths:
CLASSPATH
PATH
Under system and also user options or entries. My application will now
compole but it will not run once i have tomcat running. the error
message from tomcat indicates the error at the bottom, and the text in
that error seems to indicate that tomcat cannot find this class either.
========================================================================
Apache Tomcat/4.0.1 - HTTP Status 500 - Internal Server Error
------------------------------------------------------------------------
type Exception report
message Internal Server Error
description The server encountered an internal error (Internal Server
Error) that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Servlet execution threw an exception at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke
(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke
(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process
(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run
(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:534)
root cause
java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver
at Lookup.loadJDBCDriver(Lookup.java:21)
at Lookup.doGet(Lookup.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke
(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke
(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process
(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run
(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:534)
|
|
| Back to top |
|
 |
Galen Boyer Guest
|
Posted: Fri Jan 09, 2004 1:20 pm Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
On Fri, 09 Jan 2004, [email]smoo (AT) ah (DOT) no.com[/email] wrote:
| Quote: | My application will now compole but it will not run once i have
tomcat running. the error message from tomcat indicates the
error at the bottom, and the text in that error seems to
indicate that tomcat cannot find this class either.
|
You probably need to add these to the classpath of Tomcat. I bet
there is a config file or maybe just some startup file where you
can do this.
--
Galen Boyer
|
|
| Back to top |
|
 |
Olaf Heimburger Guest
|
Posted: Fri Jan 09, 2004 8:03 pm Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
smoo <smoo (AT) ah (DOT) no.com> writes:
| Quote: | Under system and also user options or entries. My application will now
compole but it will not run once i have tomcat running. the error
message from tomcat indicates the error at the bottom, and the text in
that error seems to indicate that tomcat cannot find this class either.
|
First remove the settings from the global CLASSPATH. It's just plain
ugly and only leads to errors.
There are three choices:
1. Include the classes12.zip in the WEB-INF/lib directory
of your WAR file
2. Copy the classes12.zip to the WEB-INF/lib directory of your
application tree in the Tomcat installation
3. Copy the classes12.zip to the $TOMCAT/lib directory and configure a
DataSource (the best solution)
BTW, I hope you're not using DriverManager.registerDriver() in your
application. It's not allowed in the J2EE specs and also a bad
practice. Better use a DataSource and configure the database settings
in the server.
--olaf
|
|
| Back to top |
|
 |
Georg Stahl Guest
|
Posted: Sun Jan 11, 2004 2:32 pm Post subject: Re: package oracle.jdbc.driver.OracleDriver does not exits |
|
|
Olaf Heimburger wrote:
| Quote: | smoo <smoo (AT) ah (DOT) no.com> writes:
Under system and also user options or entries. My application will now
compole but it will not run once i have tomcat running. the error
message from tomcat indicates the error at the bottom, and the text in
that error seems to indicate that tomcat cannot find this class either.
First remove the settings from the global CLASSPATH. It's just plain
ugly and only leads to errors.
|
The global CLASSPATH is ignored by Tomcat.
| Quote: |
There are three choices:
1. Include the classes12.zip in the WEB-INF/lib directory
of your WAR file
2. Copy the classes12.zip to the WEB-INF/lib directory of your
application tree in the Tomcat installation
3. Copy the classes12.zip to the $TOMCAT/lib directory and configure a
DataSource (the best solution)
|
The classes12.zip should be renamed to classes12.jar (see
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html#Oracle%208i
).
Georg
|
|
| Back to top |
|
 |
|