Using SQL Adapters with Ensemble

• About This Book
• About the Ensemble SQL Adapters
• Basic Tools
• Helper Classes
• General Use
• Using the SQL Inbound Adapter
• Overall Behavior
• Creating a Business Service to Use the Adapter
• Implementing the OnProcessInput() Method
• Using the Default Snapshot Object
• Initializing the Adapter
• Adding and Configuring the Business Service
• Specifying the Data Source Name
• Specifying Inbound Queries
• Processing Only New Rows
• Reprocessing Rows
• Examples That Use Query Settings
• Specifying Other Runtime Settings
• Resetting Rows Previously Processed by the Inbound Adapter
• Using the SQL Outbound Adapter
• Default Behavior
• Creating a Business Operation to Use the Adapter
• Creating Methods to Perform SQL Operations
• Handling Multiple SQL Statements per Message
• Adding and Configuring the Business Operation
• Creating Adapter Methods for SQL
• Overview and Context
• Using Parameters
• Executing Queries
• Performing Updates, Inserts, and Deletes
• Executing Stored Procedures
• Specifying Statement Attributes
• Managing Transactions
• Managing the Database Connection
• Using Result Sets
• Creating and Initializing a Result Set
• Getting Basic Information about the Result Set
• Navigating the Result Set
• Examining the Current Row of the Result Set
• Using Snapshots
• Creating a Snapshot
• Getting Basic Information about the Snapshot
• Navigating the Snapshot
• Examining the Current Row of the Snapshot
• Resetting a Snapshot