geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yves Caloz" <Yves.Ca...@trivadis.com>
Subject RE : [SPAM] - Re: JDBC Connection POOL for Oracle Failed - Bayesian Filter detected spam
Date Tue, 05 Apr 2005 05:43:39 GMT
Hello David,
Thank you for the alternativ. Is it yet the only alternativ ? Did you have or someone an example
with Oracle Connection ? I need only a little example.
 
Thanks.
Yves Caloz

	-------- Message d'origine-------- 
	De: David Jencks [mailto:djencks@gluecode.com] 
	Date: lun. 04.04.2005 16:39 
	À: user@geronimo.apache.org 
	Cc: 
	Objet: [SPAM] - Re: JDBC Connection POOL for Oracle Failed - Bayesian Filter detected spam
	
	

	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(<generated>)
	>         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(<generat
	> 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 :
	>
	> <?xml version="1.0"?>
	> <connector
	>      xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector 
	> <http://geronimo.apache.org/xml/ns/j2ee/connector> "
	>      version="1.5"
	>      configId="OraclePool"
	>      parentId="org/apache/geronimo/Server">
	>   <dependency>
	>     <uri>oracle/jars/ojdbc14.jar</uri>
	>   </dependency>
	>   <resourceadapter>
	>     <outbound-resourceadapter>
	>       <connection-definition>
	>         
	> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-
	> interface>
	>         <connectiondefinition-instance>
	>           <name>OracleDataSource</name>
	>           <config-property-setting 
	> name="UserName">scott</config-property-setting>
	>           <config-property-setting 
	> name="Password">tiger</config-property-setting>
	>           <config-property-setting 
	> name="Driver">oracle.jdbc.driver.OracleDriver</config-property-
	> setting>
	>           <config-property-setting 
	> name="ConnectionURL">jdbc:oracle:thin:@ltyvc:1521:DB1</config-
	> property-setting>
	>           <connectionmanager>
	>             <single-pool>
	>               <max-size>10</max-size>
	>               <min-size>2</min-size>
	>               <match-one/>
	>             </single-pool>
	>           </connectionmanager>
	>           <global-jndi-name>jdbc/OraclePool</global-jndi-name>
	>         </connectiondefinition-instance>
	>       </connection-definition>
	>     </outbound-resourceadapter>
	>   </resourceadapter>
	> </connector>
	>
	>
	> Thank you
	> Yves
	
	

Mime
View raw message