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
| Line 8: | Line 8: | ||
== Batch SQL operations == | == Batch SQL operations == | ||
Initial contribution by customer Rainer Schild: A DBWSBuilder file that looks something like: | Initial contribution by customer Rainer Schild: A DBWSBuilder file that looks something like: | ||
| − | |||
<source lang="xml"> | <source lang="xml"> | ||
| − | <batch-sql name="get_analyzed_traces"> | + | <batch-sql |
| − | < | + | name="get_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> | </batch-sql> | ||
</source> | </source> | ||
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="get_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>