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!");
}
}
展开阅读全文