H2 - ArchWiki

  • Home
  • Packages
  • Forums
  • Wiki
  • GitLab
  • Security
  • AUR
  • Download
Jump to content

Contents

move to sidebar hide
  • Beginning
  • 1 Installation
  • 2 Web Console / DB Management
  • 3 TCP / PG Server
  • Page
  • Discussion
English
  • Read
  • View source
  • View history
Tools Tools move to sidebar hide Actions
  • Read
  • View source
  • View history
General
  • What links here
  • Related changes
  • Printable version
  • Page information
Appearance move to sidebar hide From ArchWiki

From the project home page: H2 is a small Java based relation database, featuring:

  • Very fast, open source, JDBC API
  • Embedded and server modes; in-memory databases
  • Browser based Console application
  • Small footprint: around 2 MB jar file size

Installation

Install the h2AUR package.

Web Console / DB Management

This will launch a web based interface on port 8082.

$ h2-console

TCP / PG Server

This will launch a web based interface on port 8082, TCP server on port 9092, and PG server (a server that follows the PostgreSQL protocol) on port 5435

$ java -cp /usr/share/java/h2/h2.jar org.h2.tools.Server

One can connect using a JDBC url such as jdbc:h2:tcp://192.168.103.128:9092/~/test.

Note The -ifNotExists flag can be used to generate an empty database. Retrieved from "https://wiki.archlinux.org/index.php?title=H2&oldid=726852" Category:
  • Relational DBMSs
Search Search Toggle the table of contents H2 Add topic

Từ khóa » H2 8082