CR XI R2 JRC: Error loading database connector (driverImpl.DriverLoader)

[former_member707375]

Hello!

I developed a report with CR XI R2 SP6 Designer that uses native XML. Everything in the report seems to be fine...in the preview of my report, all data looks correct.

When trying to review the report with the JRC thick client ReportViewerBean, I get the following error just as the report is about to be displayed:

Error loading database connector. The class 'com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader' could not be accessed.

I went through about ten or so previous threads about this error, but none of the solutions are working for me.

I'm using NetBeans to develop and debug, and I have CrystalDatabaseConnector.jar added to my project libraries, and I can view the class com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader in the NetBeans object browser.

Some of the posts I viewed mention a different jar for this DriveLoader class. Is there something wrong with the version of CrystalDatabaseConnector.jar that I have? Do I need an updated jar? Does this jar rely on another jar that might be missing? I've been through the jar list in the CR XI R2 JRC deployment guide pdf, but I just don't see that I'm missing anything.

Thanks for any suggestions!

Edited by: Joseph Huber on Mar 9, 2010 2:00 AM

[former_member707375]

Well...problem solved.

Per recommendation in another thread for CR 2008 (not the version I have), I downloaded the latest runtime from

http://www.businessobjects.com/campaigns/forms/downloads/crystal/eclipse/datasave.asp

I removed the XI R2 SP6 jars from my project, add the latest runtime jars, and presto, everything works fine. So, I wasted several days looking for problems in my application when it looks like the problem was a faulty jar file.

SAP...please...do the following:

1) Fix the jar files in the latest XI R2 service pack so that they work properly. For example, just by looking at those jars with NetBeans object browser, one can see identical classes defined in multiple jar files that the JRC deployment guide instructs to add to the project. That can't be good. SP6 was released in December 2009, so it seems that the latest runtime could be added to that SP.

2) Fix the various documenation pdfs in the SAP Notes regarding CR XI R2 JRC. There are conflicts among the various documents about which jars to add to the classpath, which jars should come first, how to configure CRConfig.xml, etc. It's a mess.

- OR -

Add a note to the knowledgebase directing XI R2 users to download the latest Java runtime and not waste time with the JRC distributed with CR XI R2.

Thanks!

[former_member707375]

Some stuff from the Java Console...

[...]

- Formula {@DesiredEFT} compiled.

- Formula {@DesiredLFT} compiled.

- Formula {@DesiredGPM} compiled.

- Done loading report.

- Time to load report T:\USGD_Share\PCVOLS1\source\java\CRViewerTest\crDxProposal1.rpt took 160346 ms

Crystal Report Viewer 2.1.21.2

java.vendor = Sun Microsystems Inc.

java.version = 1.6.0_16

os.name = Windows XP

os.version = 5.1

os.arch = x86

- JRCAgent1 received request: queryServerCapabilitiesRequest

- Export Supervisor: loading available exporters

- Export Supervisor: found 6exporters

- Export Supervisor: loading exporter com.crystaldecisions.reports.exporters.format.page.pdf.PDFExporter

- Export Supervisor: loading exporter com.crystaldecisions.reports.exporters.format.page.rtf.RTFExporter

- Export Supervisor: loading exporter com.crystaldecisions.reports.exporters.format.report.crystalreports.CRExporter

- Export Supervisor: loading exporter com.crystaldecisions.reports.exporters.format.record.sepv.SEPVExporter

- Export Supervisor: loading exporter com.crystaldecisions.reports.exporters.destination.disk.DiskExporter

- Export Supervisor: loading exporter daviss.jeff.cellexporter.CellExporter

- Export Supervisor: fail to load exporter (stack trace follows). This warning is only a problem if the exporter that failed to load is supported in a given project.daviss.jeff.cellexporter.CellExporter

java.lang.ClassNotFoundException: daviss.jeff.cellexporter.CellExporter

at java.net.URLClassLoader$1.run(URLClassLoader.java:200)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:188)

at java.lang.ClassLoader.loadClass(ClassLoader.java:307)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)

at java.lang.ClassLoader.loadClass(ClassLoader.java:252)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:169)

at com.crystaldecisions.reports.formatter.a.c.char(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.case(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.for(Unknown Source)

at com.businessobjects.reports.sdk.b.i.do(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.getServerCapabilities(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getServerCapabilities(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.getServerCapabilities(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.rs.a.t(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.rs.a.<init>(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.rs.RSReportChannelFactory.newReportChannel(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.bi.a(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.bi.a(Unknown Source)

at com.crystaldecisions.ReportViewer.ReportViewer$1.a(Unknown Source)

at com.businessobjects.crystalreports.viewer.applet.h.run(Unknown Source)

at java.lang.Thread.run(Thread.java:619)

- JRCAgent1 received request: fetchReportPageRequest

- JRCAgent1 attempting to acquire license

- JRCAgent1 successfully acquired license

- JRCAgent1 detected an exception: Error loading database connector. The class 'com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader' could not be accessed.

at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(Unknown Source)

at com.businessobjects.reports.sdk.b.i.if(Unknown Source)

at com.businessobjects.reports.sdk.b.i.a(Unknown Source)

at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.getPage(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.rs.b.if(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.av.a(Unknown Source)

at com.businessobjects.crystalreports.viewer.core.av.run(Unknown Source)

at java.lang.Thread.run(Thread.java:619)

- JRCAgent1 releasing license

Error loading database connector. The class 'com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader' could not be accessed.

[Former Member]

I'm using CR XI R2 and the java version installed was 1.4. I have a requirement to bring the java version up to date. What's the easiest way to update java for crystal reports server? should I run the installation again? or is there a configuration change? I noticed you have 1.6 as your version. How did you have this version configured or installed?

[former_member707375]

I'm not using Crystal Reports Server, so I can't help you there. My application is of the stand-alone desktop (thick client) variety, so all I have to do is replace the distributed JAR files with updated JARs, and make sure that the clients have the latest Java Runtime installed.

Edited by: Joseph Huber on Mar 31, 2010 8:11 PM

[former_member707375]

Additional info...

I went over the jar file list again in the CR XI R2 Java Deployment Guide (JDG), and found that the file log4j-1.2.8.jar is required when using the native XML driver. This file is supposed to be in Program Files\Business Objects\common\3.5\java\lib\external, but I don't find that file there, or anywhere on my C drive. Somehow it is missing, so I went and downloaded this file from apache.org. From what I can tell, it is exactly the same as log4j.jar (which is also specified as a core library in the JDG) that I have.

I found a thread which lists required jar files. It also mentions two more that are not listed in the CR XI R2 JDG: UriUtil.jar and xerces.jar. I have the first one, but cannot find the second one, although I have a xercesImpl.jar. Do I need xerces.jar? Where do I get it?

It would be very helpful is someone from SAP could clarify what is needed, because it seems that either there is something wrong with the CR XI R2 JDG, or there is something wrong with the software installation files, because I seem to be missing some jar files.

Thanks!

Edited by: Joseph Huber on Mar 9, 2010 5:18 PM