Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Examples/DBWS/DBWSBasicStoredProcedure"
< EclipseLink | Examples | DBWS
(→EclipseLink DBWS Service based on Stored Procedure) |
|||
| Line 13: | Line 13: | ||
U := CONCAT(T, '-test'); | U := CONCAT(T, '-test'); | ||
END; | END; | ||
| + | </source> | ||
| + | |||
| + | The DBWSBuilder utility requires a DBWS configuration file as input. | ||
| + | <source lang="xml" enclose="div"> | ||
| + | <?xml version="1.0" encoding="UTF-8"?> | ||
| + | <dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema"> | ||
| + | <properties> | ||
| + | <property name="projectName">testEcho</property> | ||
| + | ... database properties | ||
| + | </properties> | ||
| + | <procedure | ||
| + | name="testEcho" | ||
| + | procedurePattern="TESTECHO" | ||
| + | isSimpleXMLFormat="true" | ||
| + | /> | ||
| + | </dbws-builder> | ||
| + | </source> | ||
| + | <source lang="text"> | ||
| + | prompt > dbwsbuilder.cmd -builderFile dbws-builder.xml -stageDir output_directory -packageAs wls testEcho.war | ||
</source> | </source> | ||
Revision as of 13:48, 3 April 2009
EclipseLink DBWS Service based on Stored Procedure
The use-case for this example is the creation of a Web service that exposes a Stored Procedure (or multiple procedures). From the metadata for a Stored Procedure, it is not possible to determine the structure of the returned data. Therefore, the Simple XML Format schema is used. The EclipseLink DBWS runtime produces an XML document that is simple and 'human-readable'. Any combination of IN, OUT and IN OUT arguments are supported; in addition, procedures in packages that are overloaded - same name, different parameters – are supported.
The following stored procedure will be used for this example:
DROP PROCEDURE TESTECHO;
CREATE OR REPLACE PROCEDURE TESTECHO(T IN VARCHAR2, U OUT VARCHAR2) AS
BEGIN
U := CONCAT(T, '-test');
END;
CREATE OR REPLACE PROCEDURE TESTECHO(T IN VARCHAR2, U OUT VARCHAR2) AS
BEGIN
U := CONCAT(T, '-test');
END;
The DBWSBuilder utility requires a DBWS configuration file as input.
<?xml version="1.0" encoding="UTF-8"?>
<dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<properties>
<property name="projectName">testEcho</property>
... database properties
</properties>
<procedure
name="testEcho"
procedurePattern="TESTECHO"
isSimpleXMLFormat="true"
/>
</dbws-builder>
<dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<properties>
<property name="projectName">testEcho</property>
... database properties
</properties>
<procedure
name="testEcho"
procedurePattern="TESTECHO"
isSimpleXMLFormat="true"
/>
</dbws-builder>
prompt > dbwsbuilder.cmd -builderFile dbws-builder.xml -stageDir output_directory -packageAs wls testEcho.war