刷新BO中的数据

Question

我在 BO 中刷新报告时遇到错误。我要做的就是刷新 BO 中的报告并找到刷新所需的时间。一旦找到所有这些，我就必须将这些数据插入 MySQL 表中。

当我这样做时，我收到以下错误。

线程“main”中出现异常 com.businessobjects.rebean.wi.ServerException：发生数据库错误。数据库错误文本为：(CS)“DBDriver 无法加载：C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll（找不到指定的模块。 ）”。（WIS 10901）

这是怎么造成的以及如何解决？

这是 BO 代码：

import java.util.Iterator;
import java.sql.*;



import com.businessobjects.rebean.wi.DocumentInstance;
import com.businessobjects.rebean.wi.ReportEngine;
import com.businessobjects.rebean.wi.ReportEngines;
import com.crystaldecisions.sdk.exception.SDKException;
import com.crystaldecisions.sdk.framework.CrystalEnterprise;
import com.crystaldecisions.sdk.framework.IEnterpriseSession;
import com.crystaldecisions.sdk.framework.ISessionMgr;
import com.crystaldecisions.sdk.occa.infostore.IInfoObject;
import com.crystaldecisions.sdk.occa.infostore.IInfoObjects;
import com.crystaldecisions.sdk.occa.infostore.IInfoStore;
public class RefreshWebi {

    /**
     * @param args
     * @throws ClassNotFoundException 
     * @throws SQLException 
     */
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // TODO Auto-generated method stub
        String cms="172.16.56.114";
        String username="administrator";
        String password="";
        String auth="secEnterprise";        
        String driver="com.mysql.jdbc.Driver";
        Connection conn;

        IEnterpriseSession enterpriseSession;

        System.out.println("success");

        Long currentTime;
        try {
            ISessionMgr sessionMgr=CrystalEnterprise.getSessionMgr();
            enterpriseSession=sessionMgr.logon(username, password,cms, auth);
            IInfoStore iStore=(IInfoStore)enterpriseSession.getService("InfoStore");    
            //bologger.entering("BOUtilities", "refreshWebIReport");
            IInfoObjects reportObjects = iStore.query("select top 1 * from ci_infoobjects where si_kind='webi'");

            ReportEngines reportEngines = (ReportEngines) enterpriseSession.getService("ReportEngines");
            ReportEngine reportEngine = reportEngines.getService(ReportEngines.ReportEngineType.WI_REPORT_ENGINE);
            Iterator it = reportObjects.iterator();
            while (it.hasNext()) {
                IInfoObject reportObject = (IInfoObject) it.next();
                DocumentInstance documentInstance = reportEngine
                        .openDocument(reportObject.getID());

                currentTime = System.currentTimeMillis();

                documentInstance.refresh();
                System.out.println("Time taken to refresh "
                        + (System.currentTimeMillis() - currentTime) / 1000);
                documentInstance.closeDocument();
                int documentID = reportObject.getID();              
                String documentName=reportObject.getTitle();                
                long refreshtime=currentTime.intValue();
                long refreshDuration=(System.currentTimeMillis() - currentTime) / 1000;
                int refreshtimes=(int)refreshtime;              
                int refdur=(int)refreshDuration;
                System.out.println("Document id     :"+documentID);
                System.out.println("Document name     :"+documentName);
                System.out.println("Refreshtime   :"+refreshtimes);
                System.out.println("Refresh duration  :"+refdur);

                Class.forName(driver);
                conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "password");               
                Statement st=conn.createStatement();
                st.executeUpdate("insert into refreshtimings (documentid,documentname,refreshtime,refreshduration)values('"+documentID+"','"+documentName+"','"+refreshtimes+"','"+refdur+"')");
                conn.close();   

            }
            reportEngine.close();
            reportEngines.close();

        } catch (SDKException e) {
            e.printStackTrace();
        }
}

Answer 1

该错误是指该报告的数据库驱动程序在 Business Objects 服务器上不可用。我会检查一下您是否在信息视图中遇到相同的错误，我猜您会的。

要解决此问题，您需要验证报表连接使用的数据库类型是否正确，以及您是否已安装 Business Objects 的相关数据源类型。