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.
Difference between revisions of "EclipseLink/Development/DBWS/SQLBatchOperations"
< EclipseLink | Development | DBWS
(→Batch SQL operations) |
(→Batch SQL operations) |
||
| Line 14: | Line 14: | ||
> | > | ||
<text> | <text> | ||
| − | <![CDATA[ | + | <![CDATA[ |
| − | + | START TRANSACTION; | |
| − | + | SELECT @A:=SUM(salary) FROM table1 WHERE type=1; | |
| − | + | UPDATE table2 SET summary=@A WHERE type=1; | |
| − | + | COMMIT; | |
| − | ]]> | + | ]]> |
</text> | </text> | ||
</batch-sql> | </batch-sql> | ||
</source> | </source> | ||
| + | * need to figure out 2 types of variables: | ||
| + | *# parameters passed in (use JDBC '?' markers?) | ||
| + | *# temporary variables (@A) | ||
Revision as of 10:51, 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>
- need to figure out 2 types of variables:
- parameters passed in (use JDBC '?' markers?)
- temporary variables (@A)