From version < 9.1 >
edited by Vincent Massol
on 2012/06/11
To version < 9.2 >
edited by Vincent Massol
on 2012/06/11
Change comment: Added warning about production usage of HSQLDB



Page properties
... ... @@ -3,6 +3,10 @@
3 3  * 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>>http://www.hsqldb.org/]] or directly from the [[Maven Central Repository>>http://repo1.maven.org/maven2/hsqldb/hsqldb/]].
4 4  * 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 uncomment the HSQLDB part.
5 5  
6 +{{warning}}
7 +If you intend to use HSQLDB in production you should probably tune it for a production usage. If you've installed the XWiki Standalone distribution just be aware that it's not tuned to be production-ready. Also note that you would need to find way to perform backups, live replication, administration tools etc. We would suggest using a more production-ready database such as MySQL or PostgreSQL if you can.
8 +{{/warning}}
9 +
6 6  = Other optional ideas =
7 7  
8 8  * You can use a remote HSQLDB database instead of embedding it. To do this, just use a URL like ##jdbc:hsqldb:hsql:HOSTNAME...## instead of the ##jdbcc:hsqldb:file:..## URL. The major version of the hsqldb jar file must match the major version that the HSQLDB server is using.

Get Connected