H2 Installation
Version 1.1 by PaulSnow on 2010/06/03
H2 is a fast free in memory, or disc based java database.
Changes to Hibernate.cfg.xml
When using a JDBC datasource
<property name="connection.datasource">java:comp/env/jdbc/XWikiDS</property>
<property name="dialect">org.hibernate.dialect.H2Dialect</property>
<property name="dialect">org.hibernate.dialect.H2Dialect</property>
When letting hibernate manage your pools
<property name="connection.url">jdbc:h2:tcp://remotehost/xwiki23</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwikipw</property>
<property name="connection.driver_class">org.h2.Driver</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwikipw</property>
<property name="connection.driver_class">org.h2.Driver</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
