H2 Database Engine 1.3.159

Size 4.174 MB   0 seeders     Added 2011-08-17 17:29:22

To download or stream you need BitLord. Visit them at BitLord.com
SQL database engine written in Java

JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported. 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
· 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)
· 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)
What's New in This Release: [ read full changelog ]

· Creating a temporary table with the option 'transactional' will now also create the indexes in transactional mode, if the indexes are included in the 'create table' statement as follows: "create local temporary table temp(id int primary key, name varchar, constraint x index(name)) transactional".
· The database file size grows now 35%, but at most 256 MB at a time.
· Improved error message on network configuration problems.
· The build now support an offline build using ./build.sh offline. This will list the required dependencies if jar files are missing.
· The BLOB / CLOB data was dropped a little bit before the table was dropped. This could cause "lob not found" errors when the process was killed while a table was dropped.
· "group_concat(distinct ...)" did not work correctly in a view or subquery (the 'distinct' was lost). Example: select * from (select group_concat(distinct 1) from system_range(1, 3));
· Database URLs can now be re-mapped to another URL using the system property ...
h2-database-engine-1.3.159.exe 4.174 MB
Gathering some info...

Register and log in Isohunt and see no captcha anymore!

4000 symbols left
Hash 3532290febefb9fd43b9452028d81a28bd0b9ecb