Using Caché with JDBC
Contents
[Home]  [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Preface : 
 
 
Chapter 1: 
  1.1 Installation and Configuration
1.1.1 Java Client Requirements
1.1.2 Caché Server Configuration
1.2 The Caché Java Class Packages
Chapter 2: 
  2.1 Using CacheDataSource to Connect
2.2 Using DriverManager to Connect
2.3 Defining a JDBC Connection URL
2.3.1 Required Parameters
2.3.2 Optional Parameters
2.3.3 Setting the Port Parameter at the Command Line
2.3.4 Alternate Username and Password Parameters
2.4 Using a Connection Pool
2.5 Caché JDBC Connection Properties
2.5.1 Listing Connection Properties
Chapter 3: 
  3.1 A Simple JDBC Application
3.2 Using Statements
3.2.1 Using Statement to Execute a SELECT
3.2.2 Executing a Prepared Statement
3.2.3 Using Callable Statements to Execute Stored Procedures
3.2.4 Returning Multiple Result Sets
3.2.5 Statement Pooling
3.3 Inserting and Updating Data
3.3.1 Inserting Data and Retrieving Generated Keys
3.3.2 Scrolling a Result Set
3.3.3 Updating a Scrollable Result Set
3.3.4 Using Transactions
3.4 Logging for JDBC Applications
3.4.1 Enabling Logging for JDBC
3.4.2 Enabling Logging for the JDBC SQL Gateway
Chapter 4: 
  4.1 Creating JDBC SQL Gateway Connections for External Sources
4.1.1 Creating a JDBC SQL Gateway Connection
4.1.2 Creating a JDBC Connection to Caché via the SQL Gateway
4.1.3 Implementation-specific Options
Chapter 5: 
  5.1 Requirements
5.2 Installation and Configuration
5.2.1 Directories
5.2.2 System Settings
5.2.3 Hibernate Configuration
5.3 Supported Features
5.3.1 Using Hibernate with SQL
5.3.2 Support for Sequences
Chapter 6: 
  6.1 JDBC 4.1 Interfaces and Classes
6.2 The JDBC Core API (java.sql)
6.2.1 java.sql Interfaces
6.2.2 java.sql Classes
6.2.3 java.sql Exceptions
6.3 The JDBC Optional Package API (javax.sql)
6.3.1 javax.sql Interfaces
6.3.2 javax.sql Classes
6.4 Interfaces with Unsupported Optional Methods
6.4.1 CallableStatement — Unsupported Methods
6.4.2 Connection — Unsupported or Restricted Methods
6.4.3 DatabaseMetaData — Variant Methods
6.4.4 Driver — Unsupported Methods
6.4.5 PreparedStatement — Unsupported Methods
6.4.6 ResultSet — Unsupported or Restricted Methods
6.4.7 Statement — Unsupported or Restricted Methods
6.5 Caché JDBC Additions and Extensions
6.5.1 CallableStatement Additional Method
6.5.2 CacheConnectionPoolDataSource
6.5.3 CacheDataSource