2/54

List of Examples

• 1-1 Creating a Table
• 1-2 Specifying Access to a Table
• 1-3 Creating an Object Table
• 1-4 Inserting Data Through Input Bind Variables
• 1-5 Inserting Objects into the Oracle Database
• 1-6 Using the Simple SELECT Statement
• 1-7 Using the SELECT Statement with Input Variables
• 1-8 Using PL/SQL to Obtain an Output Variable
• 1-9 Using PL/SQL to Insert Partial Records into Placeholders
• 1-10 Using SQL to Extract Partial Records
• 2-1 How to Determine the Major Client Version and Set Performance Features
• 2-2 How to Regenerate the Data Shared Library Files
• 2-3 How to set the ORA_TZFILE Environment Variable
• 2-4 Installing Instant Client Light (English) through Oracle Universal Installer
• 3-1 How to Create an OCCI Environment
• 3-2 How to Terminate an OCCI Environment
• 3-3 How to Use Environment Scope with Blob Objects
• 3-4 How to Create an Environment and then a Connection to the Database
• 3-5 How to Terminate a Connection to the Database and the Environment
• 3-6 The createConnectionPool() Method
• 3-7 How to Create a Connection Pool
• 3-8 The createProxyConnection() Method
• 3-9 How to Use a StatelessConnectionPool
• 3-10 How to Create and Use a Homogeneous Stateless Connection Pool
• 3-11 How to Create and Use a Heterogeneous Stateless Connection Pool
• 3-12 How to Administer the Database Resident Connection Pools
• 3-13 How to Get a Connection from a Database Resident Connection Pool
• 3-14 Using Client-Side Pool and Server-Side Pool
• 3-15 How to Create a Statement
• 3-16 How to Create a Database Table Using the executeUpdate() Method
• 3-17 How to Add Records Using the executeUpdate() Method
• 3-18 How to Specify a SQL Statement Using the setSQL() Method
• 3-19 How to Reset a SQL Statement Using the setSQL() Method
• 3-20 How to Terminate a Statement Using the terminateStatement() Method
• 3-21 How to Use setxxx() Methods to Set Individual Column Values
• 3-22 How to Specify the IN Parameters of a PL/SQL Stored Procedure
• 3-23 How to Specify OUT Parameters of a PL/SQL Stored Procedure
• 3-24 How to Bind Data in a Streaming Mode
• 3-25 How to Fetch Data in a Streaming Mode Using PL/SQL
• 3-26 How to Read and Write with Multiple Streams
• 3-27 How to Execute an Iterative Operation
• 3-28 How to Fetch Data in Streaming Mode Using ResultSet
• 3-29 Statement Caching without Connection Pooling
• 3-30 Statement Caching with Connection Pooling
• 4-1 Creating Standalone Objects
• 4-2 Creating Embedded Objects
• 4-3 Two Methods for Operator new() in the Object Type Translator Utility
• 4-4 How to Dynamically Create a Transient Object
• 4-5 How to Create a Transient Object as a Local Variable
• 4-6 How to Create a Persistent Object
• 4-7 How to Create a Transient Object
• 4-8 How to Declare a Custom Type in the Database
• 4-9 How to Create a VARRAY Collection
• 4-10 OTT Support Inheritance
• 4-11 Listing of demo2.sql for a Sample OCCI Application
• 4-12 Listing of demo2.typ for a Sample OCCI Application
• 4-13 Listing of OTT Command that Generates Files for a Sample OCCI Application
• 4-14 Listing of mappings.h for a Sample OCCI Application
• 4-15 Listing of mappings.cpp for a Sample OCCI Application
• 4-16 Listing of demo2.h for a Sample OCCI Application
• 4-17 Listing of demo2.cpp for a Sample OCCI Application
• 4-18 Listing of myDemo.h for a Sample OCCI Application
• 4-19 Listing for myDemo.cpp for a Sample OCCI Application
• 4-20 Listing of main.cpp for a Sample OCCI Application
• 5-1 Definition of the BDOUBLE Data Type
• 5-2 Definition of the BFLOAT Data Type
• 6-1 How to Obtain Metadata About Attributes of a Simple Database Table
• 6-2 How to Obtain Metadata from a Column Containing User-Defined Types
• 6-3 How to Obtain Object Metadata from a Reference
• 6-4 How to Obtain Metadata About a Select List from a ResultSet Object
• 7-1 How to Read Non-Streamed BLOBs
• 7-2 How to Read Non-Streamed BFILESs
• 7-3 How to Read Streamed BLOBs
• 7-4 How to Write Non-Streamed BLOBs
• 7-5 How to Write Streamed BLOBs
• 7-6 Updating a CLOB Value
• 7-7 Updating a BFILE Value
• 7-8 How to Use a Persistent Object with a BLOB Attribute
• 7-9 How to Use a Persistent Object with a BFILE Attribute
• 8-1 How to Use the OTT Utility
• 8-2 Object Creation Statements of the OTT Utility
• 8-3 How to Invoke the OTT Utility to Generate C++ Classes
• 8-4 How to use the SCHEMA_NAMES Parameter in OTT Utility
• 8-5 How to Define a Schema for Unicode Support in OTT
• 8-6 How to Use UNICODE=ALL Parameter in OTT
• 8-7 How to Use UNICODE=ONLYCHAR Parameter in OTT
• 8-8 How to Create a User Defined INTYPE File Using the OTT Utility
• 8-9 Listing of ott95a.h
• 8-10 Listing of ott95b.h
• 8-11 How to Represent Object Attributes Using the OTT Utility
• 8-12 How to Map Object Data Types Using the OTT Utility
• 8-13 OUTTYPE File Generated by the OTT Utility
• 8-14 How to Generate C++ Classes Using the OTT Utility
• 8-15 How to Extend C++ Classes Using the OTT Utility
• 8-16 How to Add User Code to a Header File Using OTT Utility
• 8-17 How to Add User Code to the Source File Using the OTT Utility
• 9-1 How to Use Globalization and Unicode Support
• 9-2 Using wstring Data Type
• 9-3 Binding UTF8 Data Using the string Data Type
• 9-4 Binding UTF16 Data Using the UString Data Type
• 9-5 Using CLOB and NCLOB Data Types
• 10-1 Creating an Agent
• 10-2 Setting the Agent on the Consumer
• 10-3 Creating an AnyData Message with a String Payload
• 10-4 Determining the Type of the Payload in an AnyData Message
• 10-5 Creating an User-defined Payload
• 10-6 Specifying the Correlation identifier
• 10-7 Specifying the Sender identifier
• 10-8 Specifying the Delay and Expiration times of the message
• 10-9 Specifying message recipients
• 10-10 Specifying the Priority of a Message
• 10-11 Creating a Producer, Setting Visibility, and Enqueuing the Message
• 10-12 Creating a Consumer, Naming the Consumer, and Receiving a Message
• 10-13 Receiving a Message
• 10-14 Specifying dequeuing options
• 10-15 Listening for messages
• 10-16 How to Register for Notifications; Direct Registration
• 10-17 How to Use Open Registration with LDAP
• 11-1 How to Use Transaction Managers with XA
• 12-1 How to Enable TAF for Connection Pooling
• 12-2 How to Insert Records Using the addIteration() method
• 12-3 How to Insert Records Using the executeArrayUpdate() Method
• 12-4 How to use Array Fetch with a ResultSet
• 12-5 How to Modify Rows Iteratively and Handle Errors
• 12-6 How to Use ADRCI for OCCI Application Incidents
• 12-7 How to Use ADRCI for Instant Client
• 12-8 How to Enable and Use the Client Result Cache
• 13-1 Converting From an SQL Pre-Defined Type To AnyData Type
• 13-2 Creating an SQL Pre-Defined Type From AnyData Type
• 13-3 Converting From a User-Defined Type To AnyData Type
• 13-4 Converting From a User-Defined Type To AnyData Type
• 13-5 How to Get a Date from Database and Use it in Standalone Calculations
• 13-6 How to Use an Empty IntervalDS Object through Direct Assignment
• 13-7 How to Use an Empty IntervalDS Object Through *Text() Methods
• 13-8 How to Use an Empty IntervalYM Object Through Direct Assignment
• 13-9 How to Use an IntervalYM Object Through ResultSet and toText() Method
• 13-10 How to Retrieve and Use a Number Object
• 13-11 Using Default Timestamp Constructor
• 13-12 Using fromText() method to Initialize a NULL Timestamp Instance
• 13-13 Comparing Timestamps Stored in the Database