2 Replies Latest reply: May 8, 2012 3:52 AM by 901163 RSS

    Problem with web service, throwing errors.

    901163
      Hi all,

      Need help on this.

      I have deployed webservice on oc4j, and while testing it is throwing NoClassDefFound exception in oracle/jdbc/pool/OracleDataSource.class. I have java 1.6 and oracle 11g, so i included ojdbc6.jar in the classpath and also start up script of oc4j. This webservice is for fetching data for report.

      Please, help if you all have any idea on this....

      [050812_100816808][][STATEMENT] Setting data definition:BRM_Corporate_Invoice_Report type:oracle.apps.xdo.servlet.data.bind.WebServiceBoundValue11
      [050812_100816808][][STATEMENT] Setting data definition:Inv_POID type:oracle.apps.xdo.servlet.data.bind.ReportParameterBoundValue
      [050812_100816809][][STATEMENT] Skip migration for cookie (ORA_XDO) is not found
      [050812_100821057][][STATEMENT] Skip migration for cookie (ORA_XDO) is not found
      [050812_100821063][][STATEMENT] temp file is created: /usr/local/OracleBI/oc4j_bi/j2ee/home/applications/xmlpserver/xmlpserver/xdo/tmp/xmlp4145013901549814632tmp
      [050812_100821063][][STATEMENT] WebServiceBoundValue11::getValue userID = null
      [050812_100821064][][STATEMENT] username = approx
      [050812_100821064][][STATEMENT] WebServiceBoundValue11::getValue m_xpath = null
      [050812_100821082][][STATEMENT] Webservice time out: 60000
      [050812_100821088][][EXCEPTION] AxisFault
      faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
      faultSubcode:
      faultString: Caught exception while handling request: Caught exception while handling request: java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
      faultActor:
      faultNode:
      faultDetail:
      {http://xml.apache.org/axis/}stackTrace:Caught exception while handling request: Caught exception while handling request: java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
      at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
      at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
      at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
      at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1345)
      at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:362)
      at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:308)
      at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:213)
      at oracle.xml.jaxp.JXSAXParser.parse(JXSAXParser.java:292)
      at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
      at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
      at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
      at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
      at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
      at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
      at org.apache.axis.client.Call.invoke(Call.java:2767)
      at org.apache.axis.client.Call.invoke(Call.java:2443)
      at org.apache.axis.client.Call.invoke(Call.java:2366)
      at org.apache.axis.client.Call.invoke(Call.java:1812)
      at oracle.apps.xdo.servlet.webservices.DynamicClient.invokeMethod(DynamicClient.java:179)
      at oracle.apps.xdo.servlet.data.server.WebServiceCall.doFetch(WebServiceCall.java:75)
      at oracle.apps.xdo.servlet.data.server.AbstractDataCall.execute(AbstractDataCall.java:63)
      at oracle.apps.xdo.servlet.data.bind.WebServiceBoundValue11.getValue(WebServiceBoundValue11.java:163)
      at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(ReportContextImplV11.java:412)
      at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:211)
      at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:81)
      at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:572)
      at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:270)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:266)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:246)
      at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:174)
      at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java:197)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
      at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:619)

      {http://xml.apache.org/axis/}hostname:MelITBRM

      Caught exception while handling request: Caught exception while handling request: java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
      at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
      at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
      at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
      at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1345)
      at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:362)
      at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:308)
      at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:213)
      at oracle.xml.jaxp.JXSAXParser.parse(JXSAXParser.java:292)
      at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
      at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
      at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
      at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
      at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
      at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
      at org.apache.axis.client.Call.invoke(Call.java:2767)
      at org.apache.axis.client.Call.invoke(Call.java:2443)
      at org.apache.axis.client.Call.invoke(Call.java:2366)
      at org.apache.axis.client.Call.invoke(Call.java:1812)
      at oracle.apps.xdo.servlet.webservices.DynamicClient.invokeMethod(DynamicClient.java:179)
      at oracle.apps.xdo.servlet.data.server.WebServiceCall.doFetch(WebServiceCall.java:75)
      at oracle.apps.xdo.servlet.data.server.AbstractDataCall.execute(AbstractDataCall.java:63)
      at oracle.apps.xdo.servlet.data.bind.WebServiceBoundValue11.getValue(WebServiceBoundValue11.java:163)
      at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(ReportContextImplV11.java:412)
      at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:211)
      at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:81)
      at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:572)
      at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:270)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:266)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:246)
      at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:174)
      at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java:197)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
      at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:619)

      [050812_100821088][][EXCEPTION] AxisFault
      faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server
      faultSubcode:
      faultString: Caught exception while handling request: Caught exception while handling request: java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
      faultActor:
      faultNode:
      faultDetail:
      {http://xml.apache.org/axis/}stackTrace:Caught exception while handling request: Caught exception while handling request: java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
      at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
      at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
      at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
      at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1345)
      at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:362)
      at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:308)
      at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:213)
      at oracle.xml.jaxp.JXSAXParser.parse(JXSAXParser.java:292)
      at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
      at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
      at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
      at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
      at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
      at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
      at org.apache.axis.client.Call.invoke(Call.java:2767)
      at org.apache.axis.client.Call.invoke(Call.java:2443)
      at org.apache.axis.client.Call.invoke(Call.java:2366)
      at org.apache.axis.client.Call.invoke(Call.java:1812)
      at oracle.apps.xdo.servlet.webservices.DynamicClient.invokeMethod(DynamicClient.java:179)
      at oracle.apps.xdo.servlet.data.server.WebServiceCall.doFetch(WebServiceCall.java:75)
      at oracle.apps.xdo.servlet.data.server.AbstractDataCall.execute(AbstractDataCall.java:63)
      at oracle.apps.xdo.servlet.data.bind.WebServiceBoundValue11.getValue(WebServiceBoundValue11.java:163)
      at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(ReportContextImplV11.java:412)
      at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:211)
      at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:81)
      at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:572)
      at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:270)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:266)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:246)
      at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:174)
      at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java:197)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
      at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:619)
      {http://xml.apache.org/axis/}hostname:MelITBRM

      Caught exception while handling request: Caught exception while handling request: java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
      at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
      at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
      at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
      at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1345)
      at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:362)
      at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:308)
      at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:213)
      at oracle.xml.jaxp.JXSAXParser.parse(JXSAXParser.java:292)
      at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
      at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
      at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
      at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
      at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
      at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
      at org.apache.axis.client.Call.invoke(Call.java:2767)
      at org.apache.axis.client.Call.invoke(Call.java:2443)
      at org.apache.axis.client.Call.invoke(Call.java:2366)
      at org.apache.axis.client.Call.invoke(Call.java:1812)
      at oracle.apps.xdo.servlet.webservices.DynamicClient.invokeMethod(DynamicClient.java:179)
      at oracle.apps.xdo.servlet.data.server.WebServiceCall.doFetch(WebServiceCall.java:75)
      at oracle.apps.xdo.servlet.data.server.AbstractDataCall.execute(AbstractDataCall.java:63)
      at oracle.apps.xdo.servlet.data.bind.WebServiceBoundValue11.getValue(WebServiceBoundValue11.java:163)
      at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(ReportContextImplV11.java:412)
      at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:211)
      at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:81)
      at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:572)
      at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:270)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:266)
      at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:246)
      at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:174)
      at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java:197)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
      at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:619)


      Any Clue as to what gone missing.

      Regards,
      Anirban.