A transaction is a combination of database related activities that culminates in the display of data returned from a database by a query.
IBM® WebSphere® Portlet Factory provides support for sophisticated database transactions in the form of the "SQL" family of builders. By combining SQL builders in various ways, you can create a complex transaction that runs an SQL statement against a particular JDBC datasource, transforms the ResultSet data returned, builds a schema from the data, and displays the formatted data on a page in your model.
The key to transaction management is the SQL Transaction builder. This builder works in conjunction with other SQL builders to create either a short-lived or a long-lived SQL transaction. Using this builder you can create a list of prepared statements or callable transactions that are execution-ready.
Usually you will want to feed the results of a transaction to a display mechanism to view the results. WebSphere Portlet Factory provides several display options, with the most powerful being the Data Page builder. This builder can automatically create a form that either displays data and/or prompts the user to enter data.
The Data Page builder references a schema (possibly created by the SQL Transform to XML Schema builder) or a variable associated with a schema type, to determine the form fields to display. The Data Page builder can also create input forms based on an element type defined by a schema and an associated variable.
Parent topic: Building an SQL statement