Part I. Getting started

Table of Contents

Introduction

Features

Architecture

Foreword about abstraction

Variables syntax in SQL

NULL handling when using variables

SQL identifiers

Binary large objects (BLOBs)

Installation

Getting the library

Installing from the sources

Compiling your code using the Libgda library

Configuring

Configuration for development

Configuration for accessing a database

Provider's specific information

Code examples

Initializing

Connecting

Executing queries

Managing data models

Example using random access

Example using an iterator

Freeing data models

Managing transactions

Managing connection's events and errors

Full example

DDL example

Binary large objects (BLOBs) example

Other examples

Migration from 1.X versions

GdaValue and GdaDataModel changes

GdaClient, GdaConnection and GdaError

Various API changes

Migration from 3.X versions

Overview

New unique parser

GdaQuery and GdaCommand merge into GdaStatement

Dictionary changes

Statement execution

Reports

Other changes

Multi threading environment

Configuration management

Database provider's changes

API changes

List of removed objects and interfaces

List of removed functions

Provider's notes

For Oracle

For SQLite

The gda_file_exists() function

The gda_hex_print() function

The gda_hex() function

The gda_rmdiacr() function

The gda_upper() and gda_lower() functions

For SQLCipher

How to create and encrypted database

How to encrypt an existing database

How to change the passphrase of an encrypted database

For LDAP

Limitations

Global limitations

For MySQL

Multi threaded environment

Statements execution

For Oracle

For PostgreSQL

BLOB handling

Last inserted row's values

Multi threaded environment

Statements execution

For SQLite

Last inserted row's values

Date and time

Multi threaded environment

Error reporting

For SqlCipher

For LDAP

User name

SSL/TLS certificate validation

For JDBC based providers

JDBC drivers' location

Last inserted row's values

Multi threaded environment