Skip to main content

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.

Jump to: navigation, search

EclipseLink/Development/DBWS/SQLBatchOperations

< EclipseLink‎ | Development‎ | DBWS
Revision as of 10:49, 7 October 2010 by Michael.norman.oracle.com (Talk | contribs) (Batch SQL operations)


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