InstallationHSQL

Version 3.1 by blaine on 2008/06/20
Warning: For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.

HSQL Installation

Follow these instructions:

  • HSQL is a very simple database to configure as you don't need to install nor to start it before being able to use it. It comes as a single JAR file named hsqldb*.jar. If your XWiki WAR doesn't have it in WEB-INF/lib you'll need to download it and copy it there. You can download it from the HSQLDB web site or directly from the Maven Central Repository.
  • Once this is done, you need to tell XWiki to use HSQL and to tell it where the database files will be created. To do this, edit the WEB-INF/hibernate.cfg.xml file where you have expanded the XWiki WAR file and replace the matching properties with the following ones:
<property name="connection.url">jdbc:hsqldb:file:[DATABASE_LOCATION];shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>

where [DATABASE_LOCATION] is where you wish to put the HSQL database. For example /apps/xwiki-database/xwiki.

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:Documentation.AdminGuide.Installation.InstallationWAR.InstallationHSQL.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

<property name="connection.url">DUMMY</property>
<property name="connection.username">DUMMY</property>
<property name="connection.password">DUMMY</property>
<property name="connection.driver_class">DUMMY</property>
<!-- I haven't had time to check whether the dummy settings are needed.  I know they are needed with a setup for a similar product.  You're welcome to update this text if you test and verify they're unnecessary. -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.datasource">java:/comp/env/jdbc/xwikiDs</property>
    • Then you manage the data source using app server facilities. With Tomcat, for example, you would map the resource link jcbc/xwikiDs to a container-managed data source using the Admin web app or by editing the file conf/Catalina/*/xwiki.xml (i.e. webapp-name + ".xml").
Tags:
   

Get Connected