CSQL Programmer's Guide - Table of Contents
1. Before You Start
1.1. What Is CSQL
1.2. CSQL Components
1.2.1. CSQL Main Memory Database
1.2.2. CSQL Cache
1.2.3. CSQL Replication
1.3. Information In This Guide
2. Client Application
2.1. What Is Client?
2.2. Passing Query To The Server
2.3. Supported Interfaces
3. SQLAPI (Proprietary Interface)
3.1. What Is SQL API
3.2. libcsqlcsql – C++ Library
3.3. Important Classes And Header Files
3.4. Error Handling Enum
3.5. Data Type
3.6. Connect To Database
3.7. Create And Set The Statement For The Connection
3.8. Create Table
3.8.1. Prepare Statement
3.8.2. Execute Statement And Release Memory
3.9. Insert Records Into The Table
3.9.1. Prepare Statement
3.9.2. Start Transaction
3.9.3. Parameterize Fields
3.9.4. Execute Insert Statement
3.9.5. Commit Transaction
3.10. Read Records From Table
3.10.1. Read Records
3.10.2. Prepare The Statement
3.10.3. Bind Fields
3.10.4. Begin Transaction and Execute the Statement
3.10.5. Fetch Records
3.11. UPDATE Records
3.12. DELETE Records
3.13. Sample Programs
3.13.1. Connect AND Disconnect - CSQL
3.13.2. INSERT And SELECT
3.13.3. UPDATE And SELECT
3.13.4. DELETE
4. ODBC And CSQL
4.1. Header Files And Library
4.2. Data Types
4.2.1. Type Identifiers
4.2.2. SQL Data Types
4.2.3. C Data Types
4.3. Function Return Codes
4.4. Handles
4.4.1. Environment
4.4.2. Connection
4.4.3. Statement
4.5. Connect To Database
4.5.1. ALLOCATE Environment Handle
4.5.2. Setting Up Driver Version
4.5.3. Allocate Connection Handle
4.5.4. Ways To Connect To Database
4.5.4.1. SQLCONNECT
4.5.4.2. SQLDRIVERCONNECT
4.6. Disconnect From Database
4.6.1. Free Connection Handle And Environment Handle
4.6.2. A Sample Program For Connect And Disconnect To The Database
4.7. Using ODBC TO SQL
4.7.1. Creating And Dropping Table
4.7.2. Sample Program For Create And Drop The Table
4.7.3. Data Manipulation
4.7.3.1. Using SQLPREPARE And SQLEXECUTE
4.7.3.2. Using SQLBINDPARAMETER Function
4.7.3.3. Committing Transaction
4.7.3.4. Simple Program For Insert
4.7.3.5. UPDATE
4.7.3.6. DELETE
4.7.4. Retrieving Records
4.7.4.1. SQLBINDCOL, SQLFETCH & SQLCLOSECURSOR Function
4.7.4.2. A Sample Program For SELECT
4.7.5. Closing Transaction Using COMMIT And ROLLBACK
5. CSQL And JDBC
5.1. Overview Of JDBC
5.2. Background
5.3. What Is JDBC Driver
5.4. Classes, Interfaces And Methods
5.4.1. Interfaces
5.4.2. Classes
5.4.3. Exception Classes
5.5. Data Types
5.6. Using CSQL JDBC Driver
5.6.1. Getting Started
5.6.2. Setting Up The CLASSPATH
5.6.3. Setting The Development Environment
5.6.4. Loading The Driver
5.6.5. Connection To Database
5.6.6. Closing Connection
5.7. Running SQL Statements With JDBC
5.7.1. CREATE And DROP
5.7.2. INSERT
5.7.3. SELECT (Using ResultSet Interface)
5.7.4. UPDATE
5.7.5. DELETE
5.8. Transaction And AUTOCOMMIT Mode
5.9. Code Examples
6. Squirrel SQL Client: Open Source Front End To Interact With CSQL Database
6.1. What Is Squirrel SQL Client?
6.2. Prerequisites
6.2.1. Supported JAVA Version
6.2.2. Download
6.2.3. Installing & Invoking Squirrel
6.3. Starting Squirrel
6.3.1. Setting Environmental Variables And CLASSPATH
6.3.2. Open Squirrel Client
6.4. Create Driver In Squirrel
6.5. Create New Alias
6.6. Accessing Database
7. Netbeans IDE Configuration For JDBC Driver
7.1. Connectin Through DriverManager
7.1.1. CLASSPATH Setting - Run Application
7.2. Connection Through Data Source
7.2.1. CLASSPATH Setting - Run Application
7.2.2. Connection Pool
8. Developing CSQL Java Application With Eclipse IDE
8.1. Overview
8.2. Preliminary Setup
8.3. Configuring Eclipse
8.4. Creating Application And Accessing Database Data
Appendix
CSQL ODBC API Reference