Table of Contents

There is also a listing of tables, figures, and captioned examples.

Part I: Introduction




Chapter 1: Product Overview

• 1.1 Definition
• 1.2 Features and Benefits
• 1.2.1 Comprehensive Functionality
• 1.2.2 Consistency Across Different Databases
• 1.2.3 Enhanced Performance
• 1.3 Software Requirements
• 1.3.1 Compatibility
• 1.3.2 Dependencies and Relationships
• 1.3.3 Database Connectivity
• 1.4 Documentation Overview
• 1.4.1 Location of Online Documentation
• 1.5 About This Manual
• 1.5.1 Assumptions
• 1.5.2 Special Conventions
• 1.5.3 Organization of This Manual
• 1.6 Rogue Wave Professional Training
• 1.7 Technical Support
• 1.7.1 Before Contacting Technical Support
• 1.7.2 How to Contact Technical Support

Chapter 2: Design Overview

• 2.1 Basic Architecture
• 2.2 Interface and Implementation Classes
• 2.2.1 Database-Dependent and Database-Independent Interface Classes
• 2.3 Producers and Products
• 2.4 Reference Semantics
• 2.5 Memory Allocation
• 2.6 Information Flow

Chapter 3: Class Overview

• 3.1 Kinds of Classes
• 3.1.1 Datatypes
• 3.1.2 Database Classes
• 3.1.3 Expression Classes
• 3.1.4 Error Reporting and Tracing Classes
• 3.1.5 Open SQL Classes
• 3.1.6 Other DBTools.h++ Classes
• 3.2 Summary of Classes
• 3.3 Member Function Conventions



Part II: Using the Basics




Chapter 4: Using the Database Classes

• 4.1 Introduction
• 4.2 Getting Connected
• 4.3 Managing Connections
• 4.3.1 RWDBDatabase and RWDBConnection
• 4.3.2 Explicit and Implicit Connections
• 4.3.3 Connection Pools
• 4.3.4 Alternatives for Managing Connections
• 4.3.5 Transaction Processing with RWDBConnection
• 4.3.6 Transaction Control and Locking
• 4.4 Tables
• 4.4.1 Database Tables
• 4.4.2 Reading Tables: Class RWDBReader
• 4.4.3 Memory Tables
• 4.4.4 Result Tables
• 4.4.5 Summary
• 4.5 Expressions, Criterions, and Assignments
• 4.6 Selecting Data
• 4.6.1 Selecting Data from a Single Table
• 4.6.2 Joins
• 4.6.3 Outer Joins
• 4.6.4 Ordering and Grouping
• 4.6.5 Aggregates, Expressions, and Functions
• 4.6.6 Self-Joins
• 4.6.7 Subqueries
• 4.6.8 Summary
• 4.7 Inserting Data
• 4.7.1 Inserting Values
• 4.7.2 Inserting with a Selector
• 4.7.3 Inserting with a Reader
• 4.7.4 Getting Results from an Inserter
• 4.7.5 A Note About Connections
• 4.7.6 Summary
• 4.8 Updating Data
• 4.9 Deleting Data
• 4.10 Stored Procedures
• 4.11 Cursors
• 4.12 Summary

Chapter 5: The Error Model

• 5.1 Overview
• 5.2 Checking Status with Class RWDBStatus
• 5.3 Error Handlers
• 5.4 Exceptions
• 5.4.1 A Note on Exception Safety
• 5.5 More About Error Handlers
• 5.5.1 Kinds of Errors
• 5.5.2 Capturing Database-Dependent Information
• 5.6 More About isValid()
• 5.6.1 Defining a Valid Object
• 5.6.2 Making Unusable Objects Usable
• 5.7 Summary

Chapter 6: The Data Model

• 6.1 The Problem of Diverse Datatypes
• 6.2 The DBTools.h++ Solution
• 6.3 The Database Layer
• 6.4 The Internal Storage Layer
• 6.4.1 Class RWDBValue
• 6.5 The Application Layer
• 6.5.1 RWCString
• 6.5.2 RWDBDateTime
• 6.5.3 RWDBDuration
• 6.5.4 RWDBBlob
• 6.5.5 RWDecimalPortable
• 6.6 Summary



Part III: Using Advanced Features




Chapter 7: Bulk Reading and Writing

• 7.1 The Bulk Classes
• 7.2 Example with Bulk and Vector Classes
• 7.3 Example with Bulk Classes and RWDBBlob

Chapter 8: Caching

• 8.1 A Database Client Perspective
• 8.2 Caching with RWDBInserter
• 8.3 Caching with RWDBReader
• 8.4 Restrictions On Caching

Chapter 9: Multithreading

• 9.1 DBTools.h++ and Multithread-Safety
• 9.2 Levels of Multithread Support
• 9.3 Sharing DBTools.h++ Objects Among Threads
• 9.4 Sharing an RWDBConnection
• 9.5 Database-Independent Classes
• 9.6 The Guard Class with Templates
• 9.7 Guard Classes Without Templates
• 9.8 Portable Guard Classes

Chapter 10: Asynchronous Usage

• 10.1 Definition
• 10.2 Architectural Overview
• 10.3 Handling Asynchronous Call Completions
• 10.4 RWDBStatus Behavior in the Asynchronous Context
• 10.5 Asynchronous Usage Example
• 10.6 Handling C++ Datatype Returns from an Asynchronous Call
• 10.7 DBTools.h++ Asynchronous Calls
• 10.7.1 Running Many Asynchronous Calls on a Single RWDBConnection
• 10.7.2 Performance Issues
• 10.8 Asynchronous RWDBReaders

Chapter 11: Internationalization

• 11.1 Definition
• 11.2 Character Sets
• 11.2.1 National Character Sets and C++ Datatypes
• 11.2.2 RWWString
• 11.2.3 RWDBMBString
• 11.2.4 RWCString
• 11.2.5 Data Definition Language
• 11.2.6 Using Schema Information from Result Tables
• 11.3 Data Formatting
• 11.3.1 RWDBDateTime
• 11.3.2 RWDate
• 11.3.3 RWDecimalPortable
• 11.3.4 Formatting Raw Numbers



Part IV: Using Open SQL




Chapter 12: Defining Open SQL

• 12.1 An Alternative API
• 12.2 Who Should Use Open SQL
• 12.3 A Summary of the Open SQL Classes
• 12.4 Open SQL and the Standard API

Chapter 13: Using the Open SQL Classes

• 13.1 Class RWDBOSql
• 13.1.1 Creating an RWDBOSql Instance
• 13.1.2 Providing an SQL Statement
• 13.1.3 Executing the SQL Statement
• 13.1.4 Obtaining the Results
• 13.2 Class RWDBTBuffer<T>
• 13.2.1 Instantiating RWDBTBuffer
• 13.2.2 Memory Management in RWDBTBuffer
• 13.2.3 Output Binding and Fetching Using RWDBTBuffer
• 13.2.4 Using RWDBTBuffers for Input
• 13.2.5 Bulk/Array Input
• 13.3 RWDBMultiRow
• 13.3.1 Using RWDBMultiRow for Ad Hoc Queries
• 13.3.2 Obtaining Data from RWDBMultiRow



Part V: The Tutorials




Chapter 14: Tutorial Overview

• 14.1 Introduction
• 14.2 List of Tutorials
• 14.3 Setting up the Tutorials
• 14.4 The Tutorial Model

Chapter 15: Tutorial One

• 15.1 Goal
• 15.2 Overview
• 15.3 Running the Program
• 15.4 Checking the Output
• 15.5 The Program
• 15.5.1 The Main Routine
• 15.5.2 VVContactRepository Constructor
• 15.5.3 VVContactRepository::mailingLabels
• 15.5.4 operator>>() for VVContact

Chapter 16: Tutorial Two

• 16.1 Goal
• 16.2 Overview
• 16.3 Running the Program
• 16.4 Checking the Output
• 16.5 The Program
• 16.5.1 The Main Routine
• 16.5.2 VVContactRepository::mailingLabels
• 16.5.3 VVContactRepository::reader
• 16.6 Conclusion

Chapter 17: Tutorial Three

• 17.1 Goal
• 17.2 Overview
• 17.3 Running the Program
• 17.4 Checking the Output
• 17.5 The Program
• 17.5.1 The Main Routine
• 17.5.2 VVContactRepository::insert
• 17.5.3 operator<<() for VVContact
• 17.6 Conclusion

Chapter 18: Tutorial Four

• 18.1 Goal
• 18.2 Overview
• 18.3 Running the Program
• 18.4 Checking the Output
• 18.5 The Program
• 18.5.1 The Main Routine
• 18.5.2 VVVideoRepository::updateStock
• 18.6 Conclusion

Chapter 19: Tutorial Five

• 19.1 Goal
• 19.2 Overview
• 19.3 Running the Program
• 19.4 Checking the Output
• 19.5 The Program
• 19.5.1 The Main Routine
• 19.5.2 VVContactRepository::remove
• 19.6 Conclusion

Chapter 20: Tutorial Six

• 20.1 Goal
• 20.2 Overview
• 20.3 Running the Program
• 20.4 Checking the Output
• 20.5 The Program
• 20.5.1 The Main Routine
• 20.6 Conclusion

Chapter 21: Tutorial Seven

• 21.1 Goal
• 21.2 Overview
• 21.3 Running the Program
• 21.4 Checking the Output
• 21.5 The Program
• 21.5.1 The Main Routine
• 21.5.2 VVInvoice::addRental
• 21.5.3 VVVideoRepository::find
• 21.5.4 VVVideoRepository::update
• 21.6 Conclusion



Part 6: Appendices




Appendix A: Error Codes

Appendix B: Bibliography

Appendix C: Change Log

• C.1 Purpose
• C.2 Changes from 3.2 to 4.0
• C.2.1 Summary of Changes
• C.2.2 Tables of Changes

Topic Index