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 Dery database pool
Date Thu, 18 Nov 2010 04:16: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+Dery+database+pool">Create
a new Dery 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 (0)</h4>
                                 
    
<div id="page-diffs">
            <table class="diff" cellpadding="0" cellspacing="0">
            <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>. If you are creating
database pools for the embedded Derby databases in Geronimo217 or later versions, make sure
that <b>User Name</b> and <b>Password</b> fields are specified and
the user must be in the <b>derbyadmin</b> group.
<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+Dery+database+pool">View
Online</a>
        |
        <a href="https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=77582&revisedVersion=7&originalVersion=6">View
Changes</a>
                |
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC21/Create+a+new+Dery+database+pool?showComments=true&amp;showCommentArea=true#addcomment">Add
Comment</a>
            </div>
</div>
</div>
</div>
</div>
</body>
</html>

Mime
View raw message