Wiki source code of H2 Installation
Version 1.1 by PaulSnow on 2010/06/03
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | [[H2>>http://www.h2database.com/]] is a fast free in memory, or disc based java database. | ||
| 2 | |||
| 3 | == Changes to Hibernate.cfg.xml == | ||
| 4 | |||
| 5 | === When using a JDBC datasource === | ||
| 6 | |||
| 7 | {{code language="xml"}} | ||
| 8 | <property name="connection.datasource">java:comp/env/jdbc/XWikiDS</property> | ||
| 9 | <property name="dialect">org.hibernate.dialect.H2Dialect</property> | ||
| 10 | {{/code}} | ||
| 11 | |||
| 12 | === When letting hibernate manage your pools === | ||
| 13 | |||
| 14 | {{code language="xml"}} | ||
| 15 | <property name="connection.url">jdbc:h2:tcp://remotehost/xwiki23</property> | ||
| 16 | <property name="connection.username">xwiki</property> | ||
| 17 | <property name="connection.password">xwikipw</property> | ||
| 18 | <property name="connection.driver_class">org.h2.Driver</property> | ||
| 19 | <property name="dialect">org.hibernate.dialect.HSQLDialect</property> | ||
| 20 | <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> | ||
| 21 | <property name="connection.pool_size">2</property> | ||
| 22 | <property name="statement_cache.size">2</property> | ||
| 23 | {{/code}} |
