Topic
  • 1 reply
  • Latest Post - ‏2011-09-14T20:41:46Z by SystemAdmin
Dhanaveerala
Dhanaveerala
1 Post

Pinned topic ibm websphre application server db2 connection error

‏2011-08-26T16:20:12Z |
Hi

i am trying to connect DB2 in ibm websphere application server i am getting error while testing connection,
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at java.lang.Class.forName0(Native Method)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at java.lang.Class.forName(Class.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.loadDataSourceClass(DSConfigurationHelper.java:1347)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper$7.run(DSConfigurationHelper.java:2048)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2046)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:528)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:456)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1366)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:1012)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:233)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:86)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:167)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:217)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.console.resources.jdbc.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:273)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1217)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
7/14/11 9:18:28:625 PDT 00000033 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
7/14/11 9:18:28:688 PDT 00000033 SystemErr R java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2XADataSource
at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java(Compiled Code))
at com.ibm.ws.rsadapter.DSConfigurationHelper.loadDataSourceClass(DSConfigurationHelper.java:1347)
at com.ibm.ws.rsadapter.DSConfigurationHelper$7.run(DSConfigurationHelper.java:2048)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2046)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:528)
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:456)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1366)
at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:1012)
at mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:233)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:86)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:167)

this is the log file copy....
Updated on 2011-09-14T20:41:46Z at 2011-09-14T20:41:46Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    6 Posts

    Re: ibm websphre application server db2 connection error

    ‏2011-09-14T20:41:46Z  
    Hello,

    The first thing to check is the classpath specified in the JDBCProvider definition. Is the classpath to the db2jcc4.jar or db2jcc.jar hard-coded, or are you using WebSphere environment variables? If a variable, such as DB2_JCC_DRIVER_PATH is used, check that the variable is correctly defined at the scope where the JDBCProvider/DataSource is defined. See the section, "Verifying your scope settings" at
    http://publib.boulder.ibm.com/infocenter/wasinfo/v8r0/topic/com.ibm.websphere.nd.doc/info/ae/ae/cdat_testcon.html

    Regards,
    Paul Johnsen