Using Caché with JDBC
Contents
 
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

 
Contents

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