H2 Database Engine 0.9

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

Developer:   H2
      software by H2 →
Price:  0.00
License:   Freeware
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

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.

H2 Database Engine features
  • 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  

    H2 Database Engine 0.9 screenshot


    Download H2 Database Engine 0.9

     Download H2 Database Engine 0.9


    Similar software

    H2 Database Engine 0.9 H2 Database Engine 0.9
    H2

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

    ODBC Database Engine ODBC Database Engine
    ITOS LTD.

    If you plan to use a database developed under Delphi or C++ Builder application and do not like to use BDE (Borland Database Engine) for it, you have gotten into the right place.

    RemoteDB Gateway 2.4.2 RemoteDB Gateway 2.4.2
    Nogginware Corporation

    RemoteDB Gateway is a SHAREWARE application which will let Java and native Windows applications access ODBC data sources configured on a remote computer.

    Universal JDBC Tree Navigator 1.1 beta Universal JDBC Tree Navigator 1.1 beta
    CyLog Software

    JDBC Tree Navigator is a Java-Swing application designed to help navigating tree structures in database tables.

    JDataConnect 3.0 JDataConnect 3.0
    JNetDirect

    JDataConnect application enables your organization to quickly connect Java applications to data sources for which only Open Database Connectivity (ODBC) database drivers exist.

    ODBC Router 1.0 ODBC Router 1.0
    August Software

    ODBC Router is leading software that connects all of your network's Mac, Linux and Windows systems with all of the databases throughout your enterprise, be they on Windows, Linux, Unix, minicomputer or even mainframe servers.

    HXTT Text (CSV) 3.1.003 HXTT Text (CSV) 3.1.003
    Hongxin Technology & Trade Ltd.

    HXTT Text (CSV) contains the only type 4 JDBC(1.

    PKLite SQL Client 2.0 Beta 3 PKLite SQL Client 2.0 Beta 3
    Pklite.sourceforge.net

    PKLite SQL Client is an Open Source Java SQL Client that can connect to any JDBC compliant database.

    JSQLConnect 5.54 JSQLConnect 5.54
    JNetDirect

    JSQLConnect application is the fastest, most reliable way to access Microsoft SQL Server products from your Java, .

    myBase SDK 5.2 myBase SDK 5.2
    Wjj Software

    myBase Software Developer Kit (SDK) includes both the cross-platform Freeform Database Engine (SSG) APIs and myBase Desktop 5.