You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Yves Caloz <Yv...@trivadis.com> on 2005/04/04 16:05:06 UTC
JDBC Connection POOL for Oracle Failed
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(ConnectorMethodInterceptor.java:54)
at $javax.sql.DataSource$$EnhancerByCGLIB$$1dafb277.getConnection(<generated>)
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.java: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(WebApplicationHandler.java:711)
at org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:169)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:702)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.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(WebApplicationContext.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(JDBCDriverMCF.java:75)
at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41)
at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:59)
at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:70)
at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:47)
at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:82)
at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)
at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(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.java:49)
at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.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
Re: JDBC Connection POOL for Oracle Failed
Posted by David Jencks <dj...@gluecode.com>.
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