Page History

...

To create a new embedded database in Geronimo the DB Manager portlet is available. Near the bottom of the Console Navigation menu navigate through Embedded DB -> DB Manager. This portlet trigers triggers the DB Viewer and Run SQL portlets illustrated in the following figures.

Image Removed

The DB Viewer portlet displays all the available databases, their tables (application and system) and displays the contents of the tables. Click on the Application link to work with database application tables. Click on the System link to work with database system tables.

Image Added

The RunSQL portlet allows you to create or delete databases, or run SQL commands against a given database. The SQL commands allow you to create or delete databases and to modify the content of the tables. This portlet provides pull-down menus for selecting the database to which you want to run the command against, drop, or modify tables, and select, insert or delete rows from the database tables.

To create a test database specify test in the Create DB: field and click on Create. After a few seconds you should see a confirmation message near the bottom of the Run SQL portlet stating Database created: test. You should now see the test database entry in the DB Viewer portlet.

...