windows9download

You Here : Home > Windows

H2 Database Engine 1.3.166

OS Support:

WinXP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64


Publisher

Publisher Old version

Update:

April 17 2012

Download:

H2 Database Engine 1.3.166


Description

    JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported. This is a client/server application, so both a server and a client (a browser) are required to run it.

If you start the server, you may get a security warning from the firewall (if you have installed one). If you don't want other computers in the network to access the application on your machine, you can let the firewall block those connections. The connection from the local machine will still work. Only if you want other computers to access the database on this computer, you need allow remote connections in the firewall.

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)


Related Downloads


  • H2 Database Engine 1.3.173
  • Very fast, open source, JDBC APIRequirements: Java Runtime Environment 5.0 or higherEditByBSEditor: Welcome to H2, the Java SQL database. The main features of H2 are: * Very fast, open source, JDBC API * Embedded and server modes; in-memory...

  • GestDB Version 2.4.000
  • GestDB is a program developed to help users with the access to different database engines at the same time and perform queries, modifications and data structure creations with its contents. <strong>How to install</strong>: &middot;...

  • Portable RazorSQL 5.2.5
  • The Portable RazorSQL application can help you query, update, navigate, and manage all major databases. With Portable RazorSQL, an SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, create, alter, and view...

    Software Tags

    Sql Database | Database Engine | Java Database | Sql | Database | Engine

    Size :

    Next/Pre