UnityJDBC User Documentation


Table of Contents

1. General Information
Overview of UnityJDBC
2. Installation
Overview
System Requirements
Quick Setup and Installation
Installation Walkthrough
Configuring Data Sources
3. Using SourceBuilder - Tutorial on Multiple Database Querying
Using the Sample Databases
Data Virtualization Using SourceBuilder
Multiple Database Virtualization and Querying for HSQLDB
Multiple Database Virtualization and Querying for IBM DB2
Multiple Database Virtualization and Querying for Microsoft SQL Server
Multiple Database Virtualization and Querying for MySQL
Multiple Database Virtualization and Querying for Oracle
Multiple Database Virtualization and Querying for PostgreSQL
Multiple Database Virtualization and Querying for Sybase
Multiple Database Virtualization and Querying for MongoDB
Multiple Database Virtualization and Querying for Other JDBC/ODBC Sources
4. Multiple Database Programming with UnityJDBC
Using the Sample Programs
Using ExampleQuery.java
Using ExampleUpdate.java
Using ExampleMetadata.java
Using ExampleEngine.java
Using ExampleNoFileConnection.java
5. Using UnityJDBC with Query and Reporting Software
UnityJDBC Data Virtualization with SQuirreL SQL
UnityJDBC Data Virtualization with JasperReports
UnityJDBC Data Virtualization with Aqua Data Studio
UnityJDBC Data Virtualization with RazorSQL
6. Supported SQL Syntax
Overview
Data Types
Identifiers
Functions and Operators
Logical Operators
Comparison Operators
Arithmetic Functions and Operators
String Functions
Pattern Matching Operators
Data Type Conversion Functions
Date/Time Functions and Operators
Aggregate Functions
User-Defined Functions and Support for Other Functions
Function Translation
Non-parsed Functions
SELECT Statement
INSERT Statement
UPDATE Statement
DELETE Statement
EXPLAIN Statement
By-Pass Statement
7. Supported JDBC Methods
Overview
8. UnityJDBC Driver Internals
Overview
Embedded Relational Database Engine
9. History and Planned Features
History of UnityJDBC
Planned Features
Feature List
Contacts and Support

List of Tables

6.1. Comparison Operators
6.2. Mathematical Operators
6.3. Mathematical Functions
6.4. String Functions
6.5. Date Functions
6.6. Aggregate Functions
9.1. UnityJDBC Release History
9.2. Planned Features in Coming Versions
9.3. UnityJDBC Feature List