Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 66340 invoked from network); 22 Apr 2003 21:49:12 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 22 Apr 2003 21:49:12 -0000 Received: (qmail 2455 invoked by uid 97); 22 Apr 2003 21:51:14 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org Received: (qmail 2448 invoked from network); 22 Apr 2003 21:51:14 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 22 Apr 2003 21:51:14 -0000 Received: (qmail 61288 invoked by uid 500); 22 Apr 2003 21:48:18 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 61169 invoked from network); 22 Apr 2003 21:48:17 -0000 Received: from unknown (HELO mail.cdi-hq.com) (207.104.45.33) by daedalus.apache.org with SMTP; 22 Apr 2003 21:48:17 -0000 Received: from PIP (192-168-11-104.cdi-hq.com [192.168.11.104]) by mail.cdi-hq.com (8.10.1/8.10.1) with ESMTP id h3MLmGx04482; Tue, 22 Apr 2003 14:48:17 -0700 (PDT) From: "mike jackson" To: "'Tomcat Users List'" , "'Frederico Madeira'" Subject: RE: Connect whit Oracle Db Date: Tue, 22 Apr 2003 14:48:02 -0700 Message-ID: <003e01c30918$de6d5c80$680ba8c0@north.cdihq.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: <028601c30918$9204f790$c83c3c0a@info> Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Did you remember to load the driver?=20 It'd be a Class.forName call... --mikej -=3D------ mike jackson mjackson@cdi-hq.com > -----Original Message----- > From: Frederico Madeira [mailto:fred@farmaciadospobres.com.br] > Sent: Tuesday, April 22, 2003 1:46 PM > To: tomcat-user@jakarta.apache.org > Subject: Connect whit Oracle Db >=20 > Sr=B4s, >=20 > I want to connect my servlet application with oracle db. > I copy the drivers JDBC to lib folders. > When i run my application, the follow error apperars: >=20 >=20 > org.apache.jasper.JasperException: oracle.jdbc.driver.OracleDriver > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va > :254) > 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(Applica ti > onFilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt er > Chain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e. > java:256) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e. > java:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241 5) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :1 > 80) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lv > e.java:171) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :1 > 72) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. ja > va:174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:59 4) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC on > nection(Http11Protocol.java:392) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56 5) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .j > ava:619) > at java.lang.Thread.run(Thread.java:536) >=20 > root cause >=20 > javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver > at > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContex tI > mpl.java:536) > at org.apache.jsp.Visitantes_jsp._jspService(Visitantes_jsp.java:218) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va > :210) > 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(Applica ti > onFilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt er > Chain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e. > java:256) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e. > java:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241 5) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :1 > 80) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lv > e.java:171) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :1 > 72) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. ja > va:174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nv > okeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:59 4) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC on > nection(Http11Protocol.java:392) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56 5) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .j > ava:619) > at java.lang.Thread.run(Thread.java:536) > My conection with oracle is: > <% > String nome, senha, cURL ; > cURL =3D "jdbc:oracle:oci8:hostdb:1521"; > nome=3D "username"; > senha=3D "passwd"; > Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); > Connection con =3D DriverManager.getConnection(cURL, nome, senha); > Statement stm =3D con.createStatement(); > %> >=20 > tanks >=20 > Frederico Madeira > Coordenador de Suporte > N. Landim Com=E9rcio Ltda > PABX: 81. 3497.3029 > e-mail: fred@farmaciadospobres.com.br --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org