I am working with SOA8 and want to use the connection pool. So I made an example database application where I have
1. a direct jdbc connection to our AS400 database
2. a connection pool jdbc
The direct jdbc works ok, but the connection pool does not. I tried every tip issued in previous threads putting the jar files in the classpath in the lib and ext directories.
A.domain.xml
------------
<resources>
<jdbc-connection-pool
connection-validation-method="auto-commit"
datasource-classname="com.ibm.as400.access.AS400JDBCDriver"
fail-all-connections="false"
idle-timeout-in-seconds="300"
is-connection-validation-required="false"
is-isolation-level-guaranteed="false"
max-pool-size="32"
max-wait-time-in-millis="60000"
name="AS400Pool"
pool-resize-quantity="2"
res-type="javax.sql.DataSource"
steady-pool-size="8">
<property name="user" value="CNXPROD"/>
<property name="password" value="HYT04QT10"/>
<property name="databaseName" value="jdbc:as400://172.16.0.200/"/>
</jdbc-connection-pool>
</resources>
B. ERRORS (After 3. server.log. I also have a 500 page error #4)
----------------------------------------------------------------
1. Error from Administration Console executing Ping
-------------------------------------
An error has occurred. Operation 'pingConnectionPool' failed in 'resources' Config Mbean."
2. Error Application show this error when trying the connection pool
-----------------------------------------------------------
Exception: No object bound to name java:comp/env/jdbc/as400
3. server.log
-------------
[#|2004-04-14T11:36:38.005-0600|INFO|sun-appserver-pe8.0|javax.enterprise.system.tools.admin|_ThreadID=14;|
com.sun.enterprise.tools.guiframework.exception.FrameworkError: com.sun.enterprise.tools.guiframework.exception.FrameworkException: java.lang.reflect.InvocationTargetException on 'class com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean'. This occurred while attempting to process a 'command' event for 'pingButton'.
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.execute(DescriptorViewHelper.java:279)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewBeanBase.execute(DescriptorViewBeanBase.java:187)
at com.iplanet.jato.view.RequestHandlingViewBase.handleRequest(RequestHandlingViewBase.java:308)
at com.iplanet.jato.view.ViewBeanBase.dispatchInvocation(ViewBeanBase.java:822)
at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.java:760)
at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.java:780)
at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandler(ViewBeanBase.java:590)
at com.iplanet.jato.ApplicationServletBase.dispatchRequest(ApplicationServletBase.java:951)
at com.iplanet.jato.ApplicationServletBase.processRequest(ApplicationServletBase.java:622)
at com.sun.enterprise.tools.guiframework.view.BaseServlet.processRequest(BaseServlet.java:186)
at com.iplanet.jato.ApplicationServletBase.doPost(ApplicationServletBase.java:480)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:768)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:861)
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:289)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:205)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:102)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:192)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:156)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:569)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:261)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:215)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:156)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:583)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:154)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:569)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:200)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:156)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:180)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:154)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:582)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:154)
at com.sun.enterprise.webservice.EjbWebServiceValve.invoke(EjbWebServiceValve.java:134)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:154)
at com.sun.enterprise.security.web.SingleSignOn.invoke(SingleSignOn.java:305)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:154)
at com.sun.enterprise.web.VirtualServerValve.invoke(VirtualServerValve.java:209)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:154)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:569)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:161)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:156)
at com.sun.enterprise.web.VirtualServerMappingValve.invoke(VirtualServerMappingValve.java:166)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:154)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:569)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:979)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:692)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:647)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:691)
at java.lang.Thread.run(Thread.java:534)
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: java.lang.reflect.InvocationTargetException on 'class com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean'. This occurred while attempting to process a 'command' event for 'pingButton'.
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.dispatchEvent(DescriptorViewHelper.java:735)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.execute(DescriptorViewHelper.java:250)
... 59 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.invokeHandler(DescriptorViewHelper.java:785)
at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.dispatchEvent(DescriptorViewHelper.java:731)
... 60 more
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: com.sun.enterprise.tools.guiframework.exception.FrameworkException: com.sun.enterprise.tools.guiframework.exception.FrameworkException: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
at com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean(CommonHandlers.java:91)
... 65 more
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: com.sun.enterprise.tools.guiframework.exception.FrameworkException: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:38)
at com.sun.enterprise.tools.admingui.util.MBeanUtil.invokeMBean(MBeanUtil.java:140)
at com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean(CommonHandlers.java:83)
... 65 more
Caused by: com.sun.enterprise.tools.guiframework.exception.FrameworkException: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:112)
at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:35)
... 67 more
Caused by: javax.management.MBeanException: Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
at com.sun.enterprise.admin.MBeanHelper.extractAndWrapTargetException(MBeanHelper.java:355)
at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:302)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:221)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:228)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:823)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:792)
at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:54)
at $Proxy1.invoke(Unknown Source)
at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:282)
at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:105)
... 68 more
Caused by: javax.resource.ResourceException
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:605)
at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRuntime.java:520)
at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBean.java:1805)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:287)
at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:280)
... 79 more
Caused by: javax.resource.ResourceException
at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:73)
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:597)
... 87 more
|#]
4.Application 500 Error
-----------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: No object bound to name java:comp/env/jdbc/dinamica
dinamica.Controller.init(Controller.java:383)
javax.servlet.GenericServlet.init(GenericServlet.java:261)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:289)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:205)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:158)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:180)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:582)
com.sun.enterprise.webservice.EjbWebServiceValve.invoke(EjbWebServiceValve.java:134)
com.sun.enterprise.security.web.SingleSignOn.invoke(SingleSignOn.java:254)
com.sun.enterprise.web.VirtualServerValve.invoke(VirtualServerValve.java:209)
com.sun.enterprise.web.VirtualServerMappingValve.invoke(VirtualServerMappingValve.java:166)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:692)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:647)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:691)
java.lang.Thread.run(Thread.java:534)
root cause
javax.naming.NameNotFoundException: No object bound to name java:comp/env/jdbc/dinamica
com.sun.enterprise.naming.NamingManagerImpl.lookup(NamingManagerImpl.java:665)
com.sun.enterprise.naming.java.javaURLContext.lookup(javaURLContext.java:108)
javax.naming.InitialContext.lookup(InitialContext.java:347)
dinamica.Jndi.getDataSource(Jndi.java:45)
dinamica.Controller.init(Controller.java:365)
javax.servlet.GenericServlet.init(GenericServlet.java:261)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:289)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:205)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:158)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:180)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:582)
com.sun.enterprise.webservice.EjbWebServiceValve.invoke(EjbWebServiceValve.java:134)
com.sun.enterprise.security.web.SingleSignOn.invoke(SingleSignOn.java:254)
com.sun.enterprise.web.VirtualServerValve.invoke(VirtualServerValve.java:209)
com.sun.enterprise.web.VirtualServerMappingValve.invoke(VirtualServerMappingValve.java:166)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:692)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:647)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:691)
java.lang.Thread.run(Thread.java:534)
note The full stack trace of the root cause is available in the Sun-Java-System/Application-Server-PE-8.0 logs.
Please help!
Thanks and Blessings.
Lorenzo Jim�nez