Connection and Initialisation

This section describes the CLSQL interface for initialising database interfaces of different types, creating and destroying databases and connecting and disconnecting from databases.

Table of Contents

DATABASE — The super-type of all CLSQL databases
*CONNECT-IF-EXISTS* — Default value for the if-exists parameter of connect.
*DB-POOL-MAX-FREE-CONNECTIONS* — How many free connections should the connection pool try to keep.
*DEFAULT-DATABASE* — The default database object to use.
*DEFAULT-DATABASE-TYPE* — The default database type to use
*INITIALIZED-DATABASE-TYPES* — List of all initialized database types
CONNECT — create a connection to a database.
CONNECTED-DATABASES — Return the list of active database objects.
DATABASE-NAME — Get the name of a database object
DATABASE-NAME-FROM-SPEC — Return the database name string corresponding to the given connection specification.
DATABASE-TYPE — Get the type of a database object.
DISCONNECT — close a database connection
DISCONNECT-POOLED — closes all pooled database connections
FIND-DATABASE — >Locate a database object through it's name.
INITIALIZE-DATABASE-TYPE — Initializes a database type
RECONNECT — Re-establishes the connection between a database object and its RDBMS.
STATUS — Print information about connected databases.
CREATE-DATABASE — create a database
DESTROY-DATABASE — destroys a database
PROBE-DATABASE — tests for existence of a database
LIST-DATABASES — List databases matching the supplied connection spec and database type.
WITH-DATABASE — Execute a body of code with a variable bound to a specified database object.
WITH-DEFAULT-DATABASE — Execute a body of code with *default-database* bound to a specified database.