Before you can open your Data Mashup virtual database as a web service in a browser, you need to ensure that the URL is set up properly.
There are two tasks you can perform prior to opening your Data Mashup virtual database in a browser.
Choose which table columns you want to display in the browser
Set the Data Mashup virtual database so that it functions as desired in the browser
Requires Java CAPS 6 Update 1 or Sun GlassFish ESB.
In the Projects pane, highlight the Data Mashup project you created.
For example, DemoDMProject.
In the EDM Editor, choose the Design tab.
The ROOT JOIN, Runtime Input, and the SUPPLIER_ADDRESS and COMPANY_DATA tables appear in the EDM Editor. The columns that will be exposed in the browser are listed in the tables.
Locate and edit the URL for the Data Mashup virtual database.
Under the Projects tab, expand the composite application->Process Files, and select the WSDL for the project.
For example, demoCompositeApp and demoCompositeApp.wsdl.
In the WSDL Editor, choose the Source tab to expose the code for the WSDL.
Scroll down until you find the line that is similar to:
<http:address location="http://localhost:${HttpDefaultPort}/casaservice1/casaPort1"/>
You are going to edit the part of the string that is highlighted in bold. When you are done, the line will look something like: http:addresslocation="http://localhost:9080/casaservice1/casaPort1.
(Optional) If the casaPort numbers are already in use, for example, casaPort1 and casaPort2, change the number of casaPort in the string to another number, for example casaPort6.
Locate the port number for your localhost.
Type the code that sets how you can display your virtual database in the browser.
For example: ?page=0&row=0&column=0&. When you open your Data Mashup virtual database in the browser, replace the zeros (0) in the string to change how the information for COMPANY_DATA and SUPPLIER_ADDRESS is displayed.
Add the two tables you mashed together to the URL.
In the Projects pane, highlight the Data Mashup project you created.
For example, DemoDMProject.
In the EDM Editor, choose the Source tab.
In the EDM Editor, scroll until you find FILE_LOC_S1_SUPPLIER_ADDRESS and FILE_LOC_S2_COMPANY_DATA.
Add the runtime input, FILE_LOC_S1_SUPPLIER_ADDRESS and FILE_LOC_S2_COMPANY_DATA with =0& after the first file name and =0 after the second file to your URL.
If you changed the CASA port number as mentioned above, the URL should now look something like:
http://localhost:9080/casaservice1/casaPort6?page=0&row=0&column=0& FILE_LOC_S1_SUPPLIER_ADDRESS=0&FILE_LOC_S2_COMPANY_DATA=0
If you did not change the CASA port number as mentioned above, the URL should now look something like:
http://localhost:9080/casaservice1/casaPort1?page=0&row=0&column=0& FILE_LOC_S1_SUPPLIER_ADDRESS=0&FILE_LOC_S2_COMPANY_DATA=0
There are no spaces in this URL.
You are now ready to copy the URL into your browser and view and manipulate your project, which is now functions as a web service.
Open a browser and copy the URL into it.
Replace the zeros in the URL string to change how the web service displays.
If you have any trouble viewing the data, see issue #65 in Known Data Mashup Issues.
Repeat step 3 with other values.