Looking for a powerful, reliable and feature-packed database engine that's also impressively easy to use? Look no further than H2 Database Engine, the Windows 7 software solution developed by H2. With lightning-fast performance, comprehensive support for a wide range of data types and an intuitive interface that makes even complex tasks a breeze, H2 Database Engine is the ideal choice for Windows users who demand the best from their software. Download H2 Database Engine today and experience the power of a truly exceptional database engine.

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)

New Release
Issue #4005: Add optional version to RANDOM_UUID function and generator of version 7 in addition to existing version 4
Issue #3945: Column not found in correlated subquery, when referencing outer column from LEFT JOIN .. ON clause
Issue #4097: StackOverflowException when using multiple SELECT statements in one query (2.3.230)
Issue #3982: Potential issue when using ROUND
Issue #3894: Race condition causing stale data in query last result cache
Issue #4075: infinite loop in compact
Issue #4091: Wrong case with linked table to postgresql
Issue #4088: BadGrammarException when the same alias is used within two different CTEs
Issue #4079: [2.3.230] Regression in ORDER BY ... DESC on dates
[ H2 Database Engine release history ]

Hyperlink code:
Hyperlink and Intro code:
Hyperlink for Forum code:

All H2 Database Engine reviews, submitted ratings and written comments become the sole property of Windows 7 download. You acknowledge that you, not windows7download, are responsible for the contents of your submission. However, windows7download reserves the right to remove or refuse to post any submission for any reason.

Windows 7 Download periodically updates pricing and software information of H2 Database Engine full version from the publisher, but some information may be out-of-date. You should confirm all information.
Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for H2 Database Engine license key is illegal and prevent future development of H2 Database Engine. Download links are directly from our mirrors or publisher's website, H2 Database Engine torrent or shared files from free file sharing and free upload services, including Rapidshare, MegaUpload, YouSendIt, SendSpace, DepositFiles, DivShare, HellShare, HotFile, FileServe or MediaFire, are not used.