Using SQL in Productions
- Introduction to SQL Adapters
- Using an SQL Business Service
- Using an SQL Business Operation
- Specifying the Data Source Name
- Specifying a Query
- Specifying Other Runtime Settings
- SQL Procedure Settings
- About Response Messages
- More About Messages
- More About Procedures
- Custom Business Services
- 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
- Processing Only New Rows
- Reprocessing Rows
- Examples That Use Query Settings
- Specifying Other Runtime Settings
- Resetting Rows Previously Processed by the Inbound Adapter
- Custom Business Operations
- 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