~ubuntu-branches/ubuntu/maverick/hsqldb/maverick

« back to all changes in this revision

Viewing changes to doc/guide/apd.html

  • Committer: Bazaar Package Importer
  • Author(s): Matthias Klose
  • Date: 2006-09-26 11:47:49 UTC
  • mfrom: (1.1.2 upstream)
  • Revision ID: james.westby@ubuntu.com-20060926114749-3jd0utm7w21x1iqt
Tags: 1.8.0.5-2ubuntu1
* Synchronise with Debian unstable; remaining changes:
  - build using java-gcj-compat.
* libhsqldb-java: Add gij as alternative dependency.
* Build a libhsqldb-java-gcj package.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
<html><head><META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><title>Appendix&nbsp;D.&nbsp;Running Hsqldb with OpenOffice.org 1.1.x</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, OpenOffice"><meta name="keywords" content="Hsqldb, Hypersonic, Database, JDBC, Java"><link rel="home" href="index.html" title="Hsqldb User Guide"><link rel="up" href="index.html" title="Hsqldb User Guide"><link rel="previous" href="apc.html" title="Appendix&nbsp;C.&nbsp;Hsqldb Database Files and Recovery"><link rel="next" href="ape.html" title="Appendix&nbsp;E.&nbsp;Hsqldb Test Utility"></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">Appendix&nbsp;D.&nbsp;Running Hsqldb with OpenOffice.org 1.1.x</th></tr><tr><td align="left" width="20%"><a accesskey="p" href="apc.html"><img src="navicons/prev.gif" alt="Prev"></a>&nbsp;</td><th align="center" width="60%">&nbsp;</th><td align="right" width="20%">&nbsp;<a accesskey="n" href="ape.html"><img src="navicons/next.gif" alt="Next"></a></td></tr></table><hr></div><div class="appendix" lang="en"><div class="titlepage"><div><div><h2 class="title"><a name="N128B2"></a>Appendix&nbsp;D.&nbsp;Running Hsqldb with OpenOffice.org 1.1.x</h2></div><div><div class="author"><h3 class="author"><span class="firstname">Hermann</span> <span class="surname">Kienlein</span></h3><div class="affiliation"><span class="orgname">EDV - Systeme Kienlein<br></span></div><tt class="email">&lt;<a href="mailto:hermann@kienlein.com">hermann@kienlein.com</a>&gt;</tt></div></div><div><div class="legalnotice"><p>
 
1
<html><head><META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><title>Appendix&nbsp;D.&nbsp;Running Hsqldb with OpenOffice.org 1.1.x</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, OpenOffice"><meta name="keywords" content="Hsqldb, Hypersonic, Database, JDBC, Java"><link rel="home" href="index.html" title="Hsqldb User Guide"><link rel="up" href="index.html" title="Hsqldb User Guide"><link rel="previous" href="apc.html" title="Appendix&nbsp;C.&nbsp;Hsqldb Database Files and Recovery"><link rel="next" href="ape.html" title="Appendix&nbsp;E.&nbsp;Hsqldb Test Utility"></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">Appendix&nbsp;D.&nbsp;Running Hsqldb with OpenOffice.org 1.1.x</th></tr><tr><td align="left" width="20%"><a accesskey="p" href="apc.html"><img src="navicons/prev.gif" alt="Prev"></a>&nbsp;</td><th align="center" width="60%">&nbsp;</th><td align="right" width="20%">&nbsp;<a accesskey="n" href="ape.html"><img src="navicons/next.gif" alt="Next"></a></td></tr></table><hr></div><div class="appendix" lang="en"><div class="titlepage"><div><div><h2 class="title"><a name="N129E2"></a>Appendix&nbsp;D.&nbsp;Running Hsqldb with OpenOffice.org 1.1.x</h2></div><div><div class="author"><h3 class="author"><span class="firstname">Hermann</span> <span class="surname">Kienlein</span></h3><div class="affiliation"><span class="orgname">EDV - Systeme Kienlein<br></span></div><tt class="email">&lt;<a href="mailto:hermann@kienlein.com">hermann@kienlein.com</a>&gt;</tt></div></div><div><div class="legalnotice"><p>
2
2
            Copyright 2003-2004 Hermann Kienlein.
3
3
            Permission is granted to distribute this document without any 
4
4
            alteration under the terms of the HSQLDB license.
5
5
            Additional permission is granted to the HSQLDB Development Group to 
6
6
            distribute this document with or without alterations under the 
7
7
            terms of the HSQLDB license.
8
 
        </p></div></div><div><p class="pubdate">$Date: 2005/06/08 16:02:34 $</p></div></div><div></div></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="section"><a href="apd.html#N128D2">Introduction</a></span></dt><dt><span class="section"><a href="apd.html#N128DB">Installing</a></span></dt><dt><span class="section"><a href="apd.html#N128E0">Setting up OpenOffice.org</a></span></dt><dd><dl><dt><span class="section"><a href="apd.html#N128F2">On Windows</a></span></dt><dt><span class="section"><a href="apd.html#N12905">On Linux</a></span></dt></dl></dd></dl></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="N128D2"></a>Introduction</h2></div></div><div></div></div><p>
 
8
        </p></div></div><div><p class="pubdate">$Date: 2005/06/08 16:02:34 $</p></div></div><div></div></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="section"><a href="apd.html#N12A02">Introduction</a></span></dt><dt><span class="section"><a href="apd.html#N12A0B">Installing</a></span></dt><dt><span class="section"><a href="apd.html#N12A10">Setting up OpenOffice.org</a></span></dt><dd><dl><dt><span class="section"><a href="apd.html#N12A22">On Windows</a></span></dt><dt><span class="section"><a href="apd.html#N12A35">On Linux</a></span></dt></dl></dd></dl></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="N12A02"></a>Introduction</h2></div></div><div></div></div><p>
9
9
            HSQLDB can now act as a Database with OpenOffice.org.
10
10
            This document is written to help you connecting and running HSQLDB 
11
11
            out of OpenOffice.org in a simple way.
19
19
            HSQLDB is included with OpenOffice.org 2.0 and is used by default.
20
20
            Please refer to standard OpenOffice.org 2.0 documentation on how 
21
21
            to use HSQLDB with this version.
22
 
        </p></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="N128DB"></a>Installing</h2></div></div><div></div></div><p>
 
22
        </p></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="N12A0B"></a>Installing</h2></div></div><div></div></div><p>
23
23
            I assume you have a running OpenOffice.org (OOo) and a
24
24
            JavaRuntimeEnvironment.
25
25
            So place the hsqldb_*.zip file where you want on your disk 
26
26
            and unpack it (I assume you have done this already).
27
 
        </p></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="N128E0"></a>Setting up OpenOffice.org</h2></div></div><div></div></div><p>
 
27
        </p></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="N12A10"></a>Setting up OpenOffice.org</h2></div></div><div></div></div><p>
28
28
            Start OOo with a text document and go to the Database-Explorer
29
29
            (simply by pressing F4).
30
30
            In the left frame you see a tree-view with all known databases in
40
40
        </p><p>
41
41
            As Driver-Class insert <tt class="classname">org.hsqldb.jdbcDriver</tt> 
42
42
            and as URL choose the following:
43
 
        </p><div class="section" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="N128F2"></a>On Windows</h3></div></div><div></div></div><p>
 
43
        </p><div class="section" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="N12A22"></a>On Windows</h3></div></div><div></div></div><p>
44
44
                You can specify a directory where HSQLDB should store the info 
45
45
                and data. Something like 
46
46
                <tt class="literal">jdbc:hsqldb:file:c:\javasrc\hsqldb-dev\databasename</tt>
55
55
            </p><p>
56
56
                The first is the directory-path and the databasename is the 
57
57
                identifier for the database.
58
 
            </p></div><div class="section" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="N12905"></a>On Linux</h3></div></div><div></div></div><p>
 
58
            </p></div><div class="section" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="N12A35"></a>On Linux</h3></div></div><div></div></div><p>
59
59
                Choose a path as said for windows like /opt/db/data
60
60
            </p><p>
61
61
                As username take sa, this is the standard-administrator for