Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implementing SQL Server Reporting Services with a Java EE Application

843833Feb 20 2008 — edited Jun 24 2009
Hi All,

I need to find some tutorial on
"Implementing SQL Server Reporting Services with a Java EE Application"
for my j2EE application.
Until now i have searched a lot of sites but have not any thing related to this topic.
I am using apache axis along with SQL Server Report Manager for creating the sql server reports.
I have done upto :
Creating the webservice with the help of report manager.

Now i want to connect it through my j2EE application and want to retrieve some data from that web service.
I have got stuck on the following BOLD lines in my code .



code:
public CatalogItem[] getData(String res, String searchStr) throws RemoteException	{
    		
    		
    		ReportingService2005Soap port = null;
    		ReportingService2005Locator loc = new ReportingService2005Locator();
    		// Retrieve a port from the service locator
    		try {
    			port = loc.getReportingService2005Soap(new java.net.URL(res));
    		} catch (MalformedURLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (ServiceException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		org.apache.axis.client.Stub stub = (org.apache.axis.client.Stub) port;
    		stub.setUsername("localhost\\Administrator");
    		stub.setPassword("servWIN@2007");
    		
    		// Retrieve a port from the service locator
    		
    		SearchCondition condition = new SearchCondition();
    		condition.setCondition(ConditionEnum.Contains);
    		condition.setName("Name");
    		if (searchStr != null)
    		{
    		condition.setValue(searchStr);
    		}
    		else
    		{
    		condition.setValue("");
    		}
    //		 Create an array of SearchConditions which will contain our single search condition
    		
    		SearchCondition[] conditions;
    		conditions = new SearchCondition[1];
    		conditions[0] = condition;
    	
    //		 Call the Web service with the appropriate CatalogItem[] returnedItems;
    		CatalogItem[] returnedItems = null;
    		port.findItems("foldername",BooleanOperatorEnum.Or, conditions);
    		
    		return returnedItems;
    	}
i.e. while executing the findItems() method i got the following exception :

System.Web.Services.Protocols.SoapException: The item '/reportingservices' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/reportingservices' cannot be found.
at Microsoft.ReportingServices.Library.RSService.FindItems(String folder, String operation, SearchCondition[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, SearchCondition[] Conditions, CatalogItem[]& Items)


Any any body has any idea please help me.
I need it urgently.
Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2009
Added on Feb 20 2008
4 comments
229 views