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 Sun, 21 Nov 2010 07:04: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 (1)</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" >!databasePoolDriver.png! <br>\\
<br></td></tr>
            <tr><td class="diff-changed-lines" ># 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. <span class="diff-added-words"style="background-color:
#dfd;">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|Administering users and groups#changingpasswordforderyadimin|change
the default password] if necessary. For datasources created using blank username and password,
you must update the values of those 2 parameters as _APP_ and _APP_ to access relevant databases
properly. See [accessing user defined databases|Administering users and groups#accessinguserdefinedderbydatabases|accessing
user defined databases] for more details.</span> <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br>!databasePoolPlan.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. Starting from 2.1.7, you can secure the connections
to the embedded Derby databases using <em>geronimo-admin</em> security realm.
The default user name is <b>dbadmin</b> and the password <b>manager</b>.
You can always <a href="/confluence/display/GMOxDOC21/Administering+users+and+groups#Administeringusersandgroups-changingpasswordforderyadimin"
title="change the default password">change the default password</a> if necessary.
For datasources created using blank username and password, you must update the values of those
2 parameters as <em>APP</em> and <em>APP</em> to access relevant databases
properly. See <a href="/confluence/display/GMOxDOC21/Administering+users+and+groups#Administeringusersandgroups-accessinguserdefinedderbydatabases"
title="accessing user defined databases">accessing user defined databases</a> for
more details.
<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=9&originalVersion=8">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