Red Hat

Developer Materials

h2-console: Example Using the H2 Console with JBoss EAP

  • Author:
  • Contributors: Sande Gilda
  • Published: Feb 03, 2015
  • Level: Beginner
  • Technologies:H2
  • Target Product:JBoss EAP

What is it?

Red Hat JBoss Enterprise Application Platform bundles H2 as an in-memory, in-process database. H2 is written in Java so it can run on any platform that JBoss EAP runs on.

The h2-console quickstart comes bundled with a version of the H2 Console built for JBoss EAP. To make the H2 console run on JBoss EAP, the H2 libraries were removed from the WAR and a dependency on the H2 module was added to the META-INF/MANIFEST.MF file. The rebuilt console is provided in the root directory of this quickstart.

This quickstart demonstrates how to use the H2 console with Red Hat JBoss Enterprise Application Platform. It uses the greeter quickstart as a GUI for entering data.

Note: This quickstart uses the H2 database included with Red Hat JBoss Enterprise Application Platform 6. It is a lightweight, relational example datasource that is used for examples only. It is not robust or scalable, is not supported, and should NOT be used in a production environment!

System requirements

The application this project produces is designed to be run on Red Hat JBoss Enterprise Application Platform 6.1 or later.

All you need to build this project is Java 6.0 (Java SDK 1.6) or later, Maven 3.0 or later.

Configure Maven

If you have not yet done so, you must Configure Maven before testing the quickstarts.


This quickstart depends on the deployment of the greeter quickstart. Before running this quickstart, see the greeter README file for details on how to deploy it.

You can verify the deployment of the greeter quickstart by accessing the following URL: http://localhost:8080/jboss-greeter


In the following instructions, replace EAP_HOME with the actual path to your JBoss EAP 6 installation. The installation path is described in detail here: Use of EAP_HOME and JBOSS_HOME Variables.

Deploy the H2 Console

Deploy the console by copying the h2console.war located in the root directory of this quickstart to the EAP_HOME/standalone/deployments directory.

Access the H2 Console

You can access the console at the following URL: http://localhost:8080/h2console.

You need to enter the JDBC URL, and credentials. To access the "test" database that the greeter quickstart uses, enter these details:

  • JDBC URL: jdbc:h2:mem:greeter-quickstart;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1
  • User Name: sa
  • Password: sa

Click on the Test Connection button to make sure you can connect. If you can, go ahead and click Connect.

Investigate the H2 Console

Take a look at the data added by the greeter application. Run the following SQL command:

    select * from users;

You should see the two users seeded by the greeter quickstart, plus any users you added when testing that application.

Server Log: Expected warnings and errors

Note: You will see the following warnings in the server log. You can ignore this warning.

    JBAS018568: Deployment "deployment.h2console.war" is using an unsupported module ("com.h2database.h2:main") which may be changed or removed in future versions without notice.

Recent Changelog

  • Feb 3, 2015(Sande Gilda):Bz1188379 Update warnings for H2 and use of ds.xml files
  • Feb 3, 2015(Sande Gilda):Update the quickstart README files to point to the new shared EAP_HOME and Build and Deploy instructions
  • Dec 18, 2014(Sande Gilda):Bz1092026 Update README Target Product metadata value remove Product Versions metadata and make sure the full product name is near the top of the files
  • Dec 18, 2014(Sande Gilda):Bz1175766 Add warning about H2 database to quickstarts where it is missing. Also update the message to use full product name
  • Nov 24, 2014(Sande Gilda):Bz1167332 Fix typo in h2 console README file
  • Nov 6, 2014(Sande Gilda):Fix typos resulting from google search changes
  • Nov 6, 2014(Sande Gilda):Bz1160776 prepare for google search and fix typos
  • Sep 24, 2014(Sande Gilda):Bz1146050 Add EAP 6.4 to the product version
  • Jun 2, 2014(Sande Gilda):Bz1097788 Move EAP_HOME details to root README file
  • May 14, 2014(Sande Gilda):Bz1097788 Clarify h2 console deployment path instructions
Your Rating: