From user-return-292-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org Mon Apr 04 14:39:16 2005 Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 63658 invoked from network); 4 Apr 2005 14:39:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Apr 2005 14:39:16 -0000 Received: (qmail 55473 invoked by uid 500); 4 Apr 2005 14:39:15 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 55452 invoked by uid 500); 4 Apr 2005 14:39:15 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 55439 invoked by uid 99); 4 Apr 2005 14:39:15 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from Unknown (HELO mgd.gluecode.com) (64.14.202.141) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 04 Apr 2005 07:39:13 -0700 Received: from [192.168.1.5] (dsl093-038-137.pdx1.dsl.speakeasy.net [66.93.38.137]) (authenticated bits=0) by mgd.gluecode.com (8.12.10/8.12.10) with ESMTP id j34Ed9CW021383 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=NO) for ; Mon, 4 Apr 2005 07:39:10 -0700 Mime-Version: 1.0 (Apple Message framework v619.2) In-Reply-To: <2CF83791A616BB4DA203FFD13007824A02069EAB@MSXVS02.trivadis.com> References: <2CF83791A616BB4DA203FFD13007824A02069EAB@MSXVS02.trivadis.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: David Jencks Subject: Re: JDBC Connection POOL for Oracle Failed Date: Mon, 4 Apr 2005 07:39:09 -0700 To: user@geronimo.apache.org X-Mailer: Apple Mail (2.619.2) X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I believe this problem has been fixed in svn. Alternatively you can move the dependency to the web-app or package both the web app and the connector in an ear. If you move the dependency, remember what you did because it will stop working when you upgrade to a more current version. Hope this helps, thanks david jencks On Apr 4, 2005, at 7:05 AM, Yves Caloz wrote: > I have Problems with Oracle Connection POOL. I have deployed an Oracle > Connection Pool without errors. Now I want to used this connection > with an application and I have following error : > > java.sql.SQLException > at > org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:62) > at > $javax.sql.DataSource$$FastClassByCGLIB$$6525cafd.invoke() > at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:183) > at > org.apache.geronimo.connector.ConnectorMethodInterceptor.intercept(Conn > ectorMethodInterceptor.java:54) > at > $javax.sql.DataSource$$EnhancerByCGLIB$$1dafb277.getConnection( ed>) > at org.apache.jsp.dbtest_jsp._jspService(dbtest_jsp.java:83) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.j > ava:324) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > 292) > at > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:413) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(We > bApplicationHandler.java:711) > at > org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:169) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(We > bApplicationHandler.java:702) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplication > Handler.java:527) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: > 567) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationCo > ntext.java:624) > at > org.apache.geronimo.jetty.JettyWebAppContext.handle(JettyWebAppContext. > java:162) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1434) > at org.mortbay.http.HttpServer.service(HttpServer.java:896) > at > org.mortbay.http.HttpConnection.service(HttpConnection.java:814) > at > org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) > at > org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) > at > org.mortbay.http.SocketListener.handleConnection(SocketListener.java: > 244) > at > org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366) > at > org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) > Caused by: Unable to load driver class: > oracle.jdbc.driver.OracleDriver > at > org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDri > verMCF.java:75) > at > org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConn > ection(MCFConnectionInterceptor.java:41) > at > org.apache.geronimo.connector.outbound.LocalXAResourceInsertionIntercep > tor.getConnection(LocalXAResourceInsertionInterceptor.java:41) > at > org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor. > internalGetConnection(SinglePoolConnectionInterceptor.java:59) > at > org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInte > rceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:70) > at > org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor. > getConnection(TransactionEnlistingInterceptor.java:47) > at > org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.ge > tConnection(TransactionCachingInterceptor.java:82) > at > org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getC > onnection(ConnectionHandleInterceptor.java:43) > at > org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.ge > tConnection(ConnectionTrackingInterceptor.java:66) > at > org.apache.geronimo.connector.outbound.AbstractConnectionManager.alloca > teConnection(AbstractConnectionManager.java:56) > at > org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:57) > ... 28 more > Caused by: java.lang.ClassNotFoundException: > oracle.jdbc.driver.OracleDriver > at java.net.URLClassLoader$1.run(URLClassLoader.java:198) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:186) > at java.lang.ClassLoader.loadClass(ClassLoader.java:299) > at java.lang.ClassLoader.loadClass(ClassLoader.java:255) > at > org.apache.geronimo.jetty.JettyClassLoader.loadClass(JettyClassLoader.j > ava:49) > at > org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDri > verMCF.java:69) > > I have installed ojdbc14.jar in \repository\oracle\jars and the > deployment Plan for Connection Pool is : > > > xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector > " > version="1.5" > configId="OraclePool" > parentId="org/apache/geronimo/Server"> > > oracle/jars/ojdbc14.jar > > > > > > javax.sql.DataSource interface> > > OracleDataSource > name="UserName">scott > name="Password">tiger > name="Driver">oracle.jdbc.driver.OracleDriver setting> > name="ConnectionURL">jdbc:oracle:thin:@ltyvc:1521:DB1 property-setting> > > > 10 > 2 > > > > jdbc/OraclePool > > > > > > > > Thank you > Yves