首页 > 代码库 > hsqldb

hsqldb

2024-07-24 04:08:34   217人阅读

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.batcd ..\data@java -classpath ../lib/hsqldb.jar org.hsqldb.server.Server --database.1 file:cgdb --dbname.1 cgdbC:\_Compoments\hsqldb\hsqldb-2.3.2\hsqldb\bin>java -classpath ../lib/hsqldb.jar org.hsqldb.server.Server --helpno value for argument:-helpUsage: 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 andloads 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


联系
我们