Re: Problems finding my JDBC driver for Oracle
I had trouble once with Oracle 8.1.6 classes12.zip, then when I used 8.1.7, and it worked fine. Another trouble was when trying to use J2SE 1.4 compliant classes with 1.3, so I tried different combinations and then it worked. Hope it helps. miagi - Original Message - From: Nikola Milutinovic [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, January 12, 2004 3:34 AM Subject: Re: Problems finding my JDBC driver for Oracle Dor Orgad wrote: I think this thing is playing funny buggers cos with this new code its giving me the driver not found exception. a i dont know what to d!!! type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 6 in the jsp file: /testing.jsp Generated servlet error: [javac] Compiling 1 source file /export/home/tomcat/jakarta-tomcat-4.1.29/work/Standalone/localhost/_/testin g_jsp.java:48: cannot resolve symbol symbol : class OraceDriver location: package driver java.sql.Driver driver = new oracle.jdbc.driver.OraceDriver(); ^ This would indicate that Oracle's classes are not loaded up. At least not for this run :-) An error occurred at line: 6 in the jsp file: /testing.jsp Generated servlet error: /export/home/tomcat/jakarta-tomcat-4.1.29/work/Standalone/localhost/_/testin g_jsp.java:50: cannot resolve symbol symbol : method getConnection (java.lang.String,java.lang.String,java.lang.String) location: interface java.sql.Driver java.sql.Connection con = driver.getConnection(url,ontrack,iamontrack); Now, this is bad. Looks like the java.sql.* package didn't load properly, either. Are you sure you haven't shot your classloader full of holes? Nix. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Problems finding my JDBC driver for Oracle
make sure your jar file ends with .jar and also, make sure it is not corrupt Filip -Original Message- From: Dor Orgad [mailto:[EMAIL PROTECTED] Sent: Sunday, January 11, 2004 5:18 PM To: [EMAIL PROTECTED] Subject: Problems finding my JDBC driver for Oracle Hi, Im having a great deal of trouble getting tomcat to see my OracleDriver for the JDBC class. I have tried putting it the file classes.jar in both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my WEB-INF/lib directory in my docroot, and nothing seems to work. It seems to pick up the MySQL drivers just fine, but when I stick in the Oracle Driver is comes up with: Caught in processRequest java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle/jdbc/driver/OracleDriver. Can anybody help? Thanks alot Dor -- Dor Orgad Support Center SolNet Solutions Ltd Ph: +64 4 462 5129 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problems finding my JDBC driver for Oracle
It is a .jar file and I can fully unzip it, and the contents contain the directory oracle/jdbc/driver/OracleDriver So i don't think its that. Filip Hanik wrote: make sure your jar file ends with .jar and also, make sure it is not corrupt Filip -Original Message- From: Dor Orgad [mailto:[EMAIL PROTECTED] Sent: Sunday, January 11, 2004 5:18 PM To: [EMAIL PROTECTED] Subject: Problems finding my JDBC driver for Oracle Hi, Im having a great deal of trouble getting tomcat to see my OracleDriver for the JDBC class. I have tried putting it the file classes.jar in both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my WEB-INF/lib directory in my docroot, and nothing seems to work. It seems to pick up the MySQL drivers just fine, but when I stick in the Oracle Driver is comes up with: Caught in processRequest java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle/jdbc/driver/OracleDriver. Can anybody help? Thanks alot Dor -- Dor Orgad Support Center SolNet Solutions Ltd Ph: +64 4 462 5129 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Problems finding my JDBC driver for Oracle
can you do this inside of a JSP
%
try {
this.getClass().getClassLoader().loadClass(oracle.jdbc.driver.OracleDriver
);
}catch ( Exception x ) {
x.printStackTrace();
}
%
without an exception being thrown?
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:28 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
It is a .jar file and I can fully unzip it, and the contents contain the
directory
oracle/jdbc/driver/OracleDriver
So i don't think its that.
Filip Hanik wrote:
make sure your jar file ends with .jar and also, make sure it is
not corrupt
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:18 PM
To: [EMAIL PROTECTED]
Subject: Problems finding my JDBC driver for Oracle
Hi,
Im having a great deal of trouble getting tomcat to see my OracleDriver
for the JDBC class. I have tried putting it the file classes.jar in
both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my
WEB-INF/lib directory in my docroot, and nothing seems to work. It
seems to pick up the MySQL drivers just fine, but when I stick in the
Oracle Driver is comes up with:
Caught in processRequest
java.lang.RuntimeException: java.lang.ClassNotFoundException:
oracle/jdbc/driver/OracleDriver.
Can anybody help?
Thanks alot
Dor
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problems finding my JDBC driver for Oracle
No, that one bombs out too.
Filip Hanik wrote:
can you do this inside of a JSP
%
try {
this.getClass().getClassLoader().loadClass(oracle.jdbc.driver.OracleDriver
);
}catch ( Exception x ) {
x.printStackTrace();
}
%
without an exception being thrown?
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:28 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
It is a .jar file and I can fully unzip it, and the contents contain the
directory
oracle/jdbc/driver/OracleDriver
So i don't think its that.
Filip Hanik wrote:
make sure your jar file ends with .jar and also, make sure it is
not corrupt
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:18 PM
To: [EMAIL PROTECTED]
Subject: Problems finding my JDBC driver for Oracle
Hi,
Im having a great deal of trouble getting tomcat to see my OracleDriver
for the JDBC class. I have tried putting it the file classes.jar in
both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my
WEB-INF/lib directory in my docroot, and nothing seems to work. It
seems to pick up the MySQL drivers just fine, but when I stick in the
Oracle Driver is comes up with:
Caught in processRequest
java.lang.RuntimeException: java.lang.ClassNotFoundException:
oracle/jdbc/driver/OracleDriver.
Can anybody help?
Thanks alot
Dor
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
Re: Problems finding my JDBC driver for Oracle
Hi! Dor Orgad wrote: Im having a great deal of trouble getting tomcat to see my OracleDriver for the JDBC class. I have tried putting it the file classes.jar in both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my WEB-INF/lib directory in my docroot, and nothing seems to work. It seems to pick up the MySQL drivers just fine, but when I stick in the Oracle Driver is comes up with: Caught in processRequest java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle/jdbc/driver/OracleDriver. From what you are writing, I get the impression that you packed the jdbc driver jar _into_ another jar called classes.jar and placed this second jar in your WEB-INF/lib directory. If this is indeed the case, that's your problem. A setup like this does not work, because the classloader does not see jars inside jars. You have to place the jar file containing the _package_ oracle.jdbc.driver in WEB-INF/lib, not a jar containing that jar. HTH Phil - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problems finding my JDBC driver for Oracle
Sorry, i screwed up...
it does seem to be working
So what does that mean?
Filip Hanik wrote:
can you do this inside of a JSP
%
try {
this.getClass().getClassLoader().loadClass(oracle.jdbc.driver.OracleDriver
);
}catch ( Exception x ) {
x.printStackTrace();
}
%
without an exception being thrown?
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:28 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
It is a .jar file and I can fully unzip it, and the contents contain the
directory
oracle/jdbc/driver/OracleDriver
So i don't think its that.
Filip Hanik wrote:
make sure your jar file ends with .jar and also, make sure it is
not corrupt
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:18 PM
To: [EMAIL PROTECTED]
Subject: Problems finding my JDBC driver for Oracle
Hi,
Im having a great deal of trouble getting tomcat to see my OracleDriver
for the JDBC class. I have tried putting it the file classes.jar in
both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my
WEB-INF/lib directory in my docroot, and nothing seems to work. It
seems to pick up the MySQL drivers just fine, but when I stick in the
Oracle Driver is comes up with:
Caught in processRequest
java.lang.RuntimeException: java.lang.ClassNotFoundException:
oracle/jdbc/driver/OracleDriver.
Can anybody help?
Thanks alot
Dor
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
testing.jsp
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
Re: Problems finding my JDBC driver for Oracle
No no, I got the driver classes12.jar from the net. I was just saying that it can be full unzipped without any problems, to prove the integrity of the file. Other then that, nothing else has been done to the file. Cheers Dor Philipp Taprogge wrote: Hi! Dor Orgad wrote: Im having a great deal of trouble getting tomcat to see my OracleDriver for the JDBC class. I have tried putting it the file classes.jar in both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my WEB-INF/lib directory in my docroot, and nothing seems to work. It seems to pick up the MySQL drivers just fine, but when I stick in the Oracle Driver is comes up with: Caught in processRequest java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle/jdbc/driver/OracleDriver. From what you are writing, I get the impression that you packed the jdbc driver jar _into_ another jar called classes.jar and placed this second jar in your WEB-INF/lib directory. If this is indeed the case, that's your problem. A setup like this does not work, because the classloader does not see jars inside jars. You have to place the jar file containing the _package_ oracle.jdbc.driver in WEB-INF/lib, not a jar containing that jar. HTH Phil - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Dor Orgad Support Center SolNet Solutions Ltd Ph: +64 4 462 5129 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Problems finding my JDBC driver for Oracle
that means that it works just fine. and that YOU are doing something wrong,
not tomcat :)
so try this
%
try {
java.sql.Driver driver = new oracle.jdbc.driver.OraceDriver();
String url = jdbc:oracle:thin:@localhost:1521:ora; //of course substitute
your own values
java.sql.Connection con = driver.getConnection(url,scott,tiger);
java.sql.Statement stmt = con.createStatement();
java.sql.ResultSet rs = stmt.executeQuery(select 1 from dual);
while ( rs.next() ) {
System.out.println(Received database result=+rs.getObject(1));
}
rs.close();
stmt.close();
con.close();
}catch ( Exception x ) { x.printStackTrace(); }
%
if that works, then Oracle and Tomcat works great together, post your code,
and I can tell you what is wrong
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 6:51 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
Sorry, i screwed up...
it does seem to be working
So what does that mean?
Filip Hanik wrote:
can you do this inside of a JSP
%
try {
this.getClass().getClassLoader().loadClass(oracle.jdbc.driver.Orac
leDriver
);
}catch ( Exception x ) {
x.printStackTrace();
}
%
without an exception being thrown?
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:28 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
It is a .jar file and I can fully unzip it, and the contents contain the
directory
oracle/jdbc/driver/OracleDriver
So i don't think its that.
Filip Hanik wrote:
make sure your jar file ends with .jar and also, make sure it is
not corrupt
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:18 PM
To: [EMAIL PROTECTED]
Subject: Problems finding my JDBC driver for Oracle
Hi,
Im having a great deal of trouble getting tomcat to see my OracleDriver
for the JDBC class. I have tried putting it the file classes.jar in
both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my
WEB-INF/lib directory in my docroot, and nothing seems to work. It
seems to pick up the MySQL drivers just fine, but when I stick in the
Oracle Driver is comes up with:
Caught in processRequest
java.lang.RuntimeException: java.lang.ClassNotFoundException:
oracle/jdbc/driver/OracleDriver.
Can anybody help?
Thanks alot
Dor
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
testing.jsp
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problems finding my JDBC driver for Oracle
));
}
rs.close();
stmt.close();
con.close();
}catch ( Exception x ) { x.printStackTrace(); }
%
if that works, then Oracle and Tomcat works great together, post your code,
and I can tell you what is wrong
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 6:51 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
Sorry, i screwed up...
it does seem to be working
So what does that mean?
Filip Hanik wrote:
can you do this inside of a JSP
%
try {
this.getClass().getClassLoader().loadClass(oracle.jdbc.driver.Orac
leDriver
);
}catch ( Exception x ) {
x.printStackTrace();
}
%
without an exception being thrown?
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:28 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
It is a .jar file and I can fully unzip it, and the contents contain the
directory
oracle/jdbc/driver/OracleDriver
So i don't think its that.
Filip Hanik wrote:
make sure your jar file ends with .jar and also, make sure it is
not corrupt
Filip
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 5:18 PM
To: [EMAIL PROTECTED]
Subject: Problems finding my JDBC driver for Oracle
Hi,
Im having a great deal of trouble getting tomcat to see my OracleDriver
for the JDBC class. I have tried putting it the file classes.jar in
both my tomcat/jakarta-tomcat-4.1.29/common/lib/ directory and my
WEB-INF/lib directory in my docroot, and nothing seems to work. It
seems to pick up the MySQL drivers just fine, but when I stick in the
Oracle Driver is comes up with:
Caught in processRequest
java.lang.RuntimeException: java.lang.ClassNotFoundException:
oracle/jdbc/driver/OracleDriver.
Can anybody help?
Thanks alot
Dor
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
testing.jsp
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Dor Orgad
Support Center
SolNet Solutions Ltd
Ph: +64 4 462 5129
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: Problems finding my JDBC driver for Oracle
did you put the classes12.jar in WEB-INF/lib only, not in common/lib
-Original Message-
From: Dor Orgad [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 7:20 PM
To: Tomcat Users List
Subject: Re: Problems finding my JDBC driver for Oracle
I think this thing is playing funny buggers cos with this new code its
giving me the driver not found exception. a i dont know what to
d!!!
type Exception report
message
description The server encountered an internal error () that prevented
it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 6 in the jsp file: /testing.jsp
Generated servlet error:
[javac] Compiling 1 source file
/export/home/tomcat/jakarta-tomcat-4.1.29/work/Standalone/localhost/
_/testing_jsp.java:48:
cannot resolve symbol
symbol : class OraceDriver
location: package driver
java.sql.Driver driver = new oracle.jdbc.driver.OraceDriver();
^
An error occurred at line: 6 in the jsp file: /testing.jsp
Generated servlet error:
/export/home/tomcat/jakarta-tomcat-4.1.29/work/Standalone/localhost/
_/testing_jsp.java:50:
cannot resolve symbol
symbol : method getConnection
(java.lang.String,java.lang.String,java.lang.String)
location: interface java.sql.Driver
java.sql.Connection con = driver.getConnection(url,ontrack,iamontrack);
^
2 errors
at
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErr
orHandler.java:130)
at
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatche
r.java: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(JspCompilationContex
t.java:473)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrappe
r.java: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(App
licationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
FilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
Valve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveConte
xt.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContext
Valve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveConte
xt.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveConte
xt.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatch
erValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveConte
xt.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveConte
xt.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
lve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveConte
xt.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
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:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proc
essConnection(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thread
Pool.java:666)
at java.lang.Thread.run(Thread.java:536)
Filip Hanik wrote:
that means that it works just fine. and that YOU are doing something wrong,
not tomcat :)
so try this
%
try {
java.sql.Driver driver = new oracle.jdbc.driver.OraceDriver();
String url = jdbc:oracle:thin:@localhost:1521:ora; //of course substitute
your own values
Re: Problems finding my JDBC driver for Oracle
Dor Orgad wrote: I think this thing is playing funny buggers cos with this new code its giving me the driver not found exception. a i dont know what to d!!! type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 6 in the jsp file: /testing.jsp Generated servlet error: [javac] Compiling 1 source file /export/home/tomcat/jakarta-tomcat-4.1.29/work/Standalone/localhost/_/testing_jsp.java:48: cannot resolve symbol symbol : class OraceDriver location: package driver java.sql.Driver driver = new oracle.jdbc.driver.OraceDriver(); ^ This would indicate that Oracle's classes are not loaded up. At least not for this run :-) An error occurred at line: 6 in the jsp file: /testing.jsp Generated servlet error: /export/home/tomcat/jakarta-tomcat-4.1.29/work/Standalone/localhost/_/testing_jsp.java:50: cannot resolve symbol symbol : method getConnection (java.lang.String,java.lang.String,java.lang.String) location: interface java.sql.Driver java.sql.Connection con = driver.getConnection(url,ontrack,iamontrack); Now, this is bad. Looks like the java.sql.* package didn't load properly, either. Are you sure you haven't shot your classloader full of holes? Nix. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
