User:tapaya/H2

[Edit]JAMWiki with H2 database Setup

[Edit]Windows XP

Note that software versions may vary. I'm just specifying the exact setup which worked for me.

1. Install Java 6 (JRE 6)
2. Get the Apache Tomcat 6.0.18 installer (http://ftp.uni-erlangen.de/pub/mirrors/apache/tomcat/tomcat-6/v6.0.18/bin/apache-tomcat-6.0.18.exe)
   1. Run the Windows Service Installer
   2. Make a Full Install (and leave all other settings)
   3. After successfull installation stop the Tomcat service from the Windows taskbar
3. Get the JAMWiki 0.6.7 WAR file (http://downloads.sourceforge.net/jamwiki/jamwiki-war-0.6.7.war)
   1. Move the WAR file to C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7.war
   2. Start the Tomcat service in order to explode the WAR file; now there's a new directory C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7
   3. Stop the Tomcat service again
4. Get the H2 1.1.107 installer (http://www.h2database.com/h2-setup-2009-01-24.exe)
   1. Run the Windows Installer
   2. Copy the H2 JAR file from C:\Programme\H2\bin\h2-1.1.107.jar to C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7\WEB-INF\lib\h2-1.1.107.jar
   3. Edit the file such that the statement on lines 167/168 becomes

STATEMENT_CREATE_WIKI_USER_LOGIN_INDEX = \
    CREATE UNIQUE INDEX jam_u_wuser_login on jam_wiki_user (login)

1. 1. Create a directory C:\Programme\Apache Software Foundation\Tomcat 6.0\webapps\jamwiki-war-0.6.7\JAMWiki-Systemdateien
   2. Start the Tomcat service again
2. Open the Internet Explorer and point it at http://localhost:8080/jamwiki-war-0.6.7
3. Fill in all entries in the JAMWiki setup form except for the database password
4. Voilà, you are a JAMWiki on H2 user!