H2 Description

H2, the Java SQL database, is your welcome. An embedded mode allows an application to open a database within the same JVM by using JDBC. This connection mode is the fastest and most convenient. However, a database can only be opened in one virtual machine (and a class loader) at a time. Both in-memory and persistent databases are supported, as in all modes. There is no limit to the number of databases that can be opened simultaneously or the number of connections. Mixed mode is a combination between the server and embedded modes. The first application to connect to a database uses embedded mode. However, it also starts a server so other applications (running in different processes and virtual machines) can simultaneously access the same data. The local connections are just as fast as if the data were used in embedded mode. Remote connections are slightly slower.

Integrations

Reviews

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Company Details

Company:
H2
Website:
www.h2database.com/html/main.html

Media

H2 Screenshot 1
Recommended Products
Secure your business by securing your people. Icon
Secure your business by securing your people.

Over 100,000 businesses trust 1Password

Take the guesswork out of password management, shadow IT, infrastructure, and secret sharing so you can keep your people safe and your business moving.

Product Details

Platforms
Windows
Mac
Linux
Type of Training
Documentation

H2 Features and Options

Database Software

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

Relational Database

ACID Compliance
Data Failure Recovery
Multi-Platform
Referential Integrity
SQL DDL Support
SQL DML Support
System Catalog
Unicode Support