Skip to content

Latest commit

 

History

History
72 lines (39 loc) · 2.76 KB

README.md

File metadata and controls

72 lines (39 loc) · 2.76 KB
Raw

h2-console: Example Using the H2 Console with JBoss

Author: Pete Muir

What is it?

JBoss AS bundles H2 as an in-memory, in-process database. H2 is written in Java so can run on any platform JBoss AS runs.

This is quickstart shows you how to use the H2 console with JBoss Enterprise Platform 6 or JBoss AS 7. It uses the greeter quickstart as a GUI for entering data.

System requirements

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

The application this project produces is designed to be run on JBoss Enterprise Application Platform 6 or JBoss AS 7.

Configure Maven

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

Prerequisites

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-as-greeter

Note: Unlike most of the quickstarts, this one requires JBoss AS 7.1.x or later.

Deploy the H2 Console

This quickstart comes bundled with a version of the H2 Console built for JBoss Enterprise Application Platform 6 and JBoss AS 7. The changes that have been made to the stock console are described below.

Deploy the console by copying the QUICKSTART_HOME/h2-console/h2console.war to the $JBOSS_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:test;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.

Changes to the H2 Console for JBoss Enterprise Application Platform 6 and JBoss AS 7

To make the H2 console run on JBoss Enterprise Application Platform 6 and JBoss AS 7, the H2 libraries were removed from the WAR and a dependency on the H2 module was added to the META-INF/MANIFEST.MF fle. The rebuilt console is provided with this quickstart.