geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [CONF] Apache Geronimo v2.1 > Create a database
Date Fri, 18 Sep 2009 04:00:00 GMT
    <base href="">
            <link rel="stylesheet" href="/confluence/s/1519/1/1/_/styles/combined.css?spaceKey=GMOxDOC21&amp;forWysiwyg=true"
<body style="background-color: white" bgcolor="white">
<div id="pageContent">
<div id="notificationFormat">
<div class="wiki-content">
<div class="email">
     <h2><a href="">Create
a database</a></h2>
     <h4>Page <b>edited</b> by             <a href="">Ellen
     <div class="notificationGreySide">
         <style type='text/css'>/*<![CDATA[*/
table.ScrollbarTable  {border: none;padding: 3px;width: 100%;padding: 3px;margin: 0px;background-color:
table.ScrollbarTable td.ScrollbarPrevIcon {text-align: center;width: 16px;border: none;}
table.ScrollbarTable td.ScrollbarPrevName {text-align: left;border: none;}
table.ScrollbarTable td.ScrollbarParent {text-align: center;border: none;}
table.ScrollbarTable td.ScrollbarNextName {text-align: right;border: none;}
table.ScrollbarTable td.ScrollbarNextIcon {text-align: center;width: 16px;border: none;}

/*]]>*/</style><div class="Scrollbar"><table class='ScrollbarTable'><tr><td
class='ScrollbarPrevIcon'><a href="/confluence/display/GMOxDOC21/Configuring+Virtual+Hosts+in+Geronimo-Tomcat"><img
border='0' align='middle' src='/confluence/images/icons/back_16.gif' width='16' height='16'></a></td><td
width='33%' class='ScrollbarPrevName'><a href="/confluence/display/GMOxDOC21/Configuring+Virtual+Hosts+in+Geronimo-Tomcat">Configuring
Virtual Hosts in Geronimo-Tomcat</a>&nbsp;</td><td width='33%' class='ScrollbarParent'><sup><a
href="/confluence/display/GMOxDOC21/Administration"><img border='0' align='middle' src='/confluence/images/icons/up_16.gif'
width='8' height='8'></a></sup><a href="/confluence/display/GMOxDOC21/Administration">Administration</a></td><td
width='33%' class='ScrollbarNextName'>&nbsp;<a href="/confluence/display/GMOxDOC21/Geronimo+Administration+Console">Geronimo
Administration Console</a></td><td class='ScrollbarNextIcon'><a href="/confluence/display/GMOxDOC21/Geronimo+Administration+Console"><img
border='0' align='middle' src='/confluence/images/icons/forwd_16.gif' width='16' height='16'></a></td></tr></table></div>

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

<p><img src="/confluence/download/attachments/75625/DBViewer.gif" align="absmiddle"
border="0" /></p>

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

<p><img src="/confluence/download/attachments/75625/DBRunSQL.gif" align="absmiddle"
border="0" /></p>

<p>The <b>RunSQL</b> portlet allows you to create or delete databases, or
run SQL commands against a given database. The SQL commands allow you to create, drop, or
modify tables, and select, insert or delete rows from the database tables.</p>

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

<p>If you want to run any SQL command on this database make sure you select <b>test</b>
from the <b>Use DB:</b> pull-down menu, enter the SQL command and then click on
the <b>Run SQL</b> button. The results of the command will be displayed near the
bottom of the portlet.</p>
     <div id="commentsSection" class="wiki-content pageSection">
       <div style="float: right;">
            <a href=""
class="grey">Change Notification Preferences</a>

       <a href="">View
       <a href="">View
       <a href=";showCommentArea=true#addcomment">Add

View raw message