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.2 > Configuring a derby datasource
Date Mon, 22 Nov 2010 02:05:00 GMT
<html>
<head>
    <base href="https://cwiki.apache.org/confluence">
            <link rel="stylesheet" href="/confluence/s/1810/9/1/_/styles/combined.css?spaceKey=GMOxDOC22&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/GMOxDOC22/Configuring+a+derby+datasource">Configuring
a derby datasource</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-unchanged" >{scrollbar} <br> <br></td></tr>
            <tr><td class="diff-changed-lines" >You can create new pools by clicking
the *Using the Geronimo database pool wizard* link on the Database Pools portlet. This wizard
will walk you through an easy four-step <span class="diff-changed-words">procedure.<span
class="diff-added-chars"style="background-color: #dfd;">{excerpt}You can use the embedded
derby database and create a datasource for it.{excerpt}</span></span> <br></td></tr>
            <tr><td class="diff-unchanged" > <br>First you specify the name
of the database pool and the database type. <br></td></tr>
            <tr><td class="diff-snipped" >...<br></td></tr>
            <tr><td class="diff-unchanged" >!databasePoolCreate.png! <br>
<br></td></tr>
            <tr><td class="diff-changed-lines" >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 [Configuring databases in Geronimo]. <span class="diff-added-words"style="background-color:
#dfd;"> Starting from 2.2.1, 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 with 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>!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/GMOxDOC22/Configuring+a+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/GMOxDOC22/Configuring+a+DB2+datasource">Configuring
a DB2 datasource</a>&nbsp;</td><td width='33%' class='ScrollbarParent'><sup><a
href="/confluence/display/GMOxDOC22/Configuring+datasource"><img border='0' align='middle'
src='/confluence/images/icons/up_16.gif' width='8' height='8'></a></sup><a
href="/confluence/display/GMOxDOC22/Configuring+datasource">Configuring datasource</a></td><td
width='33%' class='ScrollbarNextName'>&nbsp;<a href="/confluence/display/GMOxDOC22/Configuring+a+MySQL+datasource">Configuring
a MySQL datasource</a></td><td class='ScrollbarNextIcon'><a href="/confluence/display/GMOxDOC22/Configuring+a+MySQL+datasource"><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 walk you through an
easy four-step procedure.You can use the embedded derby database and create a datasource for
it.</p>

<p>First you specify the name of the database pool and the database type.</p>

<p><span class="image-wrap" style=""><img src="/confluence/download/attachments/93294/databasePoolCreate.png?version=1&amp;modificationDate=1203703853000"
style="border: 0px solid black" /></span></p>

<p>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 <b>test</b>
database was previously created, this is a single step procedure and it is explained in <a
href="/confluence/display/GMOxDOC22/Configuring+databases+in+Geronimo" title="Configuring
databases in Geronimo">Configuring databases in Geronimo</a>.  Starting from 2.2.1,
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/GMOxDOC22/Administering+users+and+groups#Administeringusersandgroups-changingpasswordforderyadimin"
title="change the default password">change the default password</a> if necessary.
For datasources created with 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/GMOxDOC22/Administering+users+and+groups#Administeringusersandgroups-accessinguserdefinedderbydatabases"
title="accessing user defined databases">accessing user defined databases</a> for
more details.</p>

<p><span class="image-wrap" style=""><img src="/confluence/download/attachments/93294/databasePoolDriver.png?version=1&amp;modificationDate=1243990990000"
style="border: 0px solid black" /></span></p>

<p>The following figure shows the <b>Deployment Plan</b> for the selected
database. This plan contains the pool type, connector interface and the connection factory
options from the setup properties.</p>

<p><span class="image-wrap" style=""><img src="/confluence/download/attachments/93294/databasePoolPlan.png?version=1&amp;modificationDate=1243990998000"
style="border: 0px solid black" /></span></p>

<p>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 on how to manually deploy a DB plan might be found in the <a
href="/confluence/display/GMOxDOC22/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/93294/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/GMOxDOC22/Configuring+a+derby+datasource">View
Online</a>
        |
        <a href="https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=93294&revisedVersion=10&originalVersion=9">View
Changes</a>
                |
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC22/Configuring+a+derby+datasource?showComments=true&amp;showCommentArea=true#addcomment">Add
Comment</a>
            </div>
</div>
</div>
</div>
</div>
</body>
</html>

Mime
View raw message