Skip to Content

How to close ReportClientDocument in Crystal reports for JAVA

Feb 22, 2017 at 04:38 AM


avatar image
Former Member

We are using JAVA Crystal Reports to make WEB report (Oracle database) . Everything appears to the fine. However, we discovered a problem that the Crystal report makes dedicated DB connection each time when a report viewer is opened (with the help of

ReportClientDocument) this connection can be viewed in V$Session view.

The true problem is that the database entry remains open even if the report object is out of scope. If I close the ReportClientDocument before or after the report generation (viewer.dispose()) then the report will generate fine, but the report pagination would not work.

Our architecture is using Spring MVC (JAVA) with singleton service in the controller. Our question is how the DB connection can be closed with this type of architecture?

10 |10000 characters needed characters left characters exceeded

I have the same issue, any solution ????????

* Please Login or Register to Answer, Follow or Comment.

0 Answers