Skip to main content

Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "EclipseLink/Development/DBWS/SQLBatchOperations"

(Batch SQL operations)
Line 10: Line 10:
 
<source lang="xml">
 
<source lang="xml">
 
<batch-sql
 
<batch-sql
   name="get_analyzed_traces"
+
   name="do_analyzed_traces"
 
   lineDelimiter=";"
 
   lineDelimiter=";"
 
   >
 
   >

Revision as of 10:49, 7 October 2010


Batch SQL operations

Initial contribution by customer Rainer Schild: A DBWSBuilder file that looks something like:

<batch-sql
  name="do_analyzed_traces"
  lineDelimiter=";"
  >
  <text>
<![CDATA[
    START TRANSACTION;
    SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
    UPDATE table2 SET summary=@A WHERE type=1;
    COMMIT;
]]>
  </text>
</batch-sql>

Back to the top