|
The JDBC service enables processes to interact with databases.
For example, a process may require that data submitted from a form
populate an internal database or that data from a database prepopulate
a form. The process can contain application logic that binds data
from the form fields to the underlying database. Fields may be mapped
to database columns. Separate line items in a filled form may also
create multiple rows in the database. If a stored procedure that
populates the database already exists, a process can use the stored procedure
to update the data.
A process may also execute a business rule that is dependent
on data stored in a database. For example, if a customer is behind
on payment, the order is not shipped, and the customer is sent an
email reminder. A process can query the database and look up the
status based on the customer ID and create a rule based on this
value.
|
|
|
