|Re: Eclipse link multiple SQL web services operations [message #1008086 is a reply to message #982733]
||Fri, 08 February 2013 15:51
| David McCann
Registered: July 2009
Although I wouldn't recommend trying to modify the generated artifacts, it is possible to do so to enable multiple SQL request/responses. You'd need to make sure the WSDL had types, etc. all set correctly. The generated schema file would need to reflect any referenced types, and the generated service file would need <query> entries added accordingly. If the data triggered ORM project generation you'd need to make changes there as well. |
Although the JDeveloper UI doesn't allow a service to be generated from multiple SQL statements, the standalone DBWS builder does. There are some examples you can check out on the Eclipse Wiki: http://wiki.eclipse.org/EclipseLink/Examples/DBWS. If you wanted to download an EclipseLink install and try out the DBWS Builder, look here: http://www.eclipse.org/eclipselink/downloads. There are scripts in <ECLIPSELINK_HOME>/utils/dbws that will allow you to run the builder from a terminal.
Note that the JDeveloper tool does allow multiple stored procedures to be selected when generating a web service, so another other option would be to create a stored procedure for each of your SQL statements and generate the web service based on them.
Hope this helps.
Powered by FUDForum
. Page generated in 0.08407 seconds