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 > Import database pools from JBoss 4
Date Fri, 28 Jan 2011 09:38: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/Import+database+pools+from+JBoss+4">Import
database pools from JBoss 4</a></h2>
    <h4>Page <b>edited</b> by             <a href="https://cwiki.apache.org/confluence/display/~maojia508">maojia</a>
    </h4>
        <br/>
                         <h4>Changes (13)</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-deleted-lines" style="color:#999;background-color:#fdd;text-decoration:line-through;">{excerpt}In
this article, we will walk you through in importing existing JBoss 4 database pools.{excerpt}
For this particular example, we will use the {{hsqldb-ds.xml}} provided by the *default* JBoss
server, that is {{&lt;jboss_home&gt;\server\default\deploy\hsqldb-ds.xml}} and Hypersonic
database. <br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">{excerpt}This
topic introduces how to import the existing JBoss 4 database pools.{excerpt} For this particular
example, use the {{hsqldb-ds.xml}} provided by the *default* JBoss server, that is {{&lt;jboss_home&gt;\server\default\deploy\hsqldb-ds.xml}}
and Hypersonic database. <br></td></tr>
            <tr><td class="diff-unchanged" > <br></td></tr>
            <tr><td class="diff-changed-lines" >Before getting started, you must
provide Geronimo with the driver jar for Hypersonic HSQL. You can install that driver into
Geronimo&#39;s repository as described in the following <span class="diff-changed-words">steps<span
class="diff-deleted-chars"style="color:#999;background-color:#fdd;text-decoration:line-through;">.</span><span
class="diff-added-chars"style="background-color: #dfd;">:</span></span> <br></td></tr>
            <tr><td class="diff-unchanged" > <br># Locate the HSQL driver
jar {{hsqldb.jar}}. This file is located in the {{&lt;jboss_home&gt;\server\default\lib}}
directory. Make a copy of this file and rename it _hsqldb-1.8.0.jar_. <br></td></tr>
            <tr><td class="diff-changed-lines" ># Use the *Repository* portlet
to install the HSQL driver jar . From the Administration Console, click *JAR Repository* to
access the <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">portlet,
click</span> <span class="diff-added-words"style="background-color: #dfd;">portlet.
Click</span> *Browse* and point to the database driver jar. Change the *Group:* to *Hipersonic*,
<span class="diff-added-words"style="background-color: #dfd;">and</span> leave
the remaining fields by <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">default
and</span> <span class="diff-added-words"style="background-color: #dfd;">default.
Then</span> click *Install*. You will see {{Hipersonic/hsqldb/1.8.0/jar}} listed near
the top of the repository entries list. <br></td></tr>
            <tr><td class="diff-unchanged" > <br></td></tr>
            <tr><td class="diff-changed-lines" >The <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">next</span>
<span class="diff-added-words"style="background-color: #dfd;">following</span>
steps will guide you through importing JBoss 4 database pools in the administration console.
<br></td></tr>
            <tr><td class="diff-changed-lines" ># From the Geronimo Administration
<span class="diff-changed-words">Console<span class="diff-added-chars"style="background-color:
#dfd;">,</span></span> click on the *Database Pools* link. From the *Database
Pools* <span class="diff-changed-words">portlet<span class="diff-added-chars"style="background-color:
#dfd;">,</span></span> click *Import from JBoss 4*. In the *Step 1* of Importing
the Database Pools, specify the location of the {{\*-ds.xml}} file and click *Next*. <br></td></tr>
            <tr><td class="diff-unchanged" >!db_imp_jboss_1.jpg!  <br>\\
<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;">Once</span>
<span class="diff-added-words"style="background-color: #dfd;">After</span> the
JBoss specific datasource is loaded, *Step 2* lists the database pools <span class="diff-added-words"style="background-color:
#dfd;">that</span> the wizard was able to recognize from the {{hsqldb-ds.xml}} file.
Click *Confirm and Deploy*. <br></td></tr>
            <tr><td class="diff-unchanged" >\\ <br>!db_imp_jboss_2.jpg!
<br>\\ <br>\\ <br></td></tr>
            <tr><td class="diff-deleted-lines" style="color:#999;background-color:#fdd;text-decoration:line-through;">#
The third step allows you to edit the recognized database pool. In this step you will have
to specify the driver jar you declared when updating the Geronimo repository. See how *Driver
JAR:* is listed in the following figure. <br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">#
In the third step, you can edit the recognized database pool. In this step, you have to specify
the driver jar that you declared when updating the Geronimo repository. See how *Driver JAR:*
is listed in the following figure. <br></td></tr>
            <tr><td class="diff-unchanged" >\\ !db_imp_jboss_3.jpg! \\ <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;">##</span>
<span class="diff-added-words"style="background-color: #dfd;">#</span> Click *Test
Connection* to verify that you entered all the necessary data, and Geronimo can establish
a connection. <br></td></tr>
            <tr><td class="diff-unchanged" >\\ !db_imp_jboss_4.jpg! \\ <br>\\
<br></td></tr>
            <tr><td class="diff-deleted-lines" style="color:#999;background-color:#fdd;text-decoration:line-through;">##
Click *Deploy*, this will take you to the same database pool list page you saw in *Step 2*.
If you would have more pools defined in the file you can repeat these steps and selectively
import some of the database pools. Since we only have one in this example you can click *Finish*
to complete the import wizard. <br></td></tr>
            <tr><td class="diff-added-lines" style="background-color: #dfd;">#
Click *Deploy*. This will take you to the same database pool list page that you saw in *Step
2*. If you would have more pools defined in the file, you can repeat these steps and selectively
import some of the database pools. Because we have only one database pool in this example,
you can click *Finish* to complete the import wizard. <br></td></tr>
            <tr><td class="diff-unchanged" >\\ !db_imp_jboss_5.jpg! \\ <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;">##</span>
<span class="diff-added-words"style="background-color: #dfd;">#</span> You now
see the imported *DefaultDS* database pool. <br></td></tr>
            <tr><td class="diff-unchanged" >!db_imp_jboss_6.jpg! <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/Configuring+a+MySQL+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/GMOxDOC30/Configuring+a+MySQL+datasource">Configuring
a MySQL datasource</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;<a href="/confluence/display/GMOxDOC30/Import+database+pools+from+WebLogic+8.1">Import
database pools from WebLogic 8.1</a></td><td class='ScrollbarNextIcon'><a
href="/confluence/display/GMOxDOC30/Import+database+pools+from+WebLogic+8.1"><img border='0'
align='middle' src='/confluence/images/icons/forwd_16.gif' width='16' height='16'></a></td></tr></table></div>

<p>This topic introduces how to import the existing JBoss 4 database pools. For this
particular example, use the <tt>hsqldb-ds.xml</tt> provided by the <b>default</b>
JBoss server, that is <tt>&lt;jboss_home&gt;\server\default\deploy\hsqldb-ds.xml</tt>
and Hypersonic database.</p>

<p>Before getting started, you must provide Geronimo with the driver jar for Hypersonic
HSQL. You can install that driver into Geronimo's repository as described in the following
steps:</p>

<ol>
	<li>Locate the HSQL driver jar <tt>hsqldb.jar</tt>. This file is located
in the <tt>&lt;jboss_home&gt;\server\default\lib</tt> directory. Make
a copy of this file and rename it <em>hsqldb-1.8.0.jar</em>.</li>
	<li>Use the <b>Repository</b> portlet to install the HSQL driver jar .
From the Administration Console, click <b>JAR Repository</b> to access the portlet.
Click <b>Browse</b> and point to the database driver jar. Change the <b>Group:</b>
to <b>Hipersonic</b>, and leave the remaining fields by default. Then click <b>Install</b>.
You will see <tt>Hipersonic/hsqldb/1.8.0/jar</tt> listed near the top of the repository
entries list.</li>
</ol>


<p>The following steps will guide you through importing JBoss 4 database pools in the
administration console.</p>
<ol>
	<li>From the Geronimo Administration Console, click on the <b>Database Pools</b>
link. From the <b>Database Pools</b> portlet, click <b>Import from JBoss
4</b>. In the <b>Step 1</b> of Importing the Database Pools, specify the
location of the <tt>&#42;-ds.xml</tt> file and click <b>Next</b>.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/20645324/db_imp_jboss_1.jpg?version=1&amp;modificationDate=1203704609000"
style="border: 0px solid black" /></span> 
<br class="atl-forced-newline" />
<br class="atl-forced-newline" /></li>
	<li>After the JBoss specific datasource is loaded, <b>Step 2</b> lists
the database pools that the wizard was able to recognize from the <tt>hsqldb-ds.xml</tt>
file. Click <b>Confirm and Deploy</b>.
<br class="atl-forced-newline" />
<span class="image-wrap" style=""><img src="/confluence/download/attachments/20645324/db_imp_jboss_2.jpg?version=1&amp;modificationDate=1203704609000"
style="border: 0px solid black" /></span>
<br class="atl-forced-newline" />
<br class="atl-forced-newline" /></li>
	<li>In the third step, you can edit the recognized database pool. In this step, you
have to specify the driver jar that you declared when updating the Geronimo repository. See
how <b>Driver JAR:</b> is listed in the following figure.
<br class="atl-forced-newline" /> <span class="image-wrap" style=""><img src="/confluence/download/attachments/20645324/db_imp_jboss_3.jpg?version=1&amp;modificationDate=1203704609000"
style="border: 0px solid black" /></span> <br class="atl-forced-newline" />
<br class="atl-forced-newline" /></li>
	<li>Click <b>Test Connection</b> to verify that you entered all the necessary
data, and Geronimo can establish a connection.
<br class="atl-forced-newline" /> <span class="image-wrap" style=""><img src="/confluence/download/attachments/20645324/db_imp_jboss_4.jpg?version=1&amp;modificationDate=1203704609000"
style="border: 0px solid black" /></span> <br class="atl-forced-newline" />
<br class="atl-forced-newline" /></li>
	<li>Click <b>Deploy</b>. This will take you to the same database pool list
page that you saw in <b>Step 2</b>. If you would have more pools defined in the
file, you can repeat these steps and selectively import some of the database pools. Because
we have only one database pool in this example, you can click <b>Finish</b> to
complete the import wizard.
<br class="atl-forced-newline" /> <span class="image-wrap" style=""><img src="/confluence/download/attachments/20645324/db_imp_jboss_5.jpg?version=1&amp;modificationDate=1203704609000"
style="border: 0px solid black" /></span> <br class="atl-forced-newline" />
<br class="atl-forced-newline" /></li>
	<li>You now see the imported <b>DefaultDS</b> database pool.<br/>
<span class="image-wrap" style=""><img src="/confluence/download/attachments/20645324/db_imp_jboss_6.jpg?version=1&amp;modificationDate=1203704617000"
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/GMOxDOC30/Import+database+pools+from+JBoss+4">View
Online</a>
        |
        <a href="https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=20645324&revisedVersion=2&originalVersion=1">View
Changes</a>
                |
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC30/Import+database+pools+from+JBoss+4?showComments=true&amp;showCommentArea=true#addcomment">Add
Comment</a>
            </div>
</div>
</div>
</div>
</div>
</body>
</html>

Mime
View raw message