首页 > 数据库技术 > 详细

hsqldb

时间:2014-09-24 15:39:58      阅读:381      评论:0      收藏:0      [点我收藏+]

http://www.hsqldb.org/

HSQLDB (HyperSQL DataBase) is the leading SQL relational database software written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools.

HSQLDB supports the widest range of SQL Standard features seen in any open source database engine: SQL:2011 core language features and an extensive list of SQL:2011 optional features. It supports nearly full Advanced ANSI-92 SQL (BNF format). Many extensions to the Standard, including syntax compatibility modes and features of other popular database engines, are also supported.

启动脚本和帮助:

start-cgdb.bat
cd ..\data
@java -classpath ../lib/hsqldb.jar org.hsqldb.server.Server --database.1 file:cgdb --dbname.1 cgdb

C:\_Compoments\hsqldb\hsqldb-2.3.2\hsqldb\bin>java -classpath ../lib/hsqldb.jar org.hsqldb.server.Server --help
no value for argument:-help
Usage: java org.hsqldb.server.Server [options]

+-----------------+-------------+----------+------------------------------+
|     OPTION      |    TYPE     | DEFAULT  |         DESCRIPTION          |
+-----------------+-------------+----------+------------------------------|
| --help          | -           | -        | displays this message        |
| --address       | name|number | any      | server inet address          |
| --port          | number      | 9001/544 | port at which server listens |
| --database.i    | [type]spec  | 0=test   | name of database i           |
| --dbname.i      | alias       | -        | url alias for database i     |
| --silent        | true|false  | true     | false => display all queries |
| --trace         | true|false  | false    | display JDBC trace messages  |
| --tls           | true|false  | false    | TLS/SSL (secure) sockets     |
| --no_system_exit| true|false  | false    | do not issue System.exit()   |
| --remote_open   | true|false  | false    | can open databases remotely  |
| --props         | filepath    |          | file path of properties file |
+-----------------+-------------+----------+------------------------------+

The server looks for a ‘server.properties‘ file in the current directory and
loads properties from it if it exists.
Command line options override those loaded from the ‘server.properties‘ file.

See the HSQLDB User Guide for further details.

  

hsqldb

原文:http://www.cnblogs.com/wucg/p/3990577.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!