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. 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(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 >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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
