大哥大姐帮帮忙
com.crystaldecisions.sdk.occa.report.lib.ReportSDKLogonException: 登录失败。
Error in File C:\WINDOWS\TEMP\{AF534FAB-3358-4406-BBE1-61671717AC4B}.rpt:
Unable to connect: incorrect log on parameters.---- Error code:-2147217393 Error code name:dbLogonFailed
我的出错了了我是想把xml文件当作数据源,下面是我的程序:
// If logon information is required, display the logonForm and exit.
// (code for LogonForm class is in logonform.jsp)
LogonForm logonform = new LogonForm(response, request);
if (logonform.display_if_needed()) return;
// Log in to Enterprise and get the report to modify
// (code for Enterprise class in Generic.jsp)
Generic myGeneric = new Generic(logonform.cmsname, logonform.username, logonform.password, logonform.authType);
ReportClientDocument oReportClientDocument = myGeneric.getClientDoc("reportXml1");
oReportClientDocument.getDatabaseController().logon("report_pmad", "report_pmad");
// Return the given details section (0 = A, 1 = B, etc)
Section oDetailsSection = (Section)oReportClientDocument.getReportDefController().getReportDefinition().getDetailArea().getSections().getSection(0);
FieldAdder myFieldAdder = new FieldAdder(oReportClientDocument);
myFieldAdder.add_db_field(oDetailsSection,
"C_REPORTS.REPORT_ID",
FieldValueType.stringField,
0.000, 0.000, 1.300, 0.160);
myFieldAdder.add_db_field(oDetailsSection,
"C_REPORTS.REPORT_NAME",
FieldValueType.stringField,
2.000, 0.000, 1.300, 0.160);
myFieldAdder.add_db_field(oDetailsSection,
"C_REPORTS.REPORT_TYPE",
FieldValueType.stringField,
4.000, 0.000, 1.300, 0.160);
System.out.println("xml1");
String xmlFileStr = "G:\\eclipse\\workspace\\crystal1\\WebContent\\RAS\\xml\\report1.xml";
File xmlFile = new File(xmlFileStr);
if(!xmlFile.exists())
{
//JOptionPane.showMessageDialog(parent, "XML file doesn't exist: " + xmlFileStr);
return;
}
System.out.println("xml2");
InputStream is = new FileInputStream(xmlFileStr);
int length = is.available();
byte[] byteArray = new byte[length];
is.read(byteArray, 0, length);
ByteArray ba = new ByteArray(byteArray);
IXMLDataSet xmlSet = new XMLDataSet();
xmlSet.setXMLData(ba);
System.out.println(xmlSet);
// rpt.getDatabaseController().setDataSource(xmlSet, "", "");
System.out.println("xml3");
String tableAlias = oReportClientDocument.getDatabaseController().getDatabase().getTables().getTable(0).getAlias();
System.out.println("xml5");
//oReportClientDocument.getDatabaseController().logon("report_pmdb", "report_pmdb");
oReportClientDocument.getDatabaseController().setDataSource(xmlSet,"", "");//这地方出错误了
System.out.println("xml4");
// View the result
session.setAttribute("CrystalReportViewer.ReportSource", oReportClientDocument.getReportSource());
response.sendRedirect("CrystalReportViewer.jsp");
%>