Go to main content
1/10
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introducing Data Services for Client Applications
1.1
Introduction
1.2
What Is a Data Service?
1.3
What is an Oracle Data Service Integrator Client Application?
1.4
Choosing a Client Programming Model
1.5
Introducing Service Data Objects (SDO)
1.6
Introducing the Data Service Mediator API
1.7
Typical Client Application Development Process
1.8
Security Considerations in Client Applications
1.9
Performance Considerations
1.10
Client Classpath Settings
1.10.1
Java Mediator API Clients
1.10.2
Web Services Clients
1.10.3
JMX Mbean Management API Client Classpath
1.10.4
Oracle Data Service Integrator JDBC API Client Classpath
2
Data Programming Model and Update Framework
2.1
Introduction
2.2
Oracle Data Service Integrator and SDO
2.2.1
Static and Dynamic Data Object APIs
2.2.1.1
Static Data Object API
2.2.1.2
XML Schema-to-Java Type Mapping Reference
2.2.1.3
Dynamic Data Object API
2.3
Role of the Mediator API and SDO
3
Invoking Data Services from Java Clients
3.1
Introducing the Mediator API
3.1.1
What is SDO?
3.1.2
What is the Mediator API?
3.1.3
Dynamic and Static Mediator APIs
3.1.4
API Overview
3.1.5
Summary
3.2
Getting Started
3.2.1
Basic Steps
3.2.2
Setting the CLASSPATH
3.2.2.1
Adding the Oracle Data Service Integrator Client Library
3.2.2.2
Manually Setting the CLASSPATH
3.2.2.3
Specifying the Class Loader Directly
3.2.3
Running the Sample Applications
3.3
Sample Static Mediator Application
3.3.1
Setting Up the Sample Data Service
3.3.2
Generating the Mediator Client JAR File
3.3.3
Setting Up the Java Project
3.3.4
Running and Testing the Code
3.3.5
Examining the Sample Code
3.3.5.1
Importing Packages
3.3.5.2
Obtaining a Data Access Service Handle
3.3.5.3
Retrieving Data from the Service
3.3.5.4
Obtaining a DataObject from the Result
3.3.5.5
Disposing the Result Object
3.3.5.6
Modifying the DataObject
3.3.5.7
Returning Changes to the Server
3.4
Sample Dynamic Mediator Application
3.4.1
Setting Up and Running the Sample Code
3.4.2
Sample Java Client Code (Dynamic Mediator API)
3.4.3
Examining the Sample Code
3.4.3.1
Importing Classes
3.4.3.2
Obtaining a DataAccessService Handle
3.4.3.3
Retrieving Data from the Service
3.4.3.4
Obtaining a DataObject from the Result
3.4.3.5
Disposing the Result Object
3.4.3.6
Modifying the DataObject
3.4.3.7
Returning Changes to the Server
3.5
Creating New DataObjects
3.5.1
Creating a New DataObject with the Static API
3.5.1.1
Setting Up and Running the Sample
3.5.1.2
Importing Packages
3.5.1.3
Obtaining a Data Access Service Handle
3.5.1.4
Creating a DataFactory
3.5.1.5
Create and Name the DataObject
3.5.1.6
Modifying the DataObject
3.5.1.7
Returning New DataObject to the Server
3.5.1.8
Returning the New DataObject Key
3.5.2
Creating a New DataObject with the Dynamic API
3.5.2.1
Running the Sample
3.5.2.2
Importing Packages
3.5.2.3
Creating a DataFactory
3.5.2.4
Create and Name the DataObject
3.5.2.5
Modifying the DataObject
3.5.2.6
Returning New DataObject to the Server
3.5.2.7
Returning the New DataObject Key
3.6
Mediator API Basics
3.6.1
Beyond the Sample Applications
3.6.2
More on the Static Mediator API
3.6.3
More on the Dynamic Mediator API
3.6.3.1
Invoking Data Service Operations
3.6.3.2
Getters and Setters
3.6.4
Naming Conventions for Generated Classes
3.6.4.1
Mediator Client JAR Naming Convention
3.6.4.2
Web Services Mediator Client JAR Naming Convention
3.6.5
Understanding DASResult
3.6.5.1
Overview of DASResult
3.6.5.2
Disposing of DASResult Objects
3.6.5.3
Dynamic Mediator APIs and DASResult
3.6.5.4
Static Mediator APIs and DASResult
3.6.5.5
Retrieving an Array of Objects
3.6.6
Obtaining the WebLogic JNDI Context for Oracle Data Service Integrator
3.6.7
Working with Data Objects
3.6.7.1
Enabling Data Objects for Change Tracking
3.6.7.2
Modifying Data Object Properties
3.6.7.3
Creating a New Data Object
3.7
Mapping Data Service Types to Java Types
3.7.1
Conversion of Simple Types
3.7.2
Conversion of Date/Time Types
3.7.3
Passing Empty Sequence Arguments
3.7.4
Quantified Return Types
3.7.5
What is Autoboxing?
3.7.6
Support for Derived Simple Types
3.7.6.1
Mapping Derived Schema Types to Java Types
3.8
Web Services Support
3.9
Advanced Topics
3.9.1
Schema Management
3.9.1.1
Schema Scope
3.9.1.2
Schema Download
3.9.1.3
Schema Cache Management
3.9.2
Support for Stateless Operations
3.9.3
Cache Management
3.9.3.1
Forcing Data Cache Read-through and Update
3.9.4
Specifying XPath Expressions as Arguments
3.9.5
Making Ad Hoc Queries
3.10
Understanding Transaction Behavior
3.10.1
Transaction Behavior for Read/Write Operations
3.10.2
Transaction Behavior for Read-Only Operations
4
Invoking Data Services Through Web Services
4.1
Overview
4.2
Before You Begin
4.3
Getting Started
4.3.1
Basic Steps
4.3.2
Setting the CLASSPATH
4.3.2.1
Adding the Oracle Data Service Integrator Client Library
4.3.2.2
Manually Setting the CLASSPATH
4.3.3
Running the Sample Applications
4.4
Sample Static Mediator Application
4.4.1
Setting Up the Sample Data Service
4.4.2
Creating a Web Service Map File
4.4.3
Generating the Web Services Mediator Client JAR File
4.4.4
Setting Up the Java Project
4.4.5
Running and Testing the Code
4.4.6
Examining the Sample Code
4.4.6.1
Importing Packages
4.4.6.2
Obtaining a Data Access Service Handle
4.4.6.3
Retrieving Data from the Service
4.4.6.4
Obtaining a DataObject from the Result
4.4.6.5
Disposing the Result Object
4.4.6.6
Modifying the DataObject
4.4.6.7
Returning Changes to the Server
4.5
Sample Dynamic Mediator Application
4.5.1
Setting Up and Running the Sample Code
4.5.2
Sample Java Client Code (Dynamic Mediator API)
4.5.3
Examining the Sample Code
4.5.3.1
Importing Classes
4.5.3.2
Obtaining a DataAccessService Handle
4.5.3.3
Retrieving Data from the Service
4.5.3.4
Obtaining a DataObject from the Result
4.5.3.5
Disposing the Result Object
4.5.3.6
Modifying the DataObject
4.5.3.7
Returning Changes to the Server
4.6
Transaction Behavior and Web Services
4.7
Securing Your Web Services Application
5
Using SQL to Access Data Services
5.1
Introducing SQL Access to Data Services
5.1.1
Features of the Oracle Data Service Integrator JDBC Driver
5.1.2
Exploring Oracle Data Service Integrator and JDBC Artifacts
5.2
JDBC and SQL Support in Oracle Data Service Integrator
5.2.1
JDBC Support
5.2.2
SQL Support
5.2.2.1
Supported SQL Statements
5.2.2.2
Supported SQL Functions
5.2.2.3
Numeric Functions
5.2.2.4
String Functions
5.2.2.5
Datetime Functions
5.2.2.6
Aggregate Functions
5.2.3
JDBC Metadata Search Patterns
5.2.3.1
Table Parameter Support
5.2.4
Additional Details and Limitations
5.3
Preparing to Use SQL to Access Data Services
5.3.1
Publishing Data Service Operations
5.3.2
Configuring the Oracle Data Service Integrator JDBC Driver
5.4
Accessing Data Services Using SQL From a Java Application
5.4.1
Obtaining a Connection
5.4.1.1
Using the PreparedStatement Interface
5.4.1.2
Using the CallableStatement Interface
5.5
Advanced Features
5.5.1
Using Table Parameters
5.5.1.1
When to Use Table Parameters
5.5.1.2
Setting Table Parameters Using JDBC
5.5.2
Accessing Custom Database Functions Using JDBC
5.6
Accessing Data Services Using SQL-Based Applications
5.6.1
Accessing Data Services Using SQL Explorer
5.6.2
Connecting to the Oracle Data Service Integrator Client Using OpenLink ODBC-JDBC Bridge
5.6.3
Using OpenLink with Reporting Tools
5.6.3.1
Microsoft Access 2003-ODBC
5.6.3.2
Microsoft Excel 2003-ODBC
6
Supporting ADO.NET Clients
6.1
Overview of ADO.NET Integration in Oracle Data Service Integrator
6.1.1
Understanding ADO.NET
6.1.1.1
ADO.NET Client Application Development Tools
6.1.2
Understanding How Oracle Data Service Integrator Supports ADO.NET Clients
6.1.3
Supporting Java Clients
6.1.4
Enabling Oracle Data Service Integrator Support for ADO.NET Clients
6.1.5
Generating an Oracle Data Service Integrator Web Services Mapper
6.1.6
Viewing an ADO.NET-Enabled WSDL
6.1.7
Creating a Web Reference in ADO.NET Client by Providing the Oracle Data Service Integrator WSDL URL
6.2
Adapting Oracle Data Service Integrator XML Types (Schemas) for ADO.NET Clients
6.2.1
Approaches to Adapting XML Types for ADO.NET
6.2.1.1
XML Type Requirements for Working With ADO.NET DataSets
6.2.2
References
6.3
Creating a Data Service Based on an RPC-Style Web Service
6.4
Generated Artifacts Reference
6.4.1
XML Schema Definition for ADO.NET Types DataSet
6.4.2
Web Services Description Language (WSDL) File for Microsoft ADO.NET Clients
7
Advanced Topics
7.1
Accessing Metadata Using Catalog Services
7.1.1
Installing Catalog Services
7.1.2
Using Catalog Services
7.1.2.1
Application (application.ds)
7.1.2.2
DataService (DataService.ds)
7.1.2.3
DataServiceRef (DataServiceRef.ds)
7.1.2.4
Folder (folder.ds)
7.1.2.5
Function (Function.ds)
7.1.2.6
Relationship (Relationship.ds)
7.1.2.7
Schema (Schema.ds)
7.2
Filtering, Sorting, and Fine-tuning Query Results
7.2.1
Introducing the Filter API
7.2.1.1
addFilter()
7.2.1.2
createFilter()
7.2.1.3
addOrderBy()
7.2.1.4
setLimit()
7.2.1.5
Exploring the Filter Operators
7.2.2
Using Filters
7.2.3
Filtering Examples
7.2.3.1
Specifying a Compound Filter
7.2.3.2
Ordering and Truncating Data Service Results
7.2.4
Using Ad Hoc Queries to Fine-tune Results from the Client
7.3
Using Inverse Functions to Improve Query Performance
7.3.1
The Inverse Function Solution
7.3.1.1
Understanding Invertible Functions
7.3.2
How Inverse Functions Can Improve Performance
7.3.2.1
A Closer Look
7.3.3
Examining the Inverse Functions Sample
7.3.3.1
Creating the Underlying Java Functions
7.3.3.2
Creating the Physical Data Services Based on the Functions
7.3.3.3
Configuring the Inverse Functions
7.3.3.4
Associating Custom Conditional Logic with Functions
7.3.3.5
Creating the Data Service
7.3.4
How To Set Up the Inverse Functions Sample
7.3.4.1
Requirements
7.3.4.2
Importing the Dataspace Project
7.3.4.3
Assigning a Targeted Runtime
7.3.5
Exploring the Inverse Functions Sample
7.3.5.1
Exploring the Projects
Scripting on this page enhances content navigation, but does not change the content in any way.