各位高手,为何我的代码会出现“Logon failed“错误。
用户名和密码都是正确的,ojdbc14.jar也放到WEB-INF下的lib中了
代码如下:
test.jsp
<%@ page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@ page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%@ page import="com.crystaldecisions.report.web.viewer.*" %>
<%@ page import="com.crystaldecisions.sdk.occa.report.data.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="com.crystaldecisions.sdk.occa.report.data.IConnection"%>
<%@ page import="java.sql.ResultSet,
java.beans.Statement,
java.sql.DriverManager,
java.sql.*,
com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSource,
com.crystaldecisions.report.web.viewer.CrystalReportViewer,
com.crystaldecisions.reports.reportengineinterface.JPEReportSource"%>
<%
IReportSource reportSource = null;
if(reportSource == null)
{
String report = "mybusiness.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource = (IReportSource) rptSrcFactory.createReportSource (report,request.getLocale());
} ConnectionInfos connInfos = new ConnectionInfos();
IConnectionInfo connInfo1 = new ConnectionInfo();
connInfo1.setUserName("vcmresource");
connInfo1.setPassword("vcmresource");
connInfos.add(connInfo1); CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setDatabaseLogonInfos(connInfos);
viewer.setEnableLogonPrompt(false);
viewer.setHasRefreshButton(true);
viewer.setHasLogo(false);
viewer.setPrintMode(CrPrintMode.ACTIVEX);
viewer.setOwnPage(true);
viewer.setOwnForm(true);
viewer.refresh();
viewer.processHttpRequest(request,response,getServletConfig().getServletContext(),out);
viewer.dispose();
%>
web.xml<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">
<display-name>MyWebModule</display-name>
<jsp-config>
<taglib>
<taglib-uri>/crystal-tags-reportviewer.tld</taglib-uri>
<taglib-location>/WEB-INF/crystal-tags-reportviewer.tld</taglib-location>
</taglib>
</jsp-config>
<context-param>
<param-name>crystal_image_uri</param-name>
<param-value>crystalreportviewers10</param-value>
</context-param>
<env-entry>
<env-entry-name>jdbc/oracle</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>!oracle.jdbc.driver.OracleDriver!jdbc:oracle:thin:@192.168.1.213:1521:oracle</env-entry-value>
</env-entry>
</web-app>
用户名和密码都是正确的,ojdbc14.jar也放到WEB-INF下的lib中了
代码如下:
test.jsp
<%@ page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@ page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%@ page import="com.crystaldecisions.report.web.viewer.*" %>
<%@ page import="com.crystaldecisions.sdk.occa.report.data.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="com.crystaldecisions.sdk.occa.report.data.IConnection"%>
<%@ page import="java.sql.ResultSet,
java.beans.Statement,
java.sql.DriverManager,
java.sql.*,
com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSource,
com.crystaldecisions.report.web.viewer.CrystalReportViewer,
com.crystaldecisions.reports.reportengineinterface.JPEReportSource"%>
<%
IReportSource reportSource = null;
if(reportSource == null)
{
String report = "mybusiness.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource = (IReportSource) rptSrcFactory.createReportSource (report,request.getLocale());
} ConnectionInfos connInfos = new ConnectionInfos();
IConnectionInfo connInfo1 = new ConnectionInfo();
connInfo1.setUserName("vcmresource");
connInfo1.setPassword("vcmresource");
connInfos.add(connInfo1); CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setDatabaseLogonInfos(connInfos);
viewer.setEnableLogonPrompt(false);
viewer.setHasRefreshButton(true);
viewer.setHasLogo(false);
viewer.setPrintMode(CrPrintMode.ACTIVEX);
viewer.setOwnPage(true);
viewer.setOwnForm(true);
viewer.refresh();
viewer.processHttpRequest(request,response,getServletConfig().getServletContext(),out);
viewer.dispose();
%>
web.xml<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">
<display-name>MyWebModule</display-name>
<jsp-config>
<taglib>
<taglib-uri>/crystal-tags-reportviewer.tld</taglib-uri>
<taglib-location>/WEB-INF/crystal-tags-reportviewer.tld</taglib-location>
</taglib>
</jsp-config>
<context-param>
<param-name>crystal_image_uri</param-name>
<param-value>crystalreportviewers10</param-value>
</context-param>
<env-entry>
<env-entry-name>jdbc/oracle</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>!oracle.jdbc.driver.OracleDriver!jdbc:oracle:thin:@192.168.1.213:1521:oracle</env-entry-value>
</env-entry>
</web-app>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货