All Manuals > LispWorks User Guide and Reference Manual > 19 Common SQL


19.2 Initialization

The initialization of Common SQL involves three stages. Firstly the SQL interface loaded. Next, the database type (actually class) to be used is initialized. Finally, Common SQL is used to connect to a database. These stages are explained in more detail in this section.

The Lisp symbols introduced in this chapter are exported from the sql package. Application packages requiring convenient access to these facilities should therefore use the sql package.

The examples in this chapter assume that the sql package is visible.

19.2.1 SQL interface

19.2.2 Database classes

19.2.3 Initialization functions and variables

19.2.4 Database libraries

19.2.5 General database connection and disconnection

19.2.6 Connecting to Oracle

19.2.7 Connecting to ODBC

19.2.8 Connecting to MySQL

19.2.9 Connecting to PostgreSQL

19.2.10 Escaping and standard_conforming_strings

LispWorks User Guide and Reference Manual - 21 Dec 2011