Sophie: hsqldb-manual-1:1.8.1.3-4.1.mga1 noarch

hsqldb-manual-1.8.1.3-4.1.mga1.noarch.rpm

<html><head><META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><title>Hsqldb User Guide</title><link href="guide.css" rel="stylesheet" type="text/css"><meta content="DocBook XSL Stylesheets V1.65.1" name="generator"><meta name="keywords" content="Hsqldb, Hypersonic, Database, JDBC, Java"><link rel="home" href="index.html" title="Hsqldb User Guide"><link rel="next" href="pr01.html" title="Introduction"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table summary="Navigation header" width="100%"><tr><th align="center" colspan="3">Hsqldb User Guide</th></tr><tr><td align="left" width="20%">&nbsp;</td><th align="center" width="60%">&nbsp;</th><td align="right" width="20%">&nbsp;<a accesskey="n" href="pr01.html"><img src="navicons/next.gif" alt="Next"></a></td></tr></table><hr></div><div class="book" lang="en"><div class="titlepage"><div><div><h1 class="title"><a name="N10002"></a>Hsqldb User Guide</h1></div><div><div class="authorgroup"><h3 class="corpauthor">The HSQLDB Development Group</h3><h4 class="editedby">Edited by</h4><h3 class="editor"><span class="firstname">Blaine</span> <span class="surname">Simpson</span></h3><h3 class="editor"><span class="firstname">Fred</span> <span class="surname">Toussi</span></h3></div></div><div><div class="legalnotice"><p>
            Copyright 2002-2007 HSQLDB Development Group.
            Permission is granted to distribute this document without any 
            alteration under the terms of the HSQLDB license.
        </p></div></div><div><p class="pubdate">$Date: 2007/08/25 23:02:52 $</p></div></div><div></div><hr></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="preface"><a href="pr01.html">Introduction</a></span></dt><dd><dl><dt><span class="section"><a href="pr01.html#N1003A">Available formats for this document</a></span></dt></dl></dd><dt><span class="chapter"><a href="ch01.html">1. Running and Using Hsqldb</a></span></dt><dd><dl><dt><span class="section"><a href="ch01.html#N1009E">Introduction</a></span></dt><dt><span class="section"><a href="ch01.html#N100B7">Running Tools</a></span></dt><dt><span class="section"><a href="ch01.html#N100F3">Running Hsqldb</a></span></dt><dt><span class="section"><a href="ch01.html#N1013D">Server Modes</a></span></dt><dd><dl><dt><span class="section"><a href="ch01.html#N10148">Hsqldb Server</a></span></dt><dt><span class="section"><a href="ch01.html#N10157">Hsqldb Web Server</a></span></dt><dt><span class="section"><a href="ch01.html#N10168">Hsqldb Servlet</a></span></dt><dt><span class="section"><a href="ch01.html#N101A8">In-Process (Standalone) Mode</a></span></dt><dt><span class="section"><a href="ch01.html#N101CA">Memory-Only Databases</a></span></dt></dl></dd><dt><span class="section"><a href="ch01.html#N101D8">General</a></span></dt><dd><dl><dt><span class="section"><a href="ch01.html#N101DB">Closing the Database</a></span></dt><dt><span class="section"><a href="ch01.html#N101E6">Using Multiple Databases in One JVM</a></span></dt><dt><span class="section"><a href="ch01.html#N101EF">Creating a New Database</a></span></dt></dl></dd><dt><span class="section"><a href="ch01.html#N10202">Using the Database Engine</a></span></dt><dd><dl><dt><span class="section"><a href="ch01.html#N1023C">Different Types of Tables</a></span></dt><dt><span class="section"><a href="ch01.html#N10255">Constraints and Indexes</a></span></dt><dt><span class="section"><a href="ch01.html#N10268">SQL Support</a></span></dt><dt><span class="section"><a href="ch01.html#N10281">JDBC Support</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="ch02.html">2. SQL Issues</a></span></dt><dd><dl><dt><span class="section"><a href="ch02.html#N102AE">Purpose</a></span></dt><dt><span class="section"><a href="ch02.html#N102B3">SQL Standard Support</a></span></dt><dt><span class="section"><a href="ch02.html#N102D3">Constraints and Indexes</a></span></dt><dd><dl><dt><span class="section"><a href="ch02.html#N102D6">Primary Key Constraints</a></span></dt><dt><span class="section"><a href="ch02.html#N102DF">Unique Constraints</a></span></dt><dt><span class="section"><a href="ch02.html#N1030E">Unique Indexes</a></span></dt><dt><span class="section"><a href="ch02.html#N10318">FOREIGN KEYS</a></span></dt><dt><span class="section"><a href="ch02.html#N1033B">Indexes and Query Speed</a></span></dt><dt><span class="section"><a href="ch02.html#N10372">Where Condition or Join</a></span></dt><dt><span class="section"><a href="ch02.html#N103A6">Subqueries and Joins</a></span></dt></dl></dd><dt><span class="section"><a href="ch02.html#N103BF">Types and Arithmetic Operations</a></span></dt><dd><dl><dt><span class="section"><a href="ch02.html#N103D6">Integral Types</a></span></dt><dt><span class="section"><a href="ch02.html#N10426">Other Numeric Types</a></span></dt><dt><span class="section"><a href="ch02.html#N1045F">Bit and Boolean Types</a></span></dt><dt><span class="section"><a href="ch02.html#N1047A">Storage and Handling of Java Objects</a></span></dt><dt><span class="section"><a href="ch02.html#N10499">Type Size, Precision and Scale</a></span></dt></dl></dd><dt><span class="section"><a href="ch02.html#N104AE">Sequences and Identity</a></span></dt><dd><dl><dt><span class="section"><a href="ch02.html#N104B3">Identity Auto-Increment Columns</a></span></dt><dt><span class="section"><a href="ch02.html#N104E1">Sequences</a></span></dt></dl></dd><dt><span class="section"><a href="ch02.html#N104FC">Issues with Transactions</a></span></dt><dt><span class="section"><a href="ch02.html#N10521">New Features and Changes</a></span></dt></dl></dd><dt><span class="chapter"><a href="ch03.html">3. UNIX Quick Start</a></span></dt><dd><dl><dt><span class="section"><a href="ch03.html#N10553">Purpose</a></span></dt><dt><span class="section"><a href="ch03.html#N1055A">Installation</a></span></dt><dt><span class="section"><a href="ch03.html#instance_setup-section">Setting up Database Instance and Server</a></span></dt><dt><span class="section"><a href="ch03.html#N106CC">Accessing your Database</a></span></dt><dt><span class="section"><a href="ch03.html#N10737">Create additional Accounts</a></span></dt><dt><span class="section"><a href="ch03.html#N10751">Shutdown</a></span></dt><dt><span class="section"><a href="ch03.html#N1075E">Running Hsqldb as a System Daemon</a></span></dt><dd><dl><dt><span class="section"><a href="ch03.html#N10775">
                Portability of hsqldb init script
            </a></span></dt><dt><span class="section"><a href="ch03.html#N10780">Init script Setup Procedure</a></span></dt><dt><span class="section"><a href="ch03.html#initscriptTrouble-section">
                Troubleshooting the Init Script
            </a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="ch04.html">4. Advanced Topics</a></span></dt><dd><dl><dt><span class="section"><a href="ch04.html#N108C9">Purpose</a></span></dt><dt><span class="section"><a href="ch04.html#N108D2">Connections</a></span></dt><dd><dl><dt><span class="section"><a href="ch04.html#N109E6">Connection properties</a></span></dt></dl></dd><dt><span class="section"><a href="ch04.html#N10A68">Properties Files</a></span></dt><dd><dl><dt><span class="section"><a href="ch04.html#N10AC1">Server and Web Server Properties</a></span></dt><dt><span class="section"><a href="ch04.html#N10BBC">Starting a Server from your application</a></span></dt><dt><span class="section"><a href="ch04.html#N10BCF">Individual Database Properties</a></span></dt></dl></dd><dt><span class="section"><a href="ch04.html#N10D67">SQL Commands for Database Properties</a></span></dt></dl></dd><dt><span class="chapter"><a href="ch05.html">5. Deployment Issues</a></span></dt><dd><dl><dt><span class="section"><a href="ch05.html#N10DCD">Purpose</a></span></dt><dt><span class="section"><a href="ch05.html#N10DD6">Mode of Operation and Tables</a></span></dt><dd><dl><dt><span class="section"><a href="ch05.html#N10DDB">Mode of Operation</a></span></dt><dt><span class="section"><a href="ch05.html#N10DED">Tables</a></span></dt><dt><span class="section"><a href="ch05.html#N10E04">Large Objects</a></span></dt><dt><span class="section"><a href="ch05.html#N10E15">Deployment context</a></span></dt></dl></dd><dt><span class="section"><a href="ch05.html#N10E21">Memory and Disk Use</a></span></dt><dd><dl><dt><span class="section"><a href="ch05.html#N10E3E">Cache Memory Allocation</a></span></dt></dl></dd><dt><span class="section"><a href="ch05.html#N10E5F">Managing Database Connections</a></span></dt><dt><span class="section"><a href="ch05.html#N10E76">Upgrading Databases</a></span></dt><dd><dl><dt><span class="section"><a href="ch05.html#upgrade_via_script-section">Upgrading Using the SCRIPT
      Command</a></span></dt><dt><span class="section"><a href="ch05.html#N10ECE">Manual Changes to the .script File</a></span></dt></dl></dd><dt><span class="section"><a href="ch05.html#N10F02">Backing Up Databases</a></span></dt></dl></dd><dt><span class="chapter"><a href="ch06.html">6. Text Tables</a></span></dt><dd><dl><dt><span class="section"><a href="ch06.html#N10F46">The Implementation</a></span></dt><dd><dl><dt><span class="section"><a href="ch06.html#N10F49">Definition of Tables</a></span></dt><dt><span class="section"><a href="ch06.html#N10F58">Scope and Reassignment</a></span></dt><dt><span class="section"><a href="ch06.html#N10F73">Null Values in Columns of Text Tables</a></span></dt><dt><span class="section"><a href="ch06.html#N10F7F">Configuration</a></span></dt><dt><span class="section"><a href="ch06.html#disconnecting_text_tables">Disconnecting Text Tables</a></span></dt></dl></dd><dt><span class="section"><a href="ch06.html#N1104D">Text File Issues</a></span></dt><dt><span class="section"><a href="ch06.html#N11075">Text File Global Properties</a></span></dt><dt><span class="section"><a href="ch06.html#N110B3">Importing from a Text Table file</a></span></dt></dl></dd><dt><span class="chapter"><a href="ch07.html">7. TLS</a></span></dt><dd><dl><dt><span class="section"><a href="ch07.html#N110F1">Requirements</a></span></dt><dt><span class="section"><a href="ch07.html#N1110E">Encrypting your JDBC connection</a></span></dt><dd><dl><dt><span class="section"><a href="ch07.html#N11113">Client-Side</a></span></dt><dt><span class="section"><a href="ch07.html#N1117E">Server-Side</a></span></dt></dl></dd><dt><span class="section"><a href="ch07.html#jsse-section">JSSE</a></span></dt><dt><span class="section"><a href="ch07.html#privatekey-section">Making a Private-key Keystore</a></span></dt><dd><dl><dt><span class="section"><a href="ch07.html#N111BA">CA-Signed Cert</a></span></dt><dt><span class="section"><a href="ch07.html#N111E3">Non-CA-Signed Cert</a></span></dt></dl></dd><dt><span class="section"><a href="ch07.html#N111F0">Automatic Server or WebServer startup on UNIX</a></span></dt></dl></dd><dt><span class="chapter"><a href="ch08.html">8. SqlTool</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N1122F">Purpose, Coverage, Changes in Behavior</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N1125C">Platforms and SqlTool versions covered</a></span></dt><dt><span class="section"><a href="ch08.html#N11277">Functional Changes</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#baremin-section">The Bare Minimum</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N11347">Non-displayable Types</a></span></dt><dt><span class="section"><a href="ch08.html#N1136C">Desktop shortcuts</a></span></dt><dt><span class="section"><a href="ch08.html#N113EA">Loading sample data</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#auth-section">RC File Authentication Setup</a></span></dt><dt><span class="section"><a href="ch08.html#ilauth-section">Using Inline RC Authentication</a></span></dt><dt><span class="section"><a href="ch08.html#N114EF">
            Using the current version of SqlTool with an older HSQLDB
            distribution.
        </a></span></dt><dt><span class="section"><a href="ch08.html#int-section">Interactive Usage</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N11542">Command Types</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#N1155D">Command Types</a></span></dt><dt><span class="section"><a href="ch08.html#N115AE">Special Commands</a></span></dt><dt><span class="section"><a href="ch08.html#N11678">Edit Buffer / History Commands</a></span></dt><dt><span class="section"><a href="ch08.html#interactive_pl_commands-section">PL Commands</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N11792">? Variable</a></span></dt><dt><span class="section"><a href="ch08.html#binary_files-section">
                Storing and retrieving binary files</a></span></dt><dt><span class="section"><a href="ch08.html#N117E8">Command History</a></span></dt><dt><span class="section"><a href="ch08.html#N117F7">Shell scripting and command-line piping</a></span></dt><dt><span class="section"><a href="ch08.html#N11800">Emulating Non-Interactive mode</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#nonint-section">Non-Interactive</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#sqlswitch-section">Giving SQL on the Command Line</a></span></dt><dt><span class="section"><a href="ch08.html#N11853">SQL Files</a></span></dt><dt><span class="section"><a href="ch08.html#scripting-section">Piping and shell scripting</a></span></dt><dt><span class="section"><a href="ch08.html#N118CE">Optimally Compatible SQL Files</a></span></dt><dt><span class="section"><a href="ch08.html#N118E1">Comments</a></span></dt><dt><span class="section"><a href="ch08.html#N11904">Special Commands and Edit Buffer Commands in SQL Files</a></span></dt><dt><span class="section"><a href="ch08.html#N11972">Automation</a></span></dt><dt><span class="section"><a href="ch08.html#N1197D">Getting Interactive Functionality with SQL Files</a></span></dt><dt><span class="section"><a href="ch08.html#charencoding-section">
                Character Encoding</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#report-section">Generating Text or HTML Reports</a></span></dt><dt><span class="section"><a href="ch08.html#pl-section">SqlTool Procedural Language</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N11A15">Variables</a></span></dt><dt><span class="section"><a href="ch08.html#pl_alias-section">PL Aliases</a></span></dt><dt><span class="section"><a href="ch08.html#N11A97">Logical Expressions</a></span></dt><dt><span class="section"><a href="ch08.html#N11B10">Flow Control</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#chunk-section">Chunking</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N11B71">Why?</a></span></dt><dt><span class="section"><a href="ch08.html#N11B78">How?</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#raw-section">Raw Mode</a></span></dt><dt><span class="section"><a href="ch08.html#N11BA2">PL/SQL</a></span></dt><dt><span class="section"><a href="ch08.html#altjar-section">Using hsqltool.jar and hsqldbutil.jar</a></span></dt><dt><span class="section"><a href="ch08.html#N11C3F">Delimiter-Separated-Value Imports and Exports</a></span></dt><dd><dl><dt><span class="section"><a href="ch08.html#N11C5F">Simple DSV exports and imports using default settings</a></span></dt><dt><span class="section"><a href="ch08.html#N11CA4">Specifying queries and options</a></span></dt></dl></dd><dt><span class="section"><a href="ch08.html#N11D26">Unit Testing SqlTool</a></span></dt></dl></dd><dt><span class="chapter"><a href="ch09.html">9. SQL Syntax</a></span></dt><dd><dl><dt><span class="section"><a href="ch09.html#N11D75">Notational Conventions Used in this Chapter</a></span></dt><dt><span class="section"><a href="ch09.html#N11D92">SQL Commands</a></span></dt><dd><dl><dt><span class="section"><a href="ch09.html#alter_index-section">ALTER INDEX</a></span></dt><dt><span class="section"><a href="ch09.html#alter_sequence-section">ALTER SEQUENCE</a></span></dt><dt><span class="section"><a href="ch09.html#N11DB1">ALTER SCHEMA</a></span></dt><dt><span class="section"><a href="ch09.html#alter_table-section">ALTER TABLE</a></span></dt><dt><span class="section"><a href="ch09.html#alter_user-section">ALTER USER</a></span></dt><dt><span class="section"><a href="ch09.html#call-section">CALL</a></span></dt><dt><span class="section"><a href="ch09.html#checkpoint-section">CHECKPOINT</a></span></dt><dt><span class="section"><a href="ch09.html#commit-section">COMMIT</a></span></dt><dt><span class="section"><a href="ch09.html#connect-section">CONNECT</a></span></dt><dt><span class="section"><a href="ch09.html#create_alias-section">CREATE ALIAS</a></span></dt><dt><span class="section"><a href="ch09.html#create_index-section">CREATE INDEX</a></span></dt><dt><span class="section"><a href="ch09.html#create_role-section">CREATE ROLE</a></span></dt><dt><span class="section"><a href="ch09.html#N11EDC">CREATE SCHEMA</a></span></dt><dt><span class="section"><a href="ch09.html#create_sequence-section">CREATE SEQUENCE</a></span></dt><dt><span class="section"><a href="ch09.html#create_table-section">CREATE TABLE</a></span></dt><dt><span class="section"><a href="ch09.html#create_trigger-section">CREATE TRIGGER</a></span></dt><dt><span class="section"><a href="ch09.html#create_user-section">CREATE USER</a></span></dt><dt><span class="section"><a href="ch09.html#create_view-section">CREATE VIEW</a></span></dt><dt><span class="section"><a href="ch09.html#delete-section">DELETE</a></span></dt><dt><span class="section"><a href="ch09.html#disconnect-section">DISCONNECT</a></span></dt><dt><span class="section"><a href="ch09.html#drop_index-section">DROP INDEX</a></span></dt><dt><span class="section"><a href="ch09.html#N12050">DROP ROLE</a></span></dt><dt><span class="section"><a href="ch09.html#drop_sequence-section">DROP SEQUENCE</a></span></dt><dt><span class="section"><a href="ch09.html#N1206A">DROP SCHEMA</a></span></dt><dt><span class="section"><a href="ch09.html#drop_table-section">DROP TABLE</a></span></dt><dt><span class="section"><a href="ch09.html#drop_trigger-section">DROP TRIGGER</a></span></dt><dt><span class="section"><a href="ch09.html#drop_user-section">DROP USER</a></span></dt><dt><span class="section"><a href="ch09.html#drop_view-section">DROP VIEW</a></span></dt><dt><span class="section"><a href="ch09.html#explain-section">EXPLAIN PLAN</a></span></dt><dt><span class="section"><a href="ch09.html#grant-section">GRANT</a></span></dt><dt><span class="section"><a href="ch09.html#insert-section">INSERT</a></span></dt><dt><span class="section"><a href="ch09.html#revoke-section">REVOKE</a></span></dt><dt><span class="section"><a href="ch09.html#rollback-section">ROLLBACK</a></span></dt><dt><span class="section"><a href="ch09.html#savepoint-section">SAVEPOINT</a></span></dt><dt><span class="section"><a href="ch09.html#script-section">SCRIPT</a></span></dt><dt><span class="section"><a href="ch09.html#select-section">SELECT</a></span></dt><dt><span class="section"><a href="ch09.html#set_autocommit-section">SET AUTOCOMMIT</a></span></dt><dt><span class="section"><a href="ch09.html#collation-section">SET DATABASE COLLATION</a></span></dt><dt><span class="section"><a href="ch09.html#N12204">SET CHECKPOINT DEFRAG</a></span></dt><dt><span class="section"><a href="ch09.html#set_ignorecase-section">SET IGNORECASE</a></span></dt><dt><span class="section"><a href="ch09.html#set_initialschema-section">SET INITIAL SCHEMA </a></span></dt><dt><span class="section"><a href="ch09.html#set_logsize-section">SET LOGSIZE</a></span></dt><dt><span class="section"><a href="ch09.html#N12247">SET MAXROWS</a></span></dt><dt><span class="section"><a href="ch09.html#set_password-section">SET PASSWORD</a></span></dt><dt><span class="section"><a href="ch09.html#set_property-section">SET PROPERTY</a></span></dt><dt><span class="section"><a href="ch09.html#N12269">SET READONLY</a></span></dt><dt><span class="section"><a href="ch09.html#set_refint-section">SET REFERENTIAL INTEGRITY</a></span></dt><dt><span class="section"><a href="ch09.html#set_schema-section">SET SCHEMA</a></span></dt><dt><span class="section"><a href="ch09.html#set_scriptformat-section">SET SCRIPTFORMAT</a></span></dt><dt><span class="section"><a href="ch09.html#set_table_index-section">SET TABLE INDEX</a></span></dt><dt><span class="section"><a href="ch09.html#set_table_readonly-section">SET TABLE READONLY</a></span></dt><dt><span class="section"><a href="ch09.html#set_table_source-section">SET TABLE SOURCE</a></span></dt><dt><span class="section"><a href="ch09.html#set_write_delay-section">SET WRITE DELAY</a></span></dt><dt><span class="section"><a href="ch09.html#shutdown-section">SHUTDOWN</a></span></dt><dt><span class="section"><a href="ch09.html#update-section">UPDATE</a></span></dt></dl></dd><dt><span class="section"><a href="ch09.html#schemanaming-section">Schema object naming</a></span></dt><dt><span class="section"><a href="ch09.html#datatypes-section">Data Types</a></span></dt><dt><span class="section"><a href="ch09.html#N124ED">SQL Comments</a></span></dt><dt><span class="section"><a href="ch09.html#stored-section">Stored Procedures / Functions</a></span></dt><dt><span class="section"><a href="ch09.html#N1251E">Built-in Functions and Stored Procedures</a></span></dt><dt><span class="section"><a href="ch09.html#expression-section">SQL Expression</a></span></dt></dl></dd><dt><span class="appendix"><a href="apa.html">A. Building HSQLDB</a></span></dt><dd><dl><dt><span class="section"><a href="apa.html#N12823">Purpose</a></span></dt><dt><span class="section"><a href="apa.html#N1282C">Building with Ant</a></span></dt><dd><dl><dt><span class="section"><a href="apa.html#N12833">Obtaining Ant</a></span></dt><dt><span class="section"><a href="apa.html#N1284B">Building Hsqldb with Ant</a></span></dt></dl></dd><dt><span class="section"><a href="apa.html#N128FA">Building with DOS Batch Files</a></span></dt><dt><span class="section"><a href="apa.html#N12913">Hsqldb CodeSwitcher</a></span></dt><dt><span class="section"><a href="apa.html#N1293F">Building documentation</a></span></dt></dl></dd><dt><span class="appendix"><a href="apb.html">B. First JDBC Client Example</a></span></dt><dt><span class="appendix"><a href="apc.html">C. Hsqldb Database Files and Recovery</a></span></dt><dd><dl><dt><span class="section"><a href="apc.html#N129B1"></a></span></dt><dt><span class="section"><a href="apc.html#N129E1">States</a></span></dt><dd><dl><dt><span class="section"><a href="apc.html#N129E4"></a></span></dt><dt><span class="section"><a href="apc.html#N12A13"></a></span></dt><dt><span class="section"><a href="apc.html#N12A42"></a></span></dt></dl></dd><dt><span class="section"><a href="apc.html#N12A74">Procedures</a></span></dt><dd><dl><dt><span class="section"><a href="apc.html#N12A79">Clean Shutdown</a></span></dt><dt><span class="section"><a href="apc.html#N12AD3">Startup</a></span></dt><dt><span class="section"><a href="apc.html#N12B25">Repair</a></span></dt></dl></dd></dl></dd><dt><span class="appendix"><a href="apd.html">D. Running Hsqldb with OpenOffice.org 1.1.x</a></span></dt><dd><dl><dt><span class="section"><a href="apd.html#N12B8B">Introduction</a></span></dt><dt><span class="section"><a href="apd.html#N12B94">Installing</a></span></dt><dt><span class="section"><a href="apd.html#N12B99">Setting up OpenOffice.org</a></span></dt><dd><dl><dt><span class="section"><a href="apd.html#N12BAB">On Windows</a></span></dt><dt><span class="section"><a href="apd.html#N12BBE">On Linux</a></span></dt></dl></dd></dl></dd><dt><span class="appendix"><a href="ape.html">E. Hsqldb Test Utility</a></span></dt><dt><span class="appendix"><a href="apf.html">F. Database Manager</a></span></dt><dd><dl><dt><span class="section"><a href="apf.html#N12C7D">Brief Introduction</a></span></dt><dt><span class="section"><a href="apf.html#N12CA7">Auto tree-update</a></span></dt><dt><span class="section"><a href="apf.html#N12CBE">Automatic Connection</a></span></dt><dt><span class="section"><a href="apf.html#N12CCC">RC File</a></span></dt><dt><span class="section"><a href="apf.html#N12CF1">Using the current DatabaseManagers with an older HSQLDB
    distribution.</a></span></dt><dt><span class="section"><a href="apf.html#N12D23">DatabaseManagerSwing as an Applet</a></span></dt></dl></dd><dt><span class="appendix"><a href="apg.html">G. Transfer Tool</a></span></dt><dd><dl><dt><span class="section"><a href="apg.html#N12D9E">Brief Introduction</a></span></dt></dl></dd></dl></div><div class="list-of-tables"><p><b>List of Tables</b></p><dl><dt>1. <a href="pr01.html#N1004D">Alternate formats of this document</a></dt><dt>4.1. <a href="ch04.html#N108EC">Hsqldb URL Components</a></dt><dt>4.2. <a href="ch04.html#N109FA">Connection Properties</a></dt><dt>4.3. <a href="ch04.html#N10A81">Hsqldb Server Properties Files</a></dt><dt>4.4. <a href="ch04.html#N10ACE">Property File Properties</a></dt><dt>4.5. <a href="ch04.html#N10B3C">Server Property File Properties</a></dt><dt>4.6. <a href="ch04.html#N10B6F">WebServer Property File Properties</a></dt><dt>4.7. <a href="ch04.html#N10BEF">Database-specific Property File Properties</a></dt><dt>4.8. <a href="ch04.html#N10D6C">SQL command properties</a></dt><dt>9.1. <a href="ch09.html#N123FB">Data Types</a></dt></dl></div><div class="list-of-examples"><p><b>List of Examples</b></p><dl><dt>1.1. <a href="ch01.html#N1018D">Java code to connect to the local Server above</a></dt><dt>2.1. <a href="ch02.html#N102E6">Column values which satisfy a 2-column UNIQUE
        constraint</a></dt><dt>2.2. <a href="ch02.html#N103AB">Query comparison</a></dt><dt>2.3. <a href="ch02.html#N104F2">Numbering returned rows of a SELECT in sequential order</a></dt><dt>3.1. <a href="ch03.html#N107DB">server.properties fragment</a></dt><dt>3.2. <a href="ch03.html#N107EE">example sqltool.rc stanza</a></dt><dt>7.1. <a href="ch07.html#N11130">Exporting certificate from the server's keystore</a></dt><dt>7.2. <a href="ch07.html#N11145">Adding a certificate to the client keystore</a></dt><dt>7.3. <a href="ch07.html#N11154">Specifying your own trust store to a JDBC client</a></dt><dt>7.4. <a href="ch07.html#N1118A">Running an Hsqldb server with TLS encryption</a></dt><dt>7.5. <a href="ch07.html#N111CA">Getting a pem-style private key into a JKS keystore</a></dt><dt>8.1. <a href="ch08.html#N11426">Sample RC File</a></dt><dt>8.2. <a href="ch08.html#alias-example">Defining and using a PL alias (PL variable)</a></dt><dt>8.3. <a href="ch08.html#N117D6">Inserting binary data into database from a file</a></dt><dt>8.4. <a href="ch08.html#N117DC">Downloading binary data from database to a file</a></dt><dt>8.5. <a href="ch08.html#N118BE">Piping input into SqlTool</a></dt><dt>8.6. <a href="ch08.html#N118EA">Valid comment example</a></dt><dt>8.7. <a href="ch08.html#N118F2">Invalid comment example</a></dt><dt>8.8. <a href="ch08.html#N11A89">Simple SQL file using PL</a></dt><dt>8.9. <a href="ch08.html#N11B55">SQL File showing use of most PL features</a></dt><dt>8.10. <a href="ch08.html#N11B6A">Single-line chunking example</a></dt><dt>8.11. <a href="ch08.html#N11B7D">Multi-line chunking example</a></dt><dt>8.12. <a href="ch08.html#N11B99">Interactive Raw Mode example</a></dt><dt>8.13. <a href="ch08.html#N11BBF">PL/SQL Example</a></dt><dt>8.14. <a href="ch08.html#N11C72">DSV Export Example</a></dt><dt>8.15. <a href="ch08.html#N11C95">DSV Import Example</a></dt><dt>8.16. <a href="ch08.html#N11CFD">DSV Export of an Arbitrary SELECT Statement</a></dt><dt>8.17. <a href="ch08.html#N11D0E">Sample DSV headerswitch settings</a></dt><dt>8.18. <a href="ch08.html#N11D15">DSV targettable setting</a></dt><dt>A.1. <a href="apa.html#N128EC">Buiding the standard Hsqldb jar file with Ant</a></dt><dt>A.2. <a href="apa.html#N1291C">Example source code before CodeSwitcher is run</a></dt><dt>A.3. <a href="apa.html#N12924">CodeSwitcher command line invocation</a></dt><dt>A.4. <a href="apa.html#N12930">Source code after CodeSwitcher processing</a></dt><dt>A.5. <a href="apa.html#N12951">Building HTML User Guides</a></dt><dt>A.6. <a href="apa.html#N12962">Building User Guides in all formats</a></dt><dt>B.1. <a href="apb.html#N12993">JDBC Client source code example</a></dt></dl></div></div><div class="navfooter"><hr><table summary="Navigation footer" width="100%"><tr><td align="left" width="40%">&nbsp;</td><td align="center" width="20%">&nbsp;</td><td align="right" width="40%">&nbsp;<a accesskey="n" href="pr01.html"><img src="navicons/next.gif" alt="Next"></a></td></tr><tr><td valign="top" align="left" width="40%">&nbsp;</td><td align="center" width="20%">&nbsp;</td><td valign="top" align="right" width="40%">&nbsp;Introduction</td></tr></table></div></body></html>