geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yves Caloz" <Yves.Ca...@trivadis.com>
Subject JDBC Connection POOL for Oracle Failed
Date Mon, 04 Apr 2005 14:05:06 GMT
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
Mime
View raw message