Wiki source code of InstallationHSQL
Version 1.5 by Vincent Massol on 2007/07/10
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | 1 HSQL Installation | ||
| 2 | |||
| 3 | Follow these instructions: | ||
| 4 | |||
| 5 | * 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 <tt>hsqldb*.jar</tt>. If your XWiki WAR doesn't have it in <tt>WEB-INF/lib</tt> you'll need to download it and copy it there. You can download it from the [HSQLDB web site>http://www.hsqldb.org/] or directly from the [Maven Central Repository>http://repo1.maven.org/maven2/hsqldb/hsqldb/]. | ||
| 6 | * 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 <tt>WEB-INF/hibernate.cfg.xml</tt> file where you have expanded the XWiki WAR file and replace the matching properties with the following ones: | ||
| 7 | |||
| 8 | {code} | ||
| 9 | <property name="connection.url">jdbc:hsqldb:file:[DATABASE_LOCATION];shutdown=true</property> | ||
| 10 | <property name="connection.username">sa</property> | ||
| 11 | <property name="connection.password"></property> | ||
| 12 | <property name="connection.driver_class">org.hsqldb.jdbcDriver</property> | ||
| 13 | <property name="dialect">org.hibernate.dialect.HSQLDialect</property> | ||
| 14 | {code} | ||
| 15 | |||
| 16 | where <tt>\[DATABASE_LOCATION\]</tt> is where you wish to put the HSQL database. For example <tt>/apps/xwiki-database/xwiki</tt>. |
