|
|
| Re: Eclipse link multiple SQL web services operations [message #1008086 is a reply to message #982733] |
Fri, 08 February 2013 15:51  |
Eclipse User |
|
|
|
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.
Cheers,
Dave
|
|
|
Powered by
FUDForum. Page generated in 0.06548 seconds
Home
