H2 | Database Connectors | mindzieDataDesigner Documentation

Category: Database Connectors

Introduction

This document is created to help setup a mindzieDataDesigner connector to H2 database. The mindzieDataDesigner is the ETL tool used by mindzieStudio to convert database tables to process mining event logs. The purpose of this document is to help creating the connection string and opening ports on the firewall if required.

Overview

The H2 connector provides connectivity to H2 databases in various modes including embedded, server, and in-memory configurations. This connector is perfect for development environments, testing scenarios, and lightweight process mining applications.

System Requirements

Database System: H2 Database Engine 1.4 or later (2.x recommended)
Platform Support: Cross-platform (Java-based)
Dependencies: H2 database engine (included with connector)
Java Runtime: Java 8 or later

Connection String Format

Embedded Database

Data Source=jdbc:h2:~/database_name;User=sa;Password=;

Server Mode

Data Source=jdbc:h2:tcp://hostname:9092/database_name;User=sa;Password=password;

In-Memory Database

Data Source=jdbc:h2:mem:database_name;User=sa;Password=;

Connection Examples

Local File Database

Data Source=jdbc:h2:~/ProcessMining;User=sa;Password=;

Server Mode Connection

Data Source=jdbc:h2:tcp://h2server.company.com:9092/ProcessDB;User=mindzie_user;Password=SecurePassword123;

In-Memory Database (Testing)

Data Source=jdbc:h2:mem:testdb;User=sa;Password=;DB_CLOSE_DELAY=-1;

Encrypted Database

Data Source=jdbc:h2:~/SecureDB;CIPHER=AES;User=sa;Password=password file_password;

Troubleshooting

Common Issues

"Database not found" Error

Verify file path and permissions
Check if database files exist
Ensure proper database URL format

"Connection refused" Error (Server mode)

Verify H2 server is running
Check hostname and port configuration
Validate firewall and network settings

"Out of memory" Error

Increase JVM heap size
Optimize query performance
Consider using file-based instead of in-memory database

Official Documentation: H2 Database Documentation
H2 Console: Built-in web-based database administration tool
Migration Guide: H2 to Production Database Migration

💡 Tip: Use H2's compatibility modes to ease migration from H2 development databases to production database systems like PostgreSQL or MySQL.

H2