H2
Using H2 in Kythia Workspace.
Kythia Workspace provides an automated, seamlessly integrated H2 environment.
Installing
Go to Databases -> H2
Select a version from the dropdown menu and click Install
Kythia will download the official H2 binaries directly to your local environment.
Default Connection
By default, H2 is configured to run on your localhost without conflict.
| Field | Value |
|---|---|
| Host | 127.0.0.1 |
| Port | 9092 |
| Username | sa |
| Password | (empty) |
Configuration
Kythia manages basic configurations for you automatically. If you need to make advanced changes, the configuration files for H2 are located at:
C:\kythia\bin\h2\{version}\conf\Data files (where your actual database records live) are stored safely at:
C:\kythia\data\h2\Logs
Log files are extremely useful for debugging failed queries or startup issues. They are located at:
C:\kythia\bin\h2\{version}\logs\You can also view the logs in real-time directly via the Logs button in the Kythia UI.
