Portlet Factory, Version 6.1.2

 

Implementing a database transaction

Follow these steps to implement a database transaction.

  1. Make sure you have an SQL DataSource builder call in your model that points to the JNDI database you want to query.

  2. Include an SQL Statement builder in the model to create a statement or stored procedure to run against the database.

  3. Create an XML transform to format the returned ResultSet.

  4. Use the SQL Transaction builder to link together various SQL builder artifacts in the model.

  5. If desired, use an SQL Transform to XML Schema builder to generate a schema for the returned data.

  6. Use the results of the transaction as input to a Data Page builder to create a display page/form that exactly matches the data.

Parent topic: Working with a database

Library | Support |