Re: Problems finding my JDBC driver for Oracle

[Dor Orgad]

I think this thing is playing funny buggers cos with this new code its 
giving me the driver not found exception.  ahhhh i dont know what to 
doooo!!!

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(DefaultErrorHandler.java:130)
at 
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.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(JspCompilationContext.java:473)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.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(ApplicationFilterChain.java:247)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.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(StandardContextValve.java:191)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.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$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.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(StandardEngineValve.java:174)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.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.processConnection(Http11Protocol.java:549)
at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.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
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]
 



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