SelectingDatafromaDatabase.PDF

Adobe Enterprise Technical Enablement Selecting Data from a Database In this topic, you will learn about the Query Single Row operation and how it is used to interact with databases. Objectives After completing this unit, you should be able to ? Use the Query Single Row operation to select data from a database Concepts In this topic, you will learn about the following concepts ? Selecting database data Copyright ? 2011 Adobe Systems Incorporated 1 Selecting database data ? The JDBC service offers two operations to select database data ■ Query Single Row ■ Query Multiple Rows as XML Query Single Row operation ? The Query Single Row operation queries the database using a SQL statement and saves the first row of the result set ■ Located in Foundation JDBC - 1.0 Figure 1: Locating the Query Single Row operation of the JDBC service Setting Query Single Row operation properties ? When a Query Single Row operation is added to a process, the following properties can be defined in the Properties view ■ Datasource Name – literal value or variable – corresponds to the JNDI name configured for the data source – formatted with a ‘java:/’ prefix ? java:/adobeTraining ■ SQL Statement - the SQL statement to execute on the database server 2 Copyright ? 2011 Adobe Systems Incorporated ■ Data Mapping – the locations in the process data model to use for saving the data in the first row of the query result set – Specified through the SQL Results Mapping Editor Figure 2: Query Single Row properties