[lsc-changes] [Ldap Synchronization...] page changed: documentation:2.0:howtos:hsqldb

[webmaster]

A page in your DokuWiki was added or changed. Here are the details:

Date : 2014/03/04 16:56
Browser : Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:27.0) Gecko/20100101 Firefox/27.0
IP-Address : 88.173.78.196
Hostname : mne69-10-88-173-78-196.fbx.proxad.net
Old Revision: http://lsc-project.org/wiki/documentation/2.0/howtos/hsqldb?rev=1335212119
New Revision: http://lsc-project.org/wiki/documentation/2.0/howtos/hsqldb
Edit Summary: removed
User : coudot

@@ -1,77 +1 @@
- ====== HSQLDB ======

- LSC provides HSLQDB library and a utility script that allow to use this database to store temporary synchronization data, for example to use a CSV file as a source.
-
- ===== Script location =====
-
- LSC provides a wrapper to manage the packaged HSQLDB database, it is located in the LSC bin directory and is named ''hsqldb''.
-
- You can execute it to see the possible options:
- <code bash>
- $ bin/hsqldb
-
- bin/hsqldb [<option>]
-
- One option from available options is:
- --import <file> [<table>] [<separator>] Import data from CSV file
- --drop [<table>] Drop data
- --show [<table>] Show data from database
- --start Start the server
- --stop Stop the server
- --status Display server status
- --help Print informations
- </code>
-
- ===== Start/stop HSQLDB =====
-
- Start HSQLB will the following command:
- <code bash>
- $ bin/hsqldb --start
- </code>
-
- You can then check the status:
- <code bash>
- $ bin/hsqldb --status
- HSQLDB Server is running (PID 7020)
- </code>
-
- To stop it:
- <code bash>
- $ bin/hsqldb --stop
- </code>
-
- <note important>If you stop HSQLDB, all registered data will be lost.</note>
-
- ===== Import CSV data =====
-
- By default, your HSQLDB database is empty. You can load the data with this command:
- <code bash>
- $ bin/hsqldb --import tutorial.csv
- 1 lines imported into table csvdata
- </code>
-
- <note tip>By default, data are loaded in table ''csvdata'' but you can change the table name, for example:
- <code bash>
- $ bin/hsqldb --import tutorial.csv tutorial
- 1 lines imported into table tutorial
- </code>
- </note>
-
- You can then display imported data:
- <code bash>
- $ bin/hsqldb --show
- UID SN GIVENNAME CN MAIL
- ---- --- --------- -------- ----------------
- jdoe Doe John John Doe jdoe at example.com
- </code>
-
- <note tip>You can specify the table name after the ''--show'' option.</note>
-
- ===== Remove data =====
-
- You can remove data by dropping a table:
- <code bash>
- $ bin/hsqldb --drop
- </code>
-
- <note tip>You can specify the table name after the ''--drop'' option.</note>