Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space WBRIDGE and version 7.4.1
Div
Classe2e-refDiv

Otp
Floatingfalse

Rp

Basically, stored procedures are modeled like static UML operations that can be called using a call operation action having the stereotype <<SQLAdapter>> as depicted in the activity diagrams below.

...

As input and output of stored procedures, the Bridge supports all simple base types.

Noteinfo
iconfalse

When specifying String objects as CLOB parameters, you have to mark them with tag nativeType=CLOB.

Noteinfo
iconfalse

Please note that the user must be authorized to select data from the table mysql.proc to use stored procedures with MySQL, because the SQL API calls this table to find meta data.

...

You can find more information in the stored procedures example.

Noteinfo
iconfalse

You cannot run the example on the SQLite databases we deliver with the E2E Bridge tool set. If you have an Oracle database you could set up the stored procedures there and change the component diagram in the model to run it against your database.

...

In the first case, the adapter iterates over the cursor and puts all results into the output array. In the second case, the adapter just returns the SQLHandle enabling the modeler to iterate over the cursor. This approach is to be preferred if the result set is big.

Noteinfo
iconfalse

You can name the parameter as you like. The name doesn't have to be result (as it is in the example) – only criteria are the direction, the stereoptype and the datatype.