biee webservice 的使用 java_biee webservice的使用java.doc

Java调用biee webservice

参考资料：http://obieestuff.blogspot.hk/2012/04/calling-bip-runreport-from-job-manager.html

Biee版本：11.1.1.5

Jdeveloper版本：11.1.1.5

使用ReportService生成报表(生成的报表在服务器上)

package bip;

import com.oracle.xmlns.oxp.service.v2.AccessDeniedException_Exception;

import com.oracle.xmlns.oxp.service.v2.InvalidParametersException_Exception;

import com.oracle.xmlns.oxp.service.v2.OperationFailedException_Exception;

import com.oracle.xmlns.oxp.service.v2.ReportRequest;

import com.oracle.xmlns.oxp.service.v2.ReportService_Service;

import com.oracle.xmlns.oxp.service.v2.ReportService;

public class test1 {

public static void main(String[] args) {

ReportService_Service reportService_Service = new ReportService_Service();

ReportService reportService =reportService_Service.getV2ReportService();

// Add your code to call the desired methods.

// Set up the credentials for our service call

String username = "123";

String password = "23324";

// Instantiate a new ReportRequest object

ReportRequest repReq = new ReportRequest();

// Define the report that we want to run

repReq.setReportAbsolutePath("/test_lin/test_model_report.xdo"); // This is the Report name, as an absolute path.

// Define what we want to do with it

repReq.setAttributeFormat("pdf"); // defaults to HTML

repReq.setReportOutputPath("/tmp/report.pdf"); // The path on the **BIP server** to which the report should be saved

// Lets go!

try {

reportService.runReport(repReq, username, password);

} catch (InvalidParametersException_Exception e) {

System.out.println("Exception thrown: InvalidParameters!");

} catch (AccessDeniedException_Exception e) {

System.out.println("Exception thrown: AccessDenied!");

} catch (OperationFailedException_Exception e) {

System.out.println("Exception thrown: OperationFailed!");

}

// All done

System.out.println("Success!");

}

}

使用ScheduleService，DeliveryChannels生成并发送报表，可以email给某个用户，也可以ftp到某个目录。

package bip;

import com.oracle.xmlns.oxp.service.publicreportservice.PublicReportService;

import com.oracle.xmlns.oxp.service.publicreportservice.PublicReportServiceService;

import com.oracle.xmlns.oxp.service.v2.AccessDeniedException_Exception;

import com.oracle.xmlns.oxp.service.v2.ArrayOfEMailDeliveryOption;

import com.oracle.xmlns.oxp.service.v2.ArrayOfLocalDeliveryOption;

import com.oracle.xmlns.oxp.service.v2.ArrayOfParamNameValue;

import com.oracle.xmlns.oxp.service.v2.ArrayOfXsdString;

import com.oracle.xmlns.oxp.service.v2.DeliveryChannels;

import com.oracle.xmlns.oxp.service.v2.EMailDeliveryOption;

import com.oracle.xmlns.oxp.service.v2.InvalidParametersException_Exception;

import com.oracle.xmlns.oxp.service.v2.LocalDeliveryOption;

import com.oracle.xmlns.oxp.service.v2.OperationFailedException_Exception;

import com.oracle.xmlns.oxp.service.v2.ParamNameValue;

import com.oracle.xmlns.oxp.service.v2.ParamNameValues;

import com.oracle.xmlns.oxp.service.v2.ReportRequest;

import com.oracle.xmlns.oxp.service.v2.ReportService;

import com.oracle.xmlns.oxp.service.v2.ReportService_Service;

import com.oracle.xmlns.oxp.service.v2.ScheduleRequest;

import com.oracle.xmlns.oxp.service.v2.ScheduleService;

import com.oracle.xmlns.oxp.service.v2.ScheduleService_Service;

public class schedule_test3 {

public static void main(String[] args) throws AccessDeniedException_Exception,

InvalidParametersException_Exception,

OperationFailedException_Exception {

String username = "123321";

String password = "234233";

ScheduleService_Service schedule_Service = new ScheduleService_Service();

ScheduleService scheduleService =schedule_Service.getV2ScheduleService();

// scheduleService.scheduleReportInSession(scheduleRequest, deliveryChannels, bipSessionToken)

//deliveryChannels

DeliveryChannels deliveryChannels=new DeliveryChannels();

ArrayOfEMailDeliveryOption arrayEmailOption=new ArrayOfEMailDeliveryOption();

EMailDeliveryOption eMail = new EMailDeliveryOption();

eMail.setEmailTo("[email protected]");

eMail.setEmailSubject("This is a BIP Web Service Test...");

//eMail.setEmailFrom("[email protected]");

eMail.setEmailCC("[email protected]");

eMail.setEmailBody("Test");

arrayEmailOption.getItem().add(eMail);

deliveryChannels.setEmailOptions(arrayEmailOption);

//scheduleRequest

// Set Report request attributes

ReportRequest req = new ReportRequest();

req.setAttributeFormat("html");//pdf

req.setAttributeLocale("zh-hk"); //en-US

// req.setAttributeTemplate("service_confirm_letter_layout");

req.setReportAbsolutePath("/test_lin/service_confirm_letter_report.xdo");

ScheduleRequest scheduleRequest =new ScheduleRequest();

scheduleRequest.setDeliveryChannels(deliveryChannels);

scheduleRequest.setReportRequest(req);

// scheduleRequest.setNotificationTo("[email protected]");

scheduleRequest.setSaveDataOption(true);

scheduleRequest.setScheduleBurstringOption(false);

scheduleRequest.setSchedulePublicOption(true);

scheduleRequest.setUserJobName("WebService Job1");

//Paramter

ParamNameValues nameValues=new ParamNameValues();

ArrayOfParamNameValue arrValue=new ArrayOfParamNameValue();

ParamNameValue pValue=new ParamNameValue();

pValue.setName("ORDE_DATE_COMP");

ArrayOfXsdString axs=new ArrayOfXsdString();

axs.getItem().add("20120510");

pValue.setValues(axs);

arrValue.getItem().add(pValue);//ParamNameValue

arrValue.getItem().add(pValue);

nameValues.setListOfParamNameValues(arrValue); //ArrayOfParamNameValue

req.setParameterNameValues(nameValues);//ParamNameValues

scheduleRequest.setReportRequest(req);

scheduleService.scheduleReport(scheduleRequest, username, password);

System.out.println("Success!");

}

}

展开阅读全文