Soft82.com » Windows » Developer Tools » Components & Libraries » H2 Database Engine 1.3.156

View screenshots

H2 Database Engine Description

Java SQL database

Main Features:

* Very fast database engine
* Open source
* Written in Java
* Supports standard SQL, JDBC API
* Embedded and Server mode, Clustering support
* Strong security features
* The PostgreSQL ODBC driver can be used
* Multi version concurrency

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)

H2 Database Engine Version History

H2 Database Engine Download Button For Your Site

If you want to place a Download Button for H2 Database Engine on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

H2 Database Engine User Reviews

New Components & Libraries Software

OWLNext May 25, 2012 A modern update and extension of Borland's Object Windows Library for writing GUI apps				Comm Operator Pal May 25, 2012 A free tool to test and debug RS232 devices that communicated with serial port, TCP/IP, UDP and
Witzend Thumbnail Image Viewer May 24, 2012 Accurately displays miniature thumbnail renderings of graphics files				PyBCI May 23, 2012 Create a Brain Comp. Interface (BCI) and herewith to get EEG data online
TMS Panels Pack May 23, 2012 A collection of panels, containers & tabs to make your applications stand out from the rest				SWI-Prolog Portable May 22, 2012 A comprehensive Free Software Prolog environment, licensed under the Lesser GNU Public License
Nevron User Interface for .NET May 22, 2012 Professional User Interface component suite for Windows Forms applications				Calibre May 21, 2012 E-book library management application
ShareWatcher May 21, 2012 ShareWatcher logs and notifies you when others access your shared folders				IntelliJ IDEA May 21, 2012 A code-centric IDE focused on developer productivity
Scikit Learn May 17, 2012 scikits.learn is a python library for machine learning				Fast File Download ActiveX May 17, 2012 An ActiveX component(ActiveX control) that can fast download files from the Internet
.Net Grid May 17, 2012 Productive and robust hierarchical grid with one of the best object models				Excel to PDF .Net May 17, 2012 A standalone component which allows any .Net application get professional export of Excel XLS files
Virtual 8085 May 16, 2012 A tool which enables students to run programs written in 8085 assembly language				dbExpress driver for MySQL May 16, 2012 A driver that provides fast access to MySQL databases.
GUI Design Studio Express May 16, 2012 A graphical user interface design tool for Microsoft Windows				PG4UW May 15, 2012 Common control program for Windows for all ELNEC programmers
dotConnect for Oracle Express Edition May 15, 2012 An enhanced ORM enabled data provider for Oracle that builds on ADO.NET				Wireless Communication Library MFC Developer May 15, 2012 Powerful C++ SDK which expands your applications with Bluetooth, IrDA, WiFi and Serial

Last 7 Days Most Downloaded Components & Libraries Products

Aircrack-ng GUI 158 downloads This is mainly just an interface tweak for Aircrack-ng				Microsoft Visual C++ 2008 Redistributable Package 51 downloads Installs runtime components of Visual C++ Libraries required to run 64-bit applications developed...
C++dbc 45 downloads A library to help you with database management.				ActiveX Download Control 41 downloads Support BreakPoint download,a client ActiveX control easy to realize the download batch files from...
Microsoft Visual C++ 2010 Service Pack 1 Compiler Update for the Windows SDK 38 downloads Restore the Visual C++ compilers and libraries that may have been removed				Grasshopper 30 downloads A Subversion reporting tool
Windows Imaging Component 28 downloads Provides WIC-enabled applications to display and edit any image format				Quake I port for Nokia Series 60 src 26 downloads Quake I port for Nokia Series 60 source code
Calibre 25 downloads E-book library management application				Headers and Libraries for Windows Internet Explorer 9 23 downloads Develop Windows applications that use Windows Internet Explorer 9

All Time Most Downloaded Components & Libraries Products

Aircrack-ng GUI 15,995 downloads This is mainly just an interface tweak for Aircrack-ng				Microsoft Visual C++ 2008 Redistributable Package 31,672 downloads Installs runtime components of Visual C++ Libraries required to run 64-bit applications developed...
C++dbc 16,731 downloads A library to help you with database management.				ActiveX Download Control 22,265 downloads Support BreakPoint download,a client ActiveX control easy to realize the download batch files from...
Microsoft Visual C++ 2010 Service Pack 1 Compiler Update for the Windows SDK 3,644 downloads Restore the Visual C++ compilers and libraries that may have been removed				Grasshopper 1,765 downloads A Subversion reporting tool
Windows Imaging Component 35,568 downloads Provides WIC-enabled applications to display and edit any image format				Quake I port for Nokia Series 60 src 7,846 downloads Quake I port for Nokia Series 60 source code
Calibre 5,756 downloads E-book library management application				Headers and Libraries for Windows Internet Explorer 9 3,577 downloads Develop Windows applications that use Windows Internet Explorer 9