Hi Experts,
I have created a data source in Advance Data Services (Composite Studio 6.1.0) connecting to Oracle 12G database. I can successfully test the connection but when I try to fetch data it gives me below error. Could you please advice what I am missing?
Caused by: java.lang.NoClassDefFoundError: Could not initialize class com.compositesw.cdms.ds.oracle.OracleConnection
Complete Error:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
com.compositesw.cdms.webapi.WebapiException: An internal error has occurred.
Cause: Could not initialize class com.compositesw.cdms.ds.oracle.OracleConnection
Could not initialize class com.compositesw.cdms.ds.oracle.OracleConnection
at com.compositesw.common.CompositeRuntimeException.rethrow(CompositeRuntimeException.java:137)
at com.compositesw.server.qe.physical.operator.SqlScan.initialize(SourceFile:171)
at com.compositesw.server.qe.topology.SelectPTree.initialize(SourceFile:192)
at com.compositesw.server.qe.QueryEngine.initializePlan(SourceFile:796)
at com.compositesw.server.qe.QueryEngine.a(SourceFile:591)
at com.compositesw.server.qe.QueryEngine.a(SourceFile:169)
at com.compositesw.server.qe.QueryEngine.execute(SourceFile:93)
at com.compositesw.server.qe.QESqlRequest.execute(SourceFile:144)
at com.compositesw.server.request.HookSqlRequest.execute(HookSqlRequest.java:62)
at com.compositesw.cdms.webapi.service.WSessionImpl.executeQuery(WSessionImpl.java:72)
at com.compositesw.cdms.webapi.service.WMetaDataImpl.session_executeQuery(WMetaDataImpl.java:1104)
at com.compositesw.cdms.webapi.service.WMetaDataSvc_Tie.invoke_session_executeQuery(WMetaDataSvc_Tie.java:7426)
at com.compositesw.cdms.webapi.service.WMetaDataSvc_Tie.processingHook(WMetaDataSvc_Tie.java:16600)
at com.sun.xml.rpc.server.StreamingHandler.handle(StreamingHandler.java:350)
at com.sun.xml.rpc.server.http.JAXRPCServletDelegate.doPost(JAXRPCServletDelegate.java:465)
at com.sun.xml.rpc.server.http.JAXRPCServlet.doPost(JAXRPCServlet.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
at com.compositesw.server.soa.deployment.WebApiHelper.doFilter(WebApiHelper.java:30)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class com.compositesw.cdms.ds.oracle.OracleConnection
at com.compositesw.cdms.ds.oracle.OracleDataSource.createIafConnection(OracleDataSource.java:131)
at com.compositesw.cdms.datasource.AbstractDataSource.getDataSourceConnection(AbstractDataSource.java:787)
at com.compositesw.server.qe.physical.operator.SqlScan.e(SourceFile:567)
at com.compositesw.server.qe.physical.operator.SqlScan.d(SourceFile:535)
at com.compositesw.server.qe.physical.operator.SqlScan.initialize(SourceFile:154)
... 36 more
at com.compositesw.cdms.webapi.service.WMetaDataSvc_session_executeQuery_Fault_SOAPSerializer.deserializeDetail(WMetaDataSvc_session_executeQuery_Fault_SOAPSerializer.java:48)
at com.sun.xml.rpc.encoding.SOAPFaultInfoSerializer.doDeserialize(SOAPFaultInfoSerializer.java:151)
at com.sun.xml.rpc.encoding.ObjectSerializerBase.deserialize(ObjectSerializerBase.java:209)
at com.sun.xml.rpc.encoding.ReferenceableSerializerImpl.deserialize(ReferenceableSerializerImpl.java:172)
at com.compositesw.cdms.webapi.service.WMetaDataSvc_Stub._readBodyFaultElement(WMetaDataSvc_Stub.java:20895)
at com.sun.xml.rpc.client.StreamingSender._send(StreamingSender.java:238)
at com.compositesw.cdms.webapi.service.WMetaDataSvc_Stub.session_executeQuery(WMetaDataSvc_Stub.java:11080)
at com.compositesw.cdms.webapi.WSession.executeQuery(WSession.java:67)
at com.compositesw.ui.modeler.view.result.TabularProgressTasks$TabularExecuteQueryTask.executeQuery(TabularProgressTasks.java:173)
at com.compositesw.ui.modeler.view.result.TabularProgressTasks$TabularExecuteQueryTask.goWork(TabularProgressTasks.java:93)
at com.compositesw.ui.modeler.view.result.LongTask$1.construct(LongTask.java:60)
at com.compositesw.ui.modeler.utility.SwingWorker$2.run(SwingWorker.java:113)
at java.lang.Thread.run(Thread.java:662)
Version Information: Studio 6.1.0.01.09, Build ID 120417-160334-0700-47617M, Server 6.1.0.01.09
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Regards,
Sumit
