Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal report locking out DB account

Hi,

We have a few crystal reports which we are displaying on jsp(Crystal Reports Viewer) page. Some of the crystal reports are locking out the DB account while trying to render the report and its occuring randomly. I have following code in my jsp and the account gets locked out when a call is made to  processHttpRequest method.

//Create the CrystalReportViewer object
com.crystaldecisions.report.web.viewer.CrystalReportViewer crystalReportViewer = new com.crystaldecisions.report.web.viewer.CrystalReportViewer();
crystalReportViewer.setDatabaseLogonInfos(connections);
//Set the reportsource property of the viewer
crystalReportViewer.setReportSource(reportSource);

//Set viewer attributes
crystalReportViewer.setOwnPage(true);
crystalReportViewer.setOwnForm(true);
crystalReportViewer.setEnableParameterPrompt(false);
crystalReportViewer.refresh();
 
//Set the CrystalReportViewer print mode
crystalReportViewer.setPrintMode(com.crystaldecisions.report.web.viewer.CrPrintMode.PDF);

crystalReportViewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);

We are using Crystal Reports XI and using the eclipse plugin to set the datasource values for the reports. The reports are connecting to Oracle 11g database.

Any help in overcoming this issue is really appreciated.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question