JBoss.orgCommunity Documentation

Teiid - Scalable Information Integration

Teiid Client Developer's Guide

7.6

Copyright © 2011 Red Hat, Inc.

Legal Notice
1. Connecting to Teiid Server
1.1. Driver Connection
1.1.1. URL Connection Properties
1.2. Datasource Connection
1.3. Standalone Application
1.3.1. Driver Connection
1.3.2. Datasource Connection
1.4. JBoss AS Data Source
1.4.1. DataSource Connection
1.4.2. Driver based connection
1.4.3. Local JDBC Connection
1.5. Using Multiple Hosts
1.5.1. Fail Over
1.5.2. Load Balancing
1.5.3. Advanced Configuration
1.6. Reauthentication
2. Prepared Statements
3. Teiid extensions to the JDBC API
3.1. Statement Extensions
3.2. Execution Properties
3.3. SET Statement
3.4. SHOW Statement
3.5. Transaction Statements
3.6. Partial Results Mode
3.7. XML extensions
3.7.1. Document formatting
3.7.2. Schema validation
3.8. Non-blocking Statement Execution
4. Transactions with JDBC
4.1. Local Transactions
4.1.1. Turning Off Local Transactions
4.2. Request Level Transactions
4.2.1. Multiple Insert Batches
4.3. Using Global Transactions
4.4. Restrictions
4.4.1. Application Restrictions
4.4.2. Enterprise Information System Support
5. SSL Client Connections
5.1. Default Security
5.2. SSL Modes
5.3. Client SSL Settings
5.3.1. Option 1: Java SSL properties
5.3.2. Option 2: Teiid Specific Properties
6. Using Teiid with Hibernate
6.1. Limitations
6.2. Configuration
7. ODBC Support
7.1. Installing the ODBC Driver Client
7.1.1. Microsoft Windows
7.1.2. Other *nix Platform Installations
7.2. Configuring the Data Source Name (DSN)
7.2.1. Windows Installation
7.2.2. Other *nix Platform Installations
7.3. DSN Less Connection
A. Unsupported JDBC Methods
A.1. ResultSet Limitations
A.2. Unsupported Classes and Methods in "java.sql"
A.3. Unsupported Classes and Methods in "javax.sql"
B. Generating Self Signed Certificate with Keytool
B.1. Creating private/public key pair:
B.2. Extracting the public key
B.3. Creating the Truststore