java调用SQL Server Reporting Services

zp7412

　　最近研究了一下SQL Reporting Services,  在这mark一下。
　　
　　Java调用SSRS，其实是调用了SSRS提供的一些webservice。
　　WSDL:
　　http://localhost:18080/ReportServer/ReportExecution2005.asmx
　　
　　首先下载axis2，
　　运行命令wsdl2java -uri ReportExecution2005.asmx.wsdl 生成java客户端代码。
　　
　　接着要实现ntlm验证
　　

private static void setupCredential() {
final NTCredentials nt = new NTCredentials("user", "password", "host", "domain");
final CredentialsProvider myCredentialsProvider = new CredentialsProvider() {
public Credentials getCredentials(AuthScheme scheme, String host, int port, boolean proxy) throws CredentialsNotAvailableException {
return nt;
}
};
DefaultHttpParams.getDefaultParams().setParameter("http.authentication.credential-provider", myCredentialsProvider);
}
　　
 注意，这边不能直接用axis2生成的代码，打开ReportExecutionServiceStub.java,修改soap version

　　

//Set the soap version
_serviceClient.getOptions().setSoapVersionURI(org.apache.axiom.soap.SOAP11Constants.SOAP_ENVELOPE_NAMESPACE_URI);
　　下面是完整的测试代码
　　

import java.io.FileOutputStream;
import java.io.InputStream;
import org.apache.commons.httpclient.Credentials;
import org.apache.commons.httpclient.NTCredentials;
import org.apache.commons.httpclient.auth.AuthScheme;
import org.apache.commons.httpclient.auth.CredentialsNotAvailableException;
import org.apache.commons.httpclient.auth.CredentialsProvider;
import org.apache.commons.httpclient.params.DefaultHttpParams;
import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.ReportExecutionServiceStub;

public class Test {
public static void main(String[] args) throws Exception {
setupCredential();
ReportExecutionServiceStub es=new ReportExecutionServiceStub("http://localhost:18080/ReportServer/ReportExecution2005.asmx");
ReportExecutionServiceStub.LoadReport lr= new ReportExecutionServiceStub.LoadReport();
lr.setReport("/Report Project1/Test Report");
ReportExecutionServiceStub.LoadReportResponse info=es.loadReport(lr, null);
ReportExecutionServiceStub.SetExecutionParameters param=new ReportExecutionServiceStub.SetExecutionParameters();
ReportExecutionServiceStub.ArrayOfParameterValue ps =new ReportExecutionServiceStub.ArrayOfParameterValue();
ReportExecutionServiceStub.ParameterValue pv=new ReportExecutionServiceStub.ParameterValue();
pv.setValue("8888");
pv.setName("id");
ps.addParameterValue(pv);
param.setParameters(ps);
ReportExecutionServiceStub.ExecutionHeaderE eh=new ReportExecutionServiceStub.ExecutionHeaderE();
ReportExecutionServiceStub.ExecutionHeader header=new ReportExecutionServiceStub.ExecutionHeader();
header.setExecutionID(info.getExecutionInfo().getExecutionID());
eh.setExecutionHeader(header);
es.setExecutionParameters(param, eh, null);

ReportExecutionServiceStub.Render render=new ReportExecutionServiceStub.Render();
render.setFormat("PDF");
ReportExecutionServiceStub.RenderResponse res=es.render(render, eh, null);
InputStream in=res.getResult().getInputStream();
FileOutputStream out=new FileOutputStream("Test Report.pdf");
byte [] buff=new byte[1024];
int lenth=-1;
while ( ( lenth=in.read(buff))!=-1) {
out.write(buff,0,lenth);
}
out.close();
}
private static void setupCredential() {
final NTCredentials nt = new NTCredentials("user", "password", "host", "domain");
final CredentialsProvider myCredentialsProvider = new CredentialsProvider() {
public Credentials getCredentials(AuthScheme scheme, String host, int port, boolean proxy) throws CredentialsNotAvailableException {
return nt;
}
};
DefaultHttpParams.getDefaultParams().setParameter("http.authentication.credential-provider", myCredentialsProvider);
}
}