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 SELECT with getUb8RowCount(); simple
3-30 SELECT with getUb8RowCount(); with prefetch
3-31 SELECT with getUb8RowCount(); array fetch with prefetch
3-32 INSERT with getUb8RowCount(); simple
3-33 INSERT with getUb8RowCount(); with iterations
3-34 UPDATE with getUb8RowCount()
3-35 Statement Caching without Connection Pooling
3-36 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 use Identity Column Metadata
6-2 How to Obtain Metadata About Attributes of a Simple Database Table
6-3 How to Obtain Metadata from a Column Containing User-Defined Types
6-4 How to Obtain Object Metadata from a Reference
6-5 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

Page 2 of 54