H2 Database Engine 1.3.148 Beta

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : Other Free / Open Source License - H2 License
CreatedCreated : Dec 29, 2010
Size downloadDownloads : 5
Program licensing
Thank you for voting...

The download package comes with advanced ...

The download package comes with advanced documentation and the database's source code.
A Windows version (exe file) can be downloaded from here.
Most important functions of H2 Database Engine by H2 Group:

Main Features:

• Very fast database_engine

• Open source

• Written in Java

support standard SQL, JDBC API

• Embedded and Server mode, Clustering support

• Strong security features

• The PostgreSQL ODBC driver can be used

• Multi version concurrency

• In-memory databases

• Browser based console application

• Small footprint, around 1 MB jar file size.

• Pure Java

• Memory Mode

• Encrypted Database

• ODBC Driver

• Fulltext Search

Additional Features:

• Disk based or in-memory databases and tables, read-only database support, temporary tables

• Transaction support (read committed and serializable transaction isolation), 2-phase-commit

• Multiple connections, table level locking

• Cost based optimizer, using a genetic algorithm for complex queries, zero-administration

• Scrollable and updatable result set support, large result set, external result sorting, functions can return a result set

• Encrypted database (AES or XTEA), SHA-256 password encryption, encryption functions, SSL

SQL Support:

• Support for multiple schemas, information schema

• Referential integrity / foreign key constraints with cascade, check constraints

• Inner and outer joins, subqueries, read only views and inline views

• Triggers and Java functions / stored procedures

• Many built-in functions, including XML and lossless data compression

• Wide range of data types including large objects (BLOB/CLOB) and arrays

• Sequence and autoincrement columns, computed columns (can be used for function based indexes)

• ORDER BY, GROUP BY, HAVING, UNION, LIMIT, TOP

• Collation support, users, roles

• Compatibility modes for IBM DB2, Apache Derby, HSQLDB, MS SQL Server, MySQL, Oracle, and PostgreSQL.

Security Features:

• Includes a solution for the SQL injection problem

• User password authentication uses SHA-256 and salt

• For server mode connections, user passwords are never transmitted in plain text over the network (even when using insecure connections; this only applies to the TCP server and not to the H2 Console however; it also doesn't apply if you set the password in the database URL)

• All database files (including script files that can be used to backup data) can be encrypted using AES-128 and XTEA encryption algorithms

• The remote JDBC driver supports TCP/IP connections over SSL/TLS

• The built-in web server supports connections over SSL/TLS

• Passwords can be sent to the database using char arrays instead of Strings

Other Features and Tools:

• Small footprint (smaller than 1 MB), low memory requirements

• Multiple index types (b-tree, tree, hash)

• Support for multi-dimensional indexes

• CSV (comma separated values) file support

• Support for linked tables, and a built-in virtual 'range' table

• EXPLAIN PLAN support, sophisticated trace options

• Database closing can be delayed or disabled to improve the performance

• Web-based Console application (translated to many languages) with autocomplete

• The database can generate SQL script files

• Contains a recovery tool that can dump the contents of the database

• Support for variables (for example to calculate running totals)

• Automatic re-compilation of prepared statements

• Uses a small number of database files

• Uses a checksum for each record and log entry for data integrity

• Well tested (high code coverage, randomized stress tests)
News in the current H2 Database Engine 1.3.148 Beta version:

• The built-in connection pool was simplified a bit. The dispose() method no longer throws an exception (it only logs it).

• The database upgrade (to upgrade from H2 version 1. 1. x) has been simplified.

• The feature to log all errors (system properties h2. logAllErrors and h2. logAllErrorsFile) has been removed.

• When starting the H2 Console, the properties file can now be completely disabled.

• Server. openBrowser no longer writes to System. out directly if opening the URL failed.

• The INSERT optimizations (INSERT . . . DIRECT SORTED SELECT) were not parsed correctly when using a column list.

• H2 Console: the tables and columns are now listed for SQLite as well.

• H2 Console: improved autocomplete feature (also simplified the source code for this feature).

• The DbStarter servlet context listener now starts the server before opening a connection, so that connecting using the server mode works.

• The Shell tool can now enable, disable, and display the current autocommit mode.

• There is a limitation in the cluster mode: The SQL statement SET AUTOCOMMIT FALSE doesn't work. To disable autocommit, the method Connection. setAutoCommit(false) needs to be called. This is now documented. See also issue 259.

• Connection pool / DataSource: a NullPointerException was thrown when using a database URL that doesn't start with "jdbc:h2:".

• Using the java. sql. Blob or java. sql. Clob interfaces could throw the wrong exception after the object was closed.

• LOB: in server mode, if the feature "LOBs in database" is disabled, the temporary files are now created in the temp directory (the same as when "LOBs in database" is enabled).

H2 Database Engine 1.3.148 Beta scripting tags: console, data storage, sql interpreter, engine, database engine, support. What is new in H2 Database Engine 1.3.148 Beta software script? - Unable to find H2 Database Engine 1.3.148 Beta news. What is improvements are expecting? Newly-made H2 Database Engine 1.4 will be downloaded from here. You may download directly. Please write the reviews of the H2 Database Engine. License limitations are unspecified.