JBoss.orgCommunity Documentation

Teiid - Scalable Information Integration

Teiid Client Developer's Guide

7.0

Copyright © 2009 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
2. Teiid extensions to the JDBC API
2.1. Statement Extensions
2.2. Execution Properties
2.3. Set Statement
2.4. Partial Results Mode
2.5. XML extensions
2.5.1. Document formatting
2.5.2. Schema validation
3. Transactions with JDBC
3.1. Local Transactions
3.1.1. Turning Off Local Transactions
3.2. Request Level Transactions
3.2.1. Multiple Insert Batches
3.3. Using Global Transactions
3.4. Restrictions
3.4.1. Application Restrictions
3.4.2. Enterprise Information System Support
4. SSL Client Connections
4.1. Default Security
4.2. SSL Modes
4.3. Client SSL Settings
4.3.1. Option 1: Java SSL properties
4.3.2. Option 2: Teiid Specific Properties
5. Using Teiid with Hibernate
5.1. Limitations
5.2. Configuration
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