Hsqldb User Guide

# Hsqldb User Guide

### The HSQLDB Development Group

#### Edited by

### Blaine Simpson

### Fred Toussi

Copyright 2002-2004 HSQLDB Development Group. Permission is granted to distribute this document without any alteration under the terms of the HSQLDB license.

$Date: 2004/07/18 03:48:05 $

List of Tables

1. Alternate formats of this document
4.1. Hsqldb URL Components
4.2. Connection Properties
4.3. Hsqldb Server Properties Files
4.4. Property File Properties
4.5. Server Property File Properties
4.6. WebServer Property File Properties
4.7. Database-specific Property File Properties
8.1. Data Types

List of Examples

1.1. Java code to connect to the local Server above
2.1. Column values which satisfy a 2-column UNIQUE constraint
2.2. Query comparison
2.3. Numbering returned rows of a SELECT in sequential order
3.1. server.properties fragment
3.2. example sqltool.rc stanza
6.1. Exporting certificate from the server's keystore
6.2. Adding a certificate to the client keystore
6.3. Specifying your own trust store to a JDBC client
6.4. Running an Hsqldb server with TLS encryption
6.5. Getting a pem-style private key into a JKS keystore
7.1. Sample sqltool.rc File
7.2. Defining and using an alias (PL variable)
7.3. Piping input into SqlTool
7.4. Valid comment example
7.5. Invalid comment example
7.6. Simple SQL file using PL
7.7. SQL File showing use of most PL features
A.1. Buiding the standard Hsqldb jar file with Ant
A.2. Example source code before CodeSwitcher is run
A.3. CodeSwitcher command line invocation
A.4. Source code after CodeSwitcher processing
B.1. JDBC Client source code example

|  | Introduction