Page History
If big data sets have to be read from a database, it is recommended not to read all records at once. Instead do the following steps:
- Get an SQL handle using the getHandle operation from the SQL adapter.
- Iterate over the database records by using fetchNext until no more records are returned.
- If you don not iterate to the end of the result set, close the handle (operation closeHandle) to free resources. If the end of the handle is reached, the handle is closed automatically by the xUML Runtime.
| Info |
|---|
In this case, the SQL output cannot be checked against the type since the output record is not known yet in the getHandle operation but only at fetchNext. |
The example below shows an activity executing these steps.
The iteration over the SQL handle using fetchNext has to be implemented by the developer in an activity diagram. For more information refer to Implementing a Loop.
| Panel | ||
|---|---|---|
| ||
|
| Multiexcerpt include | ||||||
|---|---|---|---|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
Overview
Content Tools