Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Back to Top

Create a database

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

Image Added
Image Added

The DB Viewer portlet displays all the available databases, their tables (application and system) and displays the contents of the tables.

The RunSQL portlet allows you to run SQL commands 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.

To create a test database specify Derby_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: Derby_Test*. You should see now the Derby_Test entry in the DB Viewer portlet.

If you want to run any SQL command on this database make sure you select Derby_Test from the Use DB: pull-down menu, enter the SQL command and then click on the Run SQL button. The results of the command will be displayed near the bottom of the protlet.

Configuring JMS

Connection factories, queues, topics and destinations.

Full detailed JMS configuration example is covered in the Configure JMS section.

Back to Top

Administering applications

...