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 new database pools
Date Wed, 10 Nov 2010 03:35: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+new+database+pools">Create
new database pools</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 (4)</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" >You can create new pools by clicking
the *Using the Geronimo database pool wizard* link on the Database Pools portlet. This wizard
will guide you through a four easy steps procedure. <br> <br></td></tr>
            <tr><td class="diff-changed-lines" ><span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">First</span>
<span class="diff-added-words"style="background-color: #dfd;">#</span> you need
to specify the name of the database pool and the database type. <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br></td></tr>
            <tr><td class="diff-unchanged" >!databasePoolCreate.png! <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br></td></tr>
            <tr><td class="diff-changed-lines" ><span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">Then</span>
<span class="diff-added-words"style="background-color: #dfd;">#</span> 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]. <span class="diff-added-words"style="background-color: #dfd;">If you are
creating a database pool for the embedded Derby engine, make sure that *User Name* and *Password*
fields are specified as _dbadmin_ and _manager_.</span> <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br></td></tr>
            <tr><td class="diff-unchanged" >!databasePoolDriver.png! <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br></td></tr>
            <tr><td class="diff-changed-lines" ><span class="diff-added-words"style="background-color:
#dfd;">#</span> The following figure shows the *Deployment Plan* 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></td></tr>
            <tr><td class="diff-unchanged" >\\ <br></td></tr>
            <tr><td class="diff-unchanged" >!databasePoolPlan.png! <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br></td></tr>
            <tr><td class="diff-changed-lines" ><span class="diff-added-words"style="background-color:
#dfd;">#</span> When you successfully tested the connection, click on *Deploy*. Alternatively
you can click on *Show Plan*, 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 [Configuring DB2 Datasource] section. <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br></td></tr>
            <tr><td class="diff-unchanged" >!databasePoolDeployed.png! <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>. If you are creating
a database pool for the embedded Derby engine, make sure that <b>User Name</b>
and <b>Password</b> fields are specified as <em>dbadmin</em> and <em>manager</em>.
<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+new+database+pools">View
Online</a>
        |
        <a href="https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=77582&revisedVersion=4&originalVersion=3">View
Changes</a>
                |
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC21/Create+new+database+pools?showComments=true&amp;showCommentArea=true#addcomment">Add
Comment</a>
            </div>
</div>
</div>
</div>
</div>
</body>
</html>

Mime
View raw message