geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From conflue...@apache.org
Subject [CONF] Apache Geronimo v2.1 > Create a new Derby database pool
Date Thu, 18 Nov 2010 04:20:00 GMT
<html>
<head>
    <base href="https://cwiki.apache.org/confluence">
            <link rel="stylesheet" href="/confluence/s/1810/9/1/_/styles/combined.css?spaceKey=GMOxDOC21&amp;forWysiwyg=true"
type="text/css">
    </head>
<body style="background: white;" bgcolor="white" class="email-body">
<div id="pageContent">
<div id="notificationFormat">
<div class="wiki-content">
<div class="email">
    <h2><a href="https://cwiki.apache.org/confluence/display/GMOxDOC21/Create+a+new+Derby+database+pool">Create
a new Derby database pool</a></h2>
    <h4>Page <b>edited</b> by             <a href="https://cwiki.apache.org/confluence/display/~chirunhua@gmail.com">Runhua
Chi</a>
    </h4>
        <br/>
                         <h4>Changes (2)</h4>
                                 
    
<div id="page-diffs">
            <table class="diff" cellpadding="0" cellspacing="0">
            <tr><td class="diff-snipped" >...<br></td></tr>
            <tr><td class="diff-unchanged" >!databasePoolCreate.png! <br>\\
<br></td></tr>
            <tr><td class="diff-deleted-lines" style="color:#999;background-color:#fdd;text-decoration:line-through;">#
you select the JDBC drivers which, by default, it has been pre-filled based on the database
type you selected in the previous step. You also have to select the driver JAR from the scroll-down
menu and then specify the database name. For this example a *test* database was previously
created, this is a single step procedure and it is explained in [Configuring databases in
Geronimo]. If you are creating database pools for the embedded Derby databases in Geronimo217
or later versions, make sure that *User Name* and *Password* fields are specified and the
user must be in the *derbyadmin* group. <br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">#
you select the JDBC drivers which, by default, it has been pre-filled based on the database
type you selected in the previous step. You also have to select the driver JAR from the scroll-down
menu and then specify the database name. For this example a *test* database was previously
created, this is a single step procedure and it is explained in [Configuring databases in
Geronimo]. Starting from 2.1.7, you can secure the connections to the embedded Derby databases
using *geronimo-admin* security realm. The default user name is *dbadmin* and the password
*manager*. You can always change the default password if necessary. See [changing password
for dbadmin|Administering users and groups#changingpasswordforderbyadmin] for the details.
<br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br>!databasePoolDriver.png!
<br></td></tr>
            <tr><td class="diff-snipped" >...<br></td></tr>
        </table>
</div>                            <h4>Full Content</h4>
                    <div class="notificationGreySide">
        <style type='text/css'>/*<![CDATA[*/
table.ScrollbarTable  {border: none;padding: 3px;width: 100%;padding: 3px;margin: 0px;background-color:
#f0f0f0}
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+DB2+datasource"><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+DB2+datasource">Configuring
DB2 datasource</a>&nbsp;</td><td width='33%' class='ScrollbarParent'><sup><a
href="/confluence/display/GMOxDOC21/Configuring+database+pools"><img border='0' align='middle'
src='/confluence/images/icons/up_16.gif' width='8' height='8'></a></sup><a
href="/confluence/display/GMOxDOC21/Configuring+database+pools">Configuring database pools</a></td><td
width='33%' class='ScrollbarNextName'>&nbsp;<a href="/confluence/display/GMOxDOC21/Import+database+pools+from+JBoss+4">Import
database pools from JBoss 4</a></td><td class='ScrollbarNextIcon'><a
href="/confluence/display/GMOxDOC21/Import+database+pools+from+JBoss+4"><img border='0'
align='middle' src='/confluence/images/icons/forwd_16.gif' width='16' height='16'></a></td></tr></table></div>

<p>You can create new pools by clicking the <b>Using the Geronimo database pool
wizard</b> link on the Database Pools portlet. This wizard will guide you through a
four easy steps procedure.</p>

<ol>
	<li>you need to specify the name of the database pool and the database type.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/77582/databasePoolCreate.png?version=1&amp;modificationDate=1203703853000"
style="border: 0px solid black" /></span>
<br class="atl-forced-newline" /></li>
	<li>you select the JDBC drivers which, by default, it has been pre-filled based on
the database type you selected in the previous step. You also have to select the driver JAR
from the scroll-down menu and then specify the database name. For this example a <b>test</b>
database was previously created, this is a single step procedure and it is explained in <a
href="/confluence/display/GMOxDOC21/Configuring+databases+in+Geronimo" title="Configuring
databases in Geronimo">Configuring databases in Geronimo</a>. Starting from 2.1.7,
you can secure the connections to the embedded Derby databases using <b>geronimo-admin</b>
security realm. The default user name is <b>dbadmin</b> and the password <b>manager</b>.
You can always change the default password if necessary. See <a href="/confluence/display/GMOxDOC21/Administering+users+and+groups#Administeringusersandgroups-changingpasswordforderbyadmin">changing
password for dbadmin</a> for the details.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/77582/databasePoolDriver.png?version=1&amp;modificationDate=1203703853000"
style="border: 0px solid black" /></span>
<br class="atl-forced-newline" /></li>
	<li>The following figure shows the <b>Deployment Plan</b> for the selected
database. This plan contains the pool type and connector interface as well as the connection
factory options from the setup properties.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/77582/databasePoolPlan.png?version=1&amp;modificationDate=1203703853000"
style="border: 0px solid black" /></span>
<br class="atl-forced-newline" /></li>
	<li>When you successfully tested the connection, click on <b>Deploy</b>.
Alternatively you can click on <b>Show Plan</b>, this option shows you the deployment
plan for this database pool and lets you edit it. Additional instructions on how to manually
deploy a DB plan may be found in the <a href="/confluence/display/GMOxDOC21/Configuring+DB2+datasource"
title="Configuring DB2 datasource">Configuring DB2 datasource</a> section.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/77582/databasePoolDeployed.png?version=1&amp;modificationDate=1203703853000"
style="border: 0px solid black" /></span></li>
</ol>

    </div>
        <div id="commentsSection" class="wiki-content pageSection">
        <div style="float: right;">
            <a href="https://cwiki.apache.org/confluence/users/viewnotifications.action"
class="grey">Change Notification Preferences</a>
        </div>
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC21/Create+a+new+Derby+database+pool">View
Online</a>
        |
        <a href="https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=77582&revisedVersion=8&originalVersion=7">View
Changes</a>
                |
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC21/Create+a+new+Derby+database+pool?showComments=true&amp;showCommentArea=true#addcomment">Add
Comment</a>
            </div>
</div>
</div>
</div>
</div>
</body>
</html>

Mime
View raw message