cancel
Showing results for 
Search instead for 
Did you mean: 

Support for XML / Web Service Data Source?

Former Member
0 Kudos

<p>Do you know if and when Crystal Reports for Eclipse will support using the XML / Web Service data source? It appears that only JDBC and Java Result Sets are currently supported. I am using:</p><p>com.businessobjects.integration.eclipse.library_1.0.0.v671 </p><p>com.businessobjects.sdks.jrc.11.8.0_11.8.1.v671 </p><p>Thank you! </p>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

<p>Related is the question of whether or not I can deploy a JSP / webapp that references a RPT with an XML / Web Service data source. Currently, I am getting the following error:</p><p><span class="crExceptionText">Error loading database connector. The class &#39;com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader&#39; could not be accessed.</span> <br /></p>

Former Member
0 Kudos

<p>The driver loader problem&#39;s root cause is as below. CRDB_XMLImpl does not seem to be in any of the JARs shipped with Crystal Reports for Eclipse. </p><p>Caused by: java.lang.NoClassDefFoundError: com/crystaldecisions/data/xml/CRDB_XMLImpl<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.eE(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader.loadDriver(Unknown Source)<br /> ... 28 more <br /></p>

Former Member
0 Kudos

<p>Ok, I copied the JARs (such as CRDBXMLServer.jar) from the JRC SDK (from Eclipse all-in-one) onto the Tomcat classpath and got rid of my previous problem. I now get the stack trace below. I also can not find crdb_*.dll files (such as crdb_xml.dll) anywhere on my system other than the service pack 2 rollback directories. My guess is I should be downloading and installing something else -- is this true? </p><p>10 Jan 2007 13:22:36 [http-8080-Processor23] DEBUG com.crystaldecisions.reports.reportdefinition.datainterface - Failed to open connection (Connection:<databaseType=XML><serverName=http://dopey/devicedirectory/2006-06-25/DeviceDirectory?WSDL DeviceDirectory DeviceDirectoryPort getDevices><state=closed><databaseDriverName=crdb_xml.dll>).<br />com.crystaldecisions.reports.queryengine.am: Error loading database connector. The class &#39;com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader&#39; could not be accessed.<br /> at com.crystaldecisions.reports.queryengine.ax.am(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.ax.new(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.ax.byte(Unknown Source)<br /> at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)<br /> at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)<br /> at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)<br /> at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)<br /> at com.crystaldecisions.reports.reportdefinition.datainterface.g.a(Unknown Source)<br /> at com.businessobjects.reports.sdk.b.b.byte(Unknown Source)<br /> at com.businessobjects.reports.sdk.b.b.a(Unknown Source)<br /> at com.businessobjects.reports.sdk.b.b.byte(Unknown Source)<br /> at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)<br /> at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)<br /> at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.getPage(Unknown Source)<br /> at com.crystaldecisions.report.web.event.ac.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.ac.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.b2.a(Unknown Source)<br /> at com.crystaldecisions.report.web.event.b7.broadcast(Unknown Source)<br /> at com.crystaldecisions.report.web.event.av.a(Unknown Source)<br /> at com.crystaldecisions.report.web.WorkflowController.do(Unknown Source)<br /> at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)<br /> at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)<br /> at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source)<br /> at com.crystaldecisions.report.web.viewer.taglib.ServerControlTag.doEndTag(Unknown Source)<br /> at com.crystaldecisions.report.web.viewer.taglib.ReportServerControlTag.doEndTag(Unknown Source)<br /> at org.apache.jsp.stateReport_002dviewer_jsp._jspx_meth_crviewer_viewer_0(stateReport_002dviewer_jsp.java:108)<br /> at org.apache.jsp.stateReport_002dviewer_jsp._jspService(stateReport_002dviewer_jsp.java:61)<br /> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br /> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)<br /> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)<br /> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)<br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)<br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)<br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)<br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)<br /> at

java.lang.Thread.run(Unknown Source)<br />Caused by: java.lang.reflect.InvocationTargetException<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br /> at java.lang.reflect.Method.invoke(Unknown Source)<br /> ... 53 more<br />Caused by: java.lang.NoClassDefFoundError: OCA/OCAdbdll/DbDLLOperations<br /> at java.lang.ClassLoader.defineClass1(Native Method)<br /> at java.lang.ClassLoader.defineClass(Unknown Source)<br /> at java.security.SecureClassLoader.defineClass(Unknown Source)<br /> at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1815)<br /> at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:869)<br /> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1322)<br /> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)<br /> at java.lang.ClassLoader.loadClassInternal(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.eE(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader.loadDriver(Unknown Source)<br /> ... 57 more<br /><br /> </p>

Former Member
0 Kudos

<p>Hello, I have been able to code a working test app with CRXIR2 Developer using JRC-pushed XML Data, but some of its technical limitations made Ted Ueda advise me to use CR4E.</p><p>I now encounter the same problem as you do, XML Data sources seem not to be implemented in CR4E.</p><p>I have tried to copy my CRXIDev dlls (including crdb_xml) in my app&#39;s classpath, but this not much better.</p><p>Root cause before adding CRXIR2 Dev XML jars :</p><p>Caused by: java.lang.NoClassDefFoundError: com/crystaldecisions/data/xml/CRDB_XMLImpl<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.eE(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader.loadDriver(Unknown Source)<br /> ... 45 more<br /> </p><p>Root cause after adding them :</p><p>Caused by: java.lang.NoClassDefFoundError: OCA/OCAdbdll/DbDLLOperations<br /> at java.lang.ClassLoader.defineClass1(Native Method)<br /> at java.lang.ClassLoader.defineClass(Unknown Source)<br /> at java.security.SecureClassLoader.defineClass(Unknown Source)<br /> at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1815)<br /> at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:869)<br /> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1322)<br /> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)<br /> at java.lang.ClassLoader.loadClassInternal(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.<init>(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.a.eE(Unknown Source)<br /> at com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader.loadDriver(Unknown Source)<br /> ... 45 more<br /> </p>

Former Member
0 Kudos

<p>Just a link to another thread where we solved this issue :</p><p><a href="/node/1983#comment-2006">http://diamond.businessobjects.com/node/1983#comment-2006 </a> </p>

Answers (0)