JdbcTool: Command line pain relief for JDBC databases.
Copyright (C) 2007, Quuxo Software.

 * What is it? *

JdbcTool is a collection of command line utilities for making your life
easy when working with JDBC databases. Included are:

  jdbctool: An interactive command line tool for executing SQL statements.
  jdbcdump: Dump the contents of a database as SQL statements into a file,
            like mysqldump.
  jdbcload: Execute SQL statements from a file (the opposite of jdbcdump)

Currently, only HSQLDB is supported.

Patches are greatly aoppreciated for support for more databases, new features,
or bug fixes. Email them to: Mike Gratton <michael@quuxo.com>

JdbcTool can be found on the web at: <http://wbe.quuxo.com/projects/jdbctool>

 * Installation *

Simply expand the tarball/zip archive into a directory. Jdbctool optionally
can use Java-Readline <http://java-readline.sourceforge.net/> to provide
enhanced command line editing and history support.

 * Using the tools *

The tools share common command line options:

  TOOL [-u USER] [-p PASSWORD | -P] JDBC_URL

For example:

  jdbctool -u sa jdbc:hsqldb:file:+test/db

If you specify `-P', you will be prompted for a password.

Both jdbcdump and jdbcload have an optional `-f FILE' option, which allows
you specify a file to read/write SQL statements to. If this is not specified,
standard in/out will be used instead.

The tools attempt to load a known list of JDBC drivers. Currently the
only way they can be found is if they exist on the default class path,
or else are specified in the CLASSPATH envrionment variable. So you
probably want to run the tools like this for now:

  CLASSPATH=path/to/hsqldb.jar jdbctool -u sa jdbc:hsqldb:file:+test/db

If you are using a Bourne-compatible shell like Bash.

 * Licence *

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.