Skip to main content

Content Starts Here

How to view and edit the hsql embedded database?

Question
How to view and edit the embedded database?
Answer
Disclaimer: the content of this article is provided for testing or educational purposes only. We do not recommend changing data in production instances of Collaborator Server using the instructions in this article. Although we support read-only access to the database for reporting and automation, if you make changes to data in the database yourself you could irreparably destroy the integrity of the database.

In order to view or/and edit the HSQL embedded database, follow the instructions below:

8.1.8100 - 9.5.9500

  1. Stop the ccollab-server daemon/service.
  2. Open up a command prompt and change the directory to the root of the Collaborator server installation directory.
  3. Run:
java -cp tomcat/lib/hsqldb.jar org.hsqldb.util.DatabaseManagerSwing
This command starts up a utility for viewing/editing the HSQL database.
  1. Open the database with these options:
Type: HSQL Database Engine Standalone
Driver: org.hsqldb.jdbcDriver [default]
URL: jdbc:hsqldb:file:tomcat/database
User: SA [default]
Password: [leave this blank, which is the default]

If the database was loaded successfully, you should be able to see the image below:
Note: This will create a database.lck file in the <collab-server install dir>/tomcat/ directory. 

User-added image

Enter your query in the Textbox at the upper right-hand side of the window and click on the "Execute SQL" button to run the query.
  1. Once done close the HSQL Database Manager and delete the database.lck file from the <collab-server install dir>/tomcat/ directory.
  2. Start the ccollab-server daemon/service.

9.5.9501 - 11.2.11201

For the Collaborator versions higher than 9.5.9500 the described process changed as the location of the hsqldb.jar file changed. So, you need to run the command below at the third step of the instruction above:
java -cp tomcat\webapps\ROOT\WEB-INF\lib\hsqldb-2.3.2.jar org.hsqldb.util.DatabaseManagerSwing
Previous MonthNext Month
SunMonTueWedThuFriSat