Mac DownloadsDevelopmentJavaH2 Database Engine 0.9

H2 Database Engine 0.9


H2 is an SQL database engine written in Java (but also available as a native binary).
Developer:   H2
      more software by author →
Price:  0.00
License:   Freeware
File size:   3720K
Language:   
OS:   
Rating:   0 /5 (0 votes)
Your vote:  
enlarge screenshot


H2 is an SQL database engine written in Java (but also available as a native binary). JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported. H2 Database Engine is a web based java database engine.

Here are some key features of "H2 Database Engine":
  • Fast database engine
  • Free, source code is included
  • Supports standard SQL
  • Written in Java
  • Disk based or in-memory databases
  • Browser base Console application
  • JDBC API
  • Limited ODBC support
  • Embedded and client/server (network) mode
  • High availablility support (clustering / failover)
  • Wide range of data types including large objects (BLOB/CLOB)
  • Strong security features (SSL, users, roles, encrypted files)
  • Multiple connections, table level locking
  • Cost based optimizer, using a genetic algorithm for complex queries
  • Transaction support (serializable transaction isolation)
  • Zero-administration, automatic recovery
  • Large resultset, external sorting
  • Scrollable and updatable resultset support
  • Read only views and inline views
  • Inner and outer joins, subqueries
  • Many functions already built-in
  • Triggers and Java functions / stored procedures
  • Referential integrity / foreign key constraints with cascade, check constraints
  • Multiple schema support
  • Compatibility modes for HSQLDB, MySQL and PostgreSQL
  • Sequence and autoincrement columns
  • Well tested (high code coverage, randomized stress tests)
  • Small footprint (smaller than 1 MB)
  • Uses a small number of database files
  • Can be compiled to native code using GCJ
  • Primary keys, multiple index types (b-tree, linear hash, tree, hash)
  • ORDER BY, GROUP BY, HAVING, UNION, LIMIT
  • Information Schema
  • Multiple connections
  • Collation support
  • EXPLAIN PLAN support
  • The database can generate SQL script files
  • Support for linked tables, and a built-in virtual 'range' table
  • Automatic re-compilation of prepared statements
  • Sophisticated trace options
  • Low memory requirements
  • Easy to understand exception messages
  • Standard handling of NULL values
  • Multilanguage console application (at this time, English and German).
    tags database engine  console application  multiple connections  embedded and  


    Download H2 Database Engine 0.9


     http://www.h2database.com/h2.zip


    Authors software

    Similar software

    H2 Database Engine 0.9 (by H2)
    H2 is an SQL database engine written in Java (but also available as a native binary).

    DbVisualizer 5.1.1 (by Minq Software AB)
    DbVisualizer is a cross-platform database visualization and management tool which entirely relies on the JDBC, Java Database Connectivity APIs.

    Oracle Berkeley DB Java Edition 3.0.11 (by Oracle)
    Oracle Berkeley DB Java Edition is a high performance, transactional storage engine written entirely in Java.

    OpenBase SQL 10.0.4 (by OpenBase International)
    OpenBase SQL database engine provides high-performance data storage and retrieval for demanding multi-user applications.

    SQL4X Manager J 3.5 (by InterServices New Media)
    SQL4X Manager J is the professional tool to access and manage your database server with Mac OS X.

    Navicat PostgreSQL Manager 6.3.1 (by PremiumSoft)
    Navicat is a powerful PostgreSQL database administration and development tool that is not only sophisticated enough for professional developers, but also easy to learn for new users.

    MySQL 5.0.26 (by MySQL AB)
    MySQL, the most popular Open Source SQL database, is provided by MySQL AB.

    RazorSQL 3.7 (by Richardson Software)
    Query, update, navigate and manage databases from one database client.

    iSQL-Viewer 2.1.8 (by Mark A. Kobold)
    iSQL-Viewer is an open-source JDBC 2.

    DeebeeX 1.1 (by abstracture IT-Beratung GmbH)
    There don't seem to be many database viewers around for OSX that support Oracle.


    Other software in this category

    JDock 1.4 (by JAPISoft)
    A pure java/swing framework for managing/moving/resizing inner windows or components using a layout manager like a BorderLayout or a GridBagLayout.

    JasperAssistant 2.2 (by Peter Severin)
    JasperAssistant is a visual report designer for JasperReports, a popular open-source reporting engine.

    ClassFinder 1.0.0 (by Red Room Development)
    Are you a Java developer who has come across the ClassNotFoundException and aren't sure which jar file is needed to add to the classpath? Let ClassFinder give you a hand.

    Big Faceless Report Generator 1.1.27 (by Big Faceless Organization)
    The Big Faceless Report Generator is a Java application for converting source documents written in XML to PDF.

    SearchBlox Server 3.2 (by Robert Selvaraj)
    SearchBlox is a high-performance Content Search Software designed for corporate intranets, websites, Portals and custom-applications.

  •     search


    Featured Software

    Picture Address Book 6.0.5
    Apimac Address Book is a practical telephone and address program for Mac that allows you to quickly and easily manage addresses, phone numbers, URLs and Email addresses.

    Textris 1.0
    Textris is an attempt to combine aspects of both these games into one fast paced test of your lexicon.

    iMagine Photo 2.1.4
    iMagine Photo adds imaging and drawing functionality to AppleScript.


    Subscribe in Rojo
    Google Reader
    Add to My Yahoo!

    Add to My AOL
    Subscribe with Bloglines
    Subscribe in NewsGator Online
    Add 'rbytes.net free downloads' to Newsburst from CNET News.com
    del.icio.us rbytes.net free downloads


    Top tags

    modem drivers   dvd player   sound keys   keys   apple   server   midi   dashboard widgets   slimserver   checksum