Changes for page Derby Installation

Last modified by Vincent Massol on 2020/01/28

<
From version < 4.3 >
edited by Manuel Smeria
on 2012/12/11
To version < 5.1 >
edited by Vincent Massol
on 2017/09/06
>
Change comment: Copied from platform:AdminGuide.InstallationDerby

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.ManuelSmeria
1 +XWiki.VincentMassol
Content
... ... @@ -1,6 +1,5 @@
1 1  * Derby in Embedded mode is a very simple database to configure as you don't need to install nor start it before being able to use it. It comes as a single JAR file named ##derby*.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 [[Derby web site>>http://db.apache.org/derby/]] or directly from the [[Maven Central Repository>>http://repo1.maven.org/maven2/org/apache/derby/derby/]].
2 -* Once this is done, you need to configure XWiki to use Derby 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:
3 -(((
2 +* Once this is done, you need to configure XWiki to use Derby 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:(((
4 4  {{code}}
5 5  <property name="connection.url">jdbc:derby:[DATABASE_LOCATION];create=true</property>
6 6  <property name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property>
... ... @@ -12,8 +12,7 @@
12 12  {{info}}
13 13  You don't need to specify a username/password property as by default Derby doesn't require them.
14 14  {{/info}}
15 -)))
16 -Derby doesn't support VARCHAR larger than 32K and Hibernate doesn't map large fields to correct Derby types ([[it should use BLOB and CLOB instead of VARCHAR>>https://hibernate.onjira.com/browse/HHH-2651]]). Thus we need to provide a modified HBM mapping file. Follow the instructions below:
14 +)))Derby doesn't support VARCHAR larger than 32K and Hibernate doesn't map large fields to correct Derby types ([[it should use BLOB and CLOB instead of VARCHAR>>https://hibernate.onjira.com/browse/HHH-2651]]). Thus we need to provide a modified HBM mapping file. Follow the instructions below:
17 17  
18 18  = For XWiki 1.1M2 and above =
19 19  

Get Connected