Crystal Reports in Java with BEA Weblogic (test drive)

[Former Member]

Hello,<br/>

<br/>

The question is: What is wrong with Crystal Reports or BEA Weblogic, when they are working together? And how can it be repaired?<br/>

<br/>

I have a project working with reports. Tried to implement it for crystal reports and found an interesting problem. Crystal Reports didn't work with BEA Weblogic as well as with other servers. 1-2 years ago we just took Tomcat and worked with it. Right now we are interested in working with BEA.<br/>

<br/>

Everything works, but much slower than other servers. The best explanation is just a my tries in the end of the post. I hope some clever man helps me to option Weblogic or at least explains what is wrong.<br/>

<br/>

Test results are:<br/>

<br/>

- Apache Software Foundation - Tomcat 6.0:<br/>

~3 sec for clientDoc.open(reportName, OpenReportOptions._openAsReadOnly);<br/>

~1 sec for crystalReportPageViewer.processHttpRequest(request, response, application, null); <br/>

<br/>

- OC4J - Oracle Containers for J2EE 10g (10.1.3.3.0):<br/>

~4 sec for clientDoc.open(reportName, OpenReportOptions._openAsReadOnly);<br/>

~1 sec for crystalReportPageViewer.processHttpRequest(request, response, application, null); <br/>

<br/>

- Jetty 7.0.0.pre5:<br/>

~2 sec for clientDoc.open(reportName, OpenReportOptions._openAsReadOnly);<br/>

~0 sec for crystalReportPageViewer.processHttpRequest(request, response, application, null); <br/>

<br/>

- BEA Weblogic 9.2:<br/>

<b>~30 sec</b> for clientDoc.open(reportName, OpenReportOptions._openAsReadOnly);<br/>

<b>~8 sec</b> for crystalReportPageViewer.processHttpRequest(request, response, application, null); <br/>

<br/>

simple_cr_webapp.war (30 MB) can be downloaded [here|http://rapidshare.com/files/221096566/simple_cr_webapp.war.html] or [here|http://math.ut.ee/~a30858/simple_cr_webapp.war]:<br/>

crystalreportviewers //all viewers for 2.0
WEB-INF
  classes
    CRConfig.xml //see WAR - without key, only sets timeout and report location
  lib //all libraries for Eclipse plugin's web-app + j2ee.jar
  web.xml //see WAR - generated by Eclipse plugin
sample.jsp //see WAR - generated by Eclipse plugin
sample.rpt //"Consolidated Balance Sheet.rpt" from Eclipse plugin's web-app samples

<br/>

P.S. It is also suites if someone gives a simple project with CR, that works well. I really need to get solution for this problem, so any advises are expected.<br/>

[Former Member]

I also tried for different java vendors on BEA Weblogic 9.2.

Results for Jrockit are above: 30 sec and 8 sec

Results for Sun are worse than JRockit: 50 sec and 10 sec

JRockit:

java version "1.5.0_04"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_04-b05)

BEA JRockit(R) (build R26.0.0-189_CR269406-59389-1.5.0_04-20060322-1120-win-ia32, )

JAVA Memory arguments: -Xms500m -Xmx1000m

Sun:

java version "1.5.0_04"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_04-b05)

Java HotSpot(TM) Client VM (build 1.5.0_04-b05, mixed mode)

JAVA Memory arguments: -Xms256m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=256m -XX:MaxPermSize=256m