各位高手,为何我的代码会出现“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>