Databases Reference
In-Depth Information
The
Operation Type
splits into two groups, calls into the database and events
generated from the database. Calls into the database cover the following operations:
•
The stored procedure or function call to execute a specific piece of code in the
database. This could either update the database or retrieve information, but
in either case, it is a synchronous call into the database.
Perform an insert, update, delete, or select operation on the database. Again,
this is done synchronously as a call into the database.
Poll for new or changed records in a database table. This is done as a call into
the SCA Assembly or BPEL.
Execute custom SQL. This again runs the SQL synchronously against
the database.
•
•
•
Polling for new or changed records is the only way for the database adapter to
generate messages to be consumed in a BPEL process or an SCA Assembly. If we
wish the adapter to wait for BPEL or the SCA Assembly to process the message, then
we can use the
Do Synchronous Post to BPEL
checkbox. For this exercise, we will
select insert / update for the operation.
Identifying tables to be operated on
The next step in the wizard asks which table is the root table or the beginning of the
query. To select this, we first click the
Import Tables…
button to bring up the
Import
Tables
dialog.
Once we have imported the tables we need, we then select the
PAYROLLITEM
table
as the root table. We do this because each record will create a new
PAYROLLITEM
entry. All operations through the database adapter must be done with a root table.
Any other table must be referenceable from this root table.
