Introduction

WOW install can be difficult for many customers because of having to install MYSQL or AS400 DB libraries and user profiles and passwords, then configure web.xml, etc... In addition, many companies have policies against installing new databases.

We can solve this issue by enabling a H2 database option that is embedded with WOW. No configuration or setup is required. This document describes how WOW developers and WOW users will interact with WOW installed with the H2 as the metadata provider.

WOW installation with H2

The install process will be simplified with H2. The standard process will be:

• 1. Install a Java JDK 1.6 or above.

  2. Install Tomcat 6 or above.

  3. For the installation of JDK and Tomcat instruction, Please refer to

  4. https://sites.google.com/a/planetjavainc.com/wow_builders_guide/home/getting-started/--wow-installation-instructions

  5. Unzip the WOW folder into <tomcat>/webapps

1. Go to .../wow74/WEB-INF and Delete the web.xml file then rename the h2-web.xml to web.xml

• 1. Start Tomcat

Accessing the WOW Builder

The WOW Builder is accessed by web browser. Open a browser (IE or Firefox are recommended, but WOW also works with Google’s Chrome browser as well) and start by entering the URL of your Tomcat server (http://localhost:8080/ from the example above), then attach the name of the webapp we installed (wow74) followed by a /, then wowBuilder (so the full URL of this example should look like this: http://localhost:8080/wow74/wowBuilder ) and hit the [Enter] key. If a website similar to the screen below loads, you have successfully set up the WOW Builder.

Creating connections with H2

In order to create a connection with H2 you need to

• 1. Select "H2 Database" in JDBC Driver dropdown

  2. Create an Alias for your connection

  3. Enter the user name and password.

  4. Default User information below:

  5. User ID - wow

  6. Password - wow

• 1. Click Insert Connection. Your connection is now set.

How to back-up your H2 Database with wow metadata

In order to back-up your H2 database that hold your wow metadata, you just need to secure a copy of h2.wow.metadata.h2.db located at the WEB-INF folder of your wow app.

Sharing H2 Database that holds the wow metadata

Sharing your database with wow metadata is now made easier with H2. You only needs to send the copy of h2.wow.metadata.h2.db to the other machine.

Rename/delete the h2.wow.metadata.h2.db in the WEB-INF of the destination machine.

Then paste the new h2.wow.metadata.h2.db to access the shared h2 DB with wow metadata.

Finally Restart your Tomcat Server and you can now access the shared H2 database with wow metadata.

Configuring Multiple WOW metadata with H2 in one Tomcat Server

In order to have multiple WOW metadata with H2 in one Tomcat Server, You need to delete the "wowconf" folder inside the WEB-INF of your all wow webapps.

That means deleting the wowconf folder in wow74, wow73 and other wow versions you have in you Tomcat Server.

After Deleting the wowconf folder you need to restart your Tomcat Server for the changes to take effect.

Once restarted you can now use Multiple WOW metadata with H2.