Problem Creating Connection Pool to Oracle 10
[289 byte] By [lakabo] at [2007-11-26 8:04:30] 
I am trying to create a Connection pool to an Oracle web server but it keeps giving me this error. DO i have to add the oracle jdbc Jar file to the serverOperation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: oracle.jdbc.OracleDriver
# 1
The server.log file will have the complete Exception with the exact reason why the ping is failing. If you have not added the ojdbc14.jar file to the lib (<domain_dir>/lib and <instance_dir>/lib) directory, then you need to do that and restart the server.hope that helpspts_forum at 2007-7-6 20:39:45 >
# 2
I am getting this error from the server.log
java.lang.ClassCastException: oracle.jdbc.OracleDriver
at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedCon nectionFactory.java:83)
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpool edConnection(ConnectorConnectionPoolAdminServiceImpl.java:1200)
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConne ctionPool(ConnectorConnectionPoolAdminServiceImpl.java:543)
at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRunt ime.java:502)
at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBea n.java:2218)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:353 )
at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:336 )
at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:448 )
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213 )
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServer Interceptor.java:815)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:77)
at $Proxy1.invoke(Unknown Source)
at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterce ptor.java:297)
at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:162)
at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:60)
at com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean(CommonHan dlers.java:149)
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.invokeHandler(D escriptorViewHelper.java:938)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.invokeHandlers( DescriptorViewHelper.java:875)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.dispatchEvent(D escriptorViewHelper.java:841)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.execute(Descrip torViewHelper.java:313)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewBeanBase.execute(Descr iptorViewBeanBase.java:210)
at com.iplanet.jato.view.RequestHandlingViewBase.handleRequest(RequestHandlingView Base.java:308)
at com.iplanet.jato.view.ViewBeanBase.dispatchInvocation(ViewBeanBase.java:802)
at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.ja va:740)
at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.ja va:760)
at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandler(ViewBeanBase.java:571)
at com.iplanet.jato.ApplicationServletBase.dispatchRequest(ApplicationServletBase. java:957)
at com.iplanet.jato.ApplicationServletBase.processRequest(ApplicationServletBase.j ava:615)
at com.sun.enterprise.tools.guiframework.view.BaseServlet.processRequest(BaseServl et.java:204)
at com.iplanet.jato.ApplicationServletBase.doPost(ApplicationServletBase.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilte rChain.java:397)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 278)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 179)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java: 120)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 7)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:231)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorT ask.java:667)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(Proces sorTask.java:574)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:844)
at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:287)
at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
|#]
lakabo at 2007-7-6 20:39:45 >
# 3
1) Can you post the connection pool configuration.
2)From the stack trace it seems that, data-source class name specified is incorrect.
"java.lang.ClassCastException: oracle.jdbc.OracleDriver"
It has to be something like
"oracle.jdbc.pool.OracleDataSource"
3)Please refer the following URL for conn.pool configuration against different database/ drivers.
http://docs.sun.com/app/docs/doc/819-2556/6n4rap8sl?a=view
For Oracle type 4 thin driver :
http://docs.sun.com/app/docs/doc/819-2556/6n4rap8sl?a=view#beanh
Thanks,
-Jagadish
JagadishPrasath at 2007-7-6 20:39:45 >
Application & Integration Servers New Topic
- org.apache.jasper.JasperException: useBean: Duplicate Bean
- Deploy a Project from NetBeans IDE to Sun One Server
- can Application Server call EJB apart from an application?
- Does GlassFish have the enterprise features ?
- Question about implementation of Broker Clustering in SJSMQ
- JMX APIs
- The server encountered an internal error () that prevented it from fulfilli
- Servlet using Xvfb needs DISPLAY set
Application & Integration Servers Hot Topic
- Sun Application Server 8.2
- IMQ broker running but I get 'Broker: unavailable' (2312)
- Apache 2 + Sun Java 8.1 load balancer connector dies under load
- 4.0 Enterprise Edition
- Unistallation of Sun Java System Application Server Platform Edition 8.1,9
- connection pool for ms sql
- Java beans with JSP
- Application server 8.1 going down frequently
Application & Integration Servers
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding