Emebedded Databases

We have the following choices:

  • H2
    driver --> org.h2.Driver
    jdbc url --> jdbc:h2:~/test
    hibernate.dialect --> org.hibernate.dialect.H2Dialect
  • HSQLDB (HyperSQL)
    • Written in Java
    • 700 KB jar
  • Apache Derby DB (JavaDB)
    <dependency>
        <groupId>org.apache.derby</groupId>
        <artifactId>derby</artifactId>
        <version>10.8.2.2</version>
        <scope>runtime</scope>
    </dependency>
    
    driver --> org.apache.derby.jdbc.EmbeddedDriver
    jdbc url --> jdbc:derby:testdb;create=true 
    hibernate.dialect --> org.hibernate.dialect.DerbyDialect
  • SQLite
    • Written in C
    • No native Hibernate support
  • DB4O
  • Berkeley DB

Hibernate Dialects:
https://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/dialect/package-summary.html

H2 vs HSQLDB
http://stackoverflow.com/questions/2746201/which-is-better-h2-or-hsqldb

Advertisements
Tagged with: , ,
Posted in Database, Hibernate, Java

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: