Initialization

Once you have installed the Expresso software & have the servlet server configured, you can automatically create the database tables that are required.

You should manually create the actual database that is referred to in your properties file (part of the dbURL is normally the database name). The name can be any valid name for a database. Do not create any tables in the database - Expresso will do that for you.

As soon as the database exists, you can verify Expresso's connection to it with the "Status" servlet, on the "Server" page.

Initializing the Database

The DBCreate servlet is used to perform the following actions:

1. Create the Tables in the database for each DBObject in Expresso
2. Create default entries in the SETUP database table for configuring your system
3. Create initial entries for security, including an "Admin" user and user group, and permission for this group to access all administrative functions.

See the Help file for Initialize (the DBCreate servlet) for details.

Once DBCreate is complete, you should Log In as "Admin". There will initially be no password for this user, one should be set immediately using the "Change Password" servlet on the Log In page.

When you are finished, you can go back to the Expresso Setup page and continue with the Verify Configuration step.