You can add the command line argument –help to get a list of available arguments for these tools. As a result you cannot check the contents of the database with external tools such as Database Manager while your application is running. TEXT tables are efficient in memory usage as they cache only part of the text data and all of the indexes. The rest are general-purpose database tools that can be used with any database engine that has a JDBC driver. In most server modes, the server serves up to 10 databases that are specified at the time of running the server.

Uploader: Akibei
Date Added: 3 April 2008
File Size: 49.68 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 80179
Price: Free* [*Free Regsitration Required]

Note that only one Java process at a time can make in-process connections to a given file: Introduction and Concepts by Bruce Momjian, which is available on the web.

Each time a connection is made, a port is allocated by the operating system and deallocated after the connection is closed. The Servlet mode can serve only a single database. JDBC methods are broadly divided into: The Servlet mode can serve multiple databases.

Sgandalone relative paths or paths that refer to the same directory on the same drive can be identical.

The supported commands are listed in the SQL Syntax chapter. If a mistake is made in specifying the path for connecting to an existing database, a connection is nevertheless established atandalone a new database.


In general, JDBC is used for all access to databases.

As no information is written to disk, this mode should be used only for internal processing of application data, hdqldb applets or certain special applications. This feature has a side effect that can confuse new users. The properties file contains a few settings about the database.

Do not use cached tables if your data set is relatively small.

Atlassian Community logo Explore. If no username or password is specified, the default SA user and an empty password are used. For this reason, a res: Changes to the structure of the database, such as dropping or modifying tables or indexes also create large amounts of unused space that can be reclaimed using this command.

Janet Albion Atlassian Team Oct 14, Creating a New Database. The main changes are. Creating a New Database.

Solved: Connecting to Standalone HSQLDB JIRA Database

Instead, the value defined for dbname. The main drawback is that it is not possible by default to connect to the database from outside your application. Start a discussion Great for ongoing dialogue with others in the community. These modes allow a high degree of compatibility with several other database systems which use non-standard SQL syntax.

Connecting to Standalone HSQLDB JIRA Database

In the above examples each server serves only one database and only one in-memory database can be created. TEXT tables are efficient in memory usage as they cache only part of the text data and all of the indexes.


There are three types of catalog depending on how the data is stored. TEXT table declarations are not allowed in this mode. These objects can be reused, but if they are not needed after performing the operations, they should be closed.

Different commands are used to run each program. Direct downloads from SourceForge exceed 2, copies, with hundreds of millions of copies distributed as part of other software packages. Only part of their data or indexes is held in memory, allowing large tables that would otherwise take up to several hundred megabytes of memory. The database performance test package PolePosition compares the performance of relational and object databases for storing hsqlb.

This would result in unnecessary memory and speed overheads. For most applications this mode can be faster, as the data is not converted and sent over the network.