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/05 07:43:39 UTC
RE : [SPAM] - Re: JDBC Connection POOL for Oracle Failed - Bayesian Filter detected spam
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
Re: RE : [SPAM] - Re: JDBC Connection POOL for Oracle Failed - Bayesian Filter detected spam
Posted by David Jencks <dj...@gluecode.com>.
On Apr 4, 2005, at 10:43 PM, Yves Caloz wrote:
> 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.
There's a more adapted-to-oracle connector in the tranql project under
vendors/oracle, but again you will have to build it yourself. Also I
don't believe it has been used much recently and I'm not certain it is
up to date with the rest of the tranql connector work.
I haven't used oracle for nearly a year, so I don't personally have an
example. Your configuration looks fine to me, if you move
> <dependency>
> <uri>oracle/jars/ojdbc14.jar</uri>
> </dependency>
to the web-app plan. What happens when you make this change and try to
deploy again?
thanks
david jencks
>
> 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
>
>
>
> <winmail.dat>