geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From conflue...@apache.org
Subject [CONF] Apache Geronimo v3.0 > Using the Geronimo database pool wizard
Date Sun, 30 Jan 2011 03:36:00 GMT
<html>
<head>
    <base href="https://cwiki.apache.org/confluence">
            <link rel="stylesheet" href="/confluence/s/2036/9/4/_/styles/combined.css?spaceKey=GMOxDOC30&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/GMOxDOC30/Using+the+Geronimo+database+pool+wizard">Using
the Geronimo database pool wizard</a></h2>
    <h4>Page <b>edited</b> by             <a href="https://cwiki.apache.org/confluence/display/~maojia508">maojia</a>
    </h4>
        <br/>
                         <h4>Changes (11)</h4>
                                 
    
<div id="page-diffs">
                    <table class="diff" cellpadding="0" cellspacing="0">
    
            <tr><td class="diff-unchanged" >{scrollbar} <br> <br></td></tr>
            <tr><td class="diff-changed-lines" >You can create new <span class="diff-added-words"style="background-color:
#dfd;">database</span> pools by clicking the *Using the Geronimo database pool wizard*
link on the Database Pools <span class="diff-changed-words">portlet<span class="diff-added-chars"style="background-color:
#dfd;"> from the administration console</span>.</span> This wizard will walk
you through an easy four-step procedure. <br></td></tr>
            <tr><td class="diff-unchanged" > <br></td></tr>
            <tr><td class="diff-deleted-lines" style="color:#999;background-color:#fdd;text-decoration:line-through;">First
you specify the name of the database pool and the database type. <br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">#
Specify the *Name of Database Pool* and the *Database Type*. Then click *Next*. <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-deleted-lines" style="color:#999;background-color:#fdd;text-decoration:line-through;">Then
you select the JDBC drivers, which by default have been pre-filled based on the database type
you selected in the previous step. You must select the driver JAR from the scroll-down menu
and also specify the database name. For this example a *test* database was previously created,
this is a single step procedure and it is explained in [Creating a database in Geronimo].
<br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">#
In the next step, you must select the *Driver JAR*. For this example, from the *Driver JAR*
field, select the JDBC drivers, which by default have been pre-filled based on the database
type that you selected in the previous step. If the *Driver JAR* that you require does not
exist, you can choose to download a driver by clicking the *Download a Driver* button. <br></td></tr>
            <tr><td class="diff-unchanged" >\\
\\ <br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">Specify
a database in the *Database Name* field for the database pool to connect to. Set *true* for
*Create Database* so that a database will be created if it dose not already exist. Alternatively,
you can create a database manually with a single step procedure explained in [Creating a database
in Geronimo]. You can click *Deploy* to deploy this database pool. Alternatively, you can
click *Show Plan* to see or edit the deployment plan for this database pool.  <br>\\
<br></td></tr>
            <tr><td class="diff-unchanged" >!databasePoolDriver.png! <br></td></tr>
            <tr><td class="diff-deleted-lines" style="color:#999;background-color:#fdd;text-decoration:line-through;">The
following figure shows the *Deployment Plan* for the selected database. This plan contains
the pool type, connector interface and the connection factory options from the setup properties.
<br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">#
If you clicked *Show Plan* in the previous step, you will see the *Deployment Plan* for the
selected database pool as follows. This plan contains the pool type, connector interface,
and the connection factory options from the setup properties. You can click *Edit Settings*
to return to the previous step to modify your settings or click *Deploy Pool* to deploy the
deployment plan for your database pool. <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-added-lines" style="background-color: #dfd;">\\
<br># After a successful deployment, you will see the new database pool listed on the
*Database Pools* portlet as follows. Additional instructions about how to manually deploy
a DB plan can be found in the [Configuring a DB2 datasource] section. <br></td></tr>
            <tr><td class="diff-unchanged" > <br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">\\
<br>\\ <br></td></tr>
            <tr><td class="diff-changed-lines" >When you successfully tested the
connection, click *Deploy*. Alternatively, you can click *Show Plan* to see or edit the deployment
plan for this database pool. Additional instructions <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">on</span>
<span class="diff-added-words"style="background-color: #dfd;">about</span> how
to manually deploy a DB plan might be found in the [Configuring a DB2 datasource] section.
<br></td></tr>
            <tr><td class="diff-unchanged" > <br>!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/GMOxDOC30/Removing+database+pools"><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/GMOxDOC30/Removing+database+pools">Removing
database pools</a>&nbsp;</td><td width='33%' class='ScrollbarParent'><sup><a
href="/confluence/display/GMOxDOC30/Configuring+datasource"><img border='0' align='middle'
src='/confluence/images/icons/up_16.gif' width='8' height='8'></a></sup><a
href="/confluence/display/GMOxDOC30/Configuring+datasource">Configuring datasource</a></td><td
width='33%' class='ScrollbarNextName'>&nbsp;</td></tr></table></div>

<p>You can create new database pools by clicking the <b>Using the Geronimo database
pool wizard</b> link on the Database Pools portlet from the administration console.
This wizard will walk you through an easy four-step procedure.</p>

<ol>
	<li>Specify the <b>Name of Database Pool</b> and the <b>Database
Type</b>. Then click <b>Next</b>.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/20645323/databasePoolCreate.png?version=1&amp;modificationDate=1203703853000"
style="border: 0px solid black" /></span>
<br class="atl-forced-newline" /></li>
	<li>In the next step, you must select the <b>Driver JAR</b>. For this example,
from the <b>Driver JAR</b> field, select the JDBC drivers, which by default have
been pre-filled based on the database type that you selected in the previous step. If the
<b>Driver JAR</b> that you require does not exist, you can choose to download
a driver by clicking the <b>Download a Driver</b> button.
<br class="atl-forced-newline" />
Specify a database in the <b>Database Name</b> field for the database pool to
connect to. Set <b>true</b> for <b>Create Database</b> so that a database
will be created if it dose not already exist. Alternatively, you can create a database manually
with a single step procedure explained in <a href="/confluence/display/GMOxDOC30/Creating+a+database+in+Geronimo"
title="Creating a database in Geronimo">Creating a database in Geronimo</a>. You
can click <b>Deploy</b> to deploy this database pool. Alternatively, you can click
<b>Show Plan</b> to see or edit the deployment plan for this database pool. 
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/20645323/databasePoolDriver.png?version=1&amp;modificationDate=1243990990000"
style="border: 0px solid black" /></span>
<br class="atl-forced-newline" /></li>
	<li>If you clicked <b>Show Plan</b> in the previous step, you will see
the <b>Deployment Plan</b> for the selected database pool as follows. This plan
contains the pool type, connector interface, and the connection factory options from the setup
properties. You can click <b>Edit Settings</b> to return to the previous step
to modify your settings or click <b>Deploy Pool</b> to deploy the deployment plan
for your database pool.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/20645323/databasePoolPlan.png?version=1&amp;modificationDate=1243990998000"
style="border: 0px solid black" /></span>
<br class="atl-forced-newline" /></li>
	<li>After a successful deployment, you will see the new database pool listed on the
<b>Database Pools</b> portlet as follows. Additional instructions about how to
manually deploy a DB plan can be found in the <a href="/confluence/display/GMOxDOC30/Configuring+a+DB2+datasource"
title="Configuring a DB2 datasource">Configuring a DB2 datasource</a> section.</li>
</ol>


<p><br class="atl-forced-newline" />
<br class="atl-forced-newline" />
When you successfully tested the connection, click <b>Deploy</b>. Alternatively,
you can click <b>Show Plan</b> to see or edit the deployment plan for this database
pool. Additional instructions about how to manually deploy a DB plan might be found in the
<a href="/confluence/display/GMOxDOC30/Configuring+a+DB2+datasource" title="Configuring
a DB2 datasource">Configuring a DB2 datasource</a> section.</p>

<p><span class="image-wrap" style=""><img src="/confluence/download/attachments/20645323/databasePoolDeployed.png?version=1&amp;modificationDate=1243991005000"
style="border: 0px solid black" /></span></p>
    </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/GMOxDOC30/Using+the+Geronimo+database+pool+wizard">View
Online</a>
        |
        <a href="https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=20645323&revisedVersion=2&originalVersion=1">View
Changes</a>
                |
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC30/Using+the+Geronimo+database+pool+wizard?showComments=true&amp;showCommentArea=true#addcomment">Add
Comment</a>
            </div>
</div>
</div>
</div>
</div>
</body>
</html>

Mime
View raw message