• Philippe Marschall's avatar
    Fix fetch first rows only grammar · b229c223
    Philippe Marschall 提交于
    After some additional test for #476 and more checking with the source
    code I found out that I make a mistake in the grammar. The
    MySQL/Postgres and the Derby/Oracle syntax should be different
    productions.
    b229c223

Welcome to H2, the Java SQL database. Build Status

The main features of H2 are:

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

More information: http://h2database.com

Features

H2 Derby HSQLDB MySQL PostgreSQL
Pure Java Yes Yes Yes No No
Memory Mode Yes Yes Yes No No
Encrypted Database Yes Yes Yes No No
ODBC Driver Yes No No Yes Yes
Fulltext Search Yes No No Yes Yes
Multi Version Concurrency Yes No Yes Yes Yes
Footprint (jar/dll size) bug MB duplicate MB bug MB good first issue MB invalid MB