THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Excerpt |
|---|
This topic is about how to create a new embedded database in Geronimo with available DB Manager and configure the location of embedded Derby system database to another location instead of the default |
| Table of Contents |
|---|
Creating a new database
Near the bottom of the Console Navigation menu navigate through Embedded DB -> DB Manager. This portlet triggers the DB Viewer and Run SQL portlets illustrated in the following figures.
...
If you want to run any SQL command on this database make sure you select test from the Use DB: pull-down menu, enter the SQL command and then click the Run SQL button. The results of the command will be displayed near the bottom of the portlet.
Configuring the location of system Derby databases
By default, all system databases are created in the /var/derby directory when Geronimo server starts up for the first time. You can override the default derbySystemHome attribute of the DerbySystem GBean. Find the system-database module in /var/config/config.xml and it looks like as below:
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<module name="org.apache.geronimo.configs/system-database/2.2/car">
<gbean name="DerbyNetwork">
<attribute name="host">${ServerHostname}</attribute>
<attribute name="port">${DerbyPort + PortOffset}</attribute>
</gbean>
<gbean name="DerbySystem">
<attribute name="derbySystemHome">var/derby</attribute>
</gbean>
</module>
|
Note that derbySystemHome can be configured to an absolute location or a relative one.