| Webservice Data Source Plugin for Reports [message #406515] |
Thu, 04 June 2009 06:44  |
rm_mainframe
Messages: 8
Registered: October 2008
Location: Liverpool, UK
|
Junior Member |
|
|
Hi there,
I'm trying to retrieve data from a webservice to place on my oracle report, using Oracle's Webservice Data Source Plugin for Reports:
http://www.oracle.com/technology/products/reports/pluginxchange/index.html
I believe that my setup is OK, I've followed the directions from here:
http://www.oracle.com/technology/products/reports/pluginxchange/plugins/datasource/webservicePDS/readme.html
ie:
the soap.jar, WsPDS.jar and jdev-rt.jar files are all present in C:\Frs1002\reports\jlib
All three files and the above location are in my REPORTS_CLASSPATH registry setting.
I've also added in the line to my cauprefs.ora file as required:
"oracle.reports.plugin.datasource.wspds.WSDataSourceFactory",
But...
When using the report wizard everything runs fine just as the oracle supplied example, until it asks me for a WSDL file:
As an example I'm using one from Amazon.com, (just to show that there is nothing wrong with the link):
http://webservices.amazon.com/AWSECommerceService/UK/AWSECommerceService.wsdl
Click Next, and wa-la! Nothing happens.
Has anyone else had this issue?
Does anyone else use WebService data in their reports with success? Is the problem that this seems to be a Reports9i Plugin?
Please see the attached pic.
Any suggestions or assistance appreciated.
Ron.
|
|
|
|
| Re: Webservice Data Source Plugin for Reports [message #406537 is a reply to message #406515] |
Thu, 04 June 2009 08:26  |
rm_mainframe
Messages: 8
Registered: October 2008
Location: Liverpool, UK
|
Junior Member |
|
|
One other item of troubleshooting information that I didn't mention is that I don't use a proxy to connect to the internet, thus, I haven't set up the forms report builder with a proxy either.
I did however, try this:
I connect to the internet using a gateway, so looking at the instructions, I added the gateway's ip address to:
C:\Frs1002\reports\conf\proxyinfo.xml
<proxyServer name="xx.xx.xx.xx" port="80" protocol="all"/>
When I enable this through the C:\Frs1002\reports\conf\rwbuilder.conf file
I get the following error when I click on Query Definition: WSPDS-100 Error while extracting Config File! null
Putting two and two together, the WebService Pluggable data source seems to be looking for a configuration file. A config file isn't supplied anywhere in the ZIP supplied by Oracle, it's all JAR files. Help!
Suggestions?
Ron.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
