EclipseLink/Development/DBWS/SQLBatchOperations

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>

• need to figure out 2 types of variables:
  1. parameters passed in (use JDBC '?' markers?)
  2. temporary variables (@A)