• Philippe Marschall's avatar
    Add JSR-310 Support (#386) · f4507bb3
    Philippe Marschall 提交于
    Add support for Java 8 Date and Time API AKA JSR-310. On the face of it
    the existing JDBC types java.sql.Date, java.sql.Time and
    java.sql.Timestamp offer conversion methods to and from JSR-310 data
    types. Unfortunately java.sql.Timestamp does silent data truncation
    when the timestamp falls into a DST transition on the JVM time zone.
    Worse still for java.time.OffsetDateTime there is no corresponding JDBC
    type. Therefore these conversions have to be implemented. All of this
    has to be programmed using reflection so the code compiles and can be
    executed on Java 7.
    f4507bb3

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