#H2

Welcome to H2, the Java SQL database. The main features of H2 are:

• Very fast, open source, JDBC API
• Embedded and server modes; in-memory databases
• Browser based Console application
• Small footprint: around 1.5 MB jar file size

##Experimental Building & Testing with Maven

###Setup JDK

Maven requires at minimum the JDK 1.7 whereas H2 is designed to be compiled against the JDK 1.6; the way in which this is resolved is through maven toolchains.

You simply need to create a toolchains.xml file in ~/.m2/ that tells maven where to find the JDK 1.6

Here is a sample file

<?xml version="1.0" encoding="UTF8"?>
<toolchains>
  <!-- JDK toolchains -->
  <toolchain>
    <type>jdk</type>
    <provides>
      <version>1.6</version>
    </provides>
    <configuration>
      <jdkHome>/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home/</jdkHome>
    </configuration>
  </toolchain>
</toolchains>

###Building

H2 uses Maven Wrapper setup, you can instruct users to run wrapper scripts:

$ ./mvnw clean test

or

$ ./mvnw.cmd clean test

###Running

You can run the server like this

mvn exec:java -Dexec.mainClass=org.h2.tools.Server