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 > JBoss to Geronimo - Hibernate Migration
Date Tue, 29 May 2012 01:34:00 GMT
<html>
<head>
    <base href="https://cwiki.apache.org/confluence">
            <link rel="stylesheet" href="/confluence/s/2042/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/JBoss+to+Geronimo+-+Hibernate+Migration">JBoss to Geronimo - Hibernate Migration</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 (7)</h4>
                                 
    
<div id="page-diffs">
                    <table class="diff" cellpadding="0" cellspacing="0">
    
            <tr><td class="diff-unchanged" >{anchor:top} <br></td></tr>
            <tr><td class="diff-changed-lines" >This article will help you migrate applications using Hibernate 3.2 as the ORM tool from JBoss Application Server <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">4.2.1</span> <span class="diff-added-words"style="background-color: #dfd;">7.0</span> to Apache Geronimo <span class="diff-changed-words"><span class="diff-deleted-chars"style="color:#999;background-color:#fdd;text-decoration:line-through;">2</span><span class="diff-added-chars"style="background-color: #dfd;">3</span>.0.</span> <br></td></tr>
            <tr><td class="diff-unchanged" > <br>Hibernate is a powerful, high performance object/relational persistence and query service. It helps in the development of persistent (POJO) classes which have the getter and setter methods for attributes that are then mapped to fields in the database. You may follow object-oriented idiom - including association, inheritance, polymorphism, composition, and collections. Hibernate allows you to express queries in its own portable SQL extension (HQL), as well as in native SQL, or with an object-oriented Criteria and Example API. <br> <br></td></tr>
            <tr><td class="diff-changed-lines" >Basically, Hibernate maps the Java classes to the database tables. It also provides the data query and retrieval facilities that significantly reduce the development time. It fits in naturally to the object-oriented mode of code development in the JAVA middle-tier. A unique feature of Hibernate is that it facilitates transparent persistence that enables the applications to switch to any database be it MySQL, Oracle or DB2. Hibernate can be used in Java Swing applications, Java Servlet-based applications, or <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">J2EE</span> <span class="diff-added-words"style="background-color: #dfd;">Java EE</span> applications using EJB session beans (Java Servlet based application in our case). <br></td></tr>
            <tr><td class="diff-unchanged" > <br>In order to illustrate the steps involved in the migration a sample application is provided which we will first deploy in JBoss and then migrate to Geronimo. The sample application will be the Online Brokerage Application which we already used in the JDBC migration example. This application has been changed to use Hibernate for persistence. <br></td></tr>
            <tr><td class="diff-snipped" >...<br></td></tr>
            <tr><td class="diff-unchanged" >It is also very flexible and we can use any combinations of these services. In this article we will be configuring hibernate to provide only the O/R Mapping feature while JBoss/Geronimo will provide both Transaction Management and Connection Management. This is the most commonly used configuration of Hibernate with an application server. Hibernate requires a configuration file {{hibernate.cfg.xml}} which creates the connection pool and sets up the required environment. It contains parameters like the database driver, connection url, dialect (this specifies which RDBMS is being used), username, password, pool size among others. It also contains the location of the Mapping File {{\*.hbm.xml}}. A Mapping File is used to map the fields in the database table to the persistent class attributes. <br> <br></td></tr>
            <tr><td class="diff-changed-lines" >These properties are *common* to any application server including *Apache Geronimo <span class="diff-changed-words">v<span class="diff-deleted-chars"style="color:#999;background-color:#fdd;text-decoration:line-through;">2</span><span class="diff-added-chars"style="background-color: #dfd;">3</span>.0*.</span> <br></td></tr>
            <tr><td class="diff-unchanged" > <br>However, JBoss (more specifically the Hibernate MBean) provides *two* additional deployment mechanisms. <br></td></tr>
            <tr><td class="diff-snipped" >...<br></td></tr>
            <tr><td class="diff-unchanged" > <br>The following table provides a feature-to-feature comparison between these two applicaiton servers. <br></td></tr>
            <tr><td class="diff-changed-lines" >|| Feature || Apache Geronimo <span class="diff-changed-words">v<span class="diff-deleted-chars"style="color:#999;background-color:#fdd;text-decoration:line-through;">2</span><span class="diff-added-chars"style="background-color: #dfd;">3</span>.0</span> || JBoss <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">v4.2.1</span> <span class="diff-added-words"style="background-color: #dfd;">v7.0</span> || <br></td></tr>
            <tr><td class="diff-unchanged" >| Container-managed datasource | Supported. Hibernate is able to use a datasource given its JNDI name. This is because it is running in the same thread as the application. | Supported. Hibernate can lookup a datasource from JNDI given its JNDI name. | <br>| Automatic JNDI binding | Not Supported. | Supported. Once the property is set the session factory is bound to the JNDI context. | <br></td></tr>
            <tr><td class="diff-snipped" >...<br></td></tr>
            <tr><td class="diff-unchanged" >The following list highlights the general tasks you will need to complete to install and configure the <br>initial environment as the starting point for deploying the sample application. <br></td></tr>
            <tr><td class="diff-changed-lines" ># Download and install JBoss <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">v4.2.1</span> <span class="diff-added-words"style="background-color: #dfd;">v7.0</span> as explained in the product documentation guides. From now on the <br></td></tr>
            <tr><td class="diff-unchanged" >installation directory will be referred as *&lt;jboss_home&gt;* <br></td></tr>
            <tr><td class="diff-changed-lines" ># Create a copy of the default JBoss <span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">v4.2.1</span> <span class="diff-added-words"style="background-color: #dfd;">v7.0</span> application server. Copy recursively *&lt;jboss_home&gt;\server\default* to *&lt;jboss_home&gt;\server\&lt;your_server_name&gt;* <br></td></tr>
            <tr><td class="diff-unchanged" ># Start the new server by running the {{{*}run.sh \-c &lt;your_server_name&gt;*}} command from the *&lt;jboss_home&gt;\bin* directory. <br># Once the server is started, you can verify that it is running by opening a Web browser and pointing it to this URL: [http://localhost:8080]. You should see the JBoss Welcome window and be able to access the JBoss console. <br></td></tr>
            <tr><td class="diff-snipped" >...<br></td></tr>
            <tr><td class="diff-unchanged" >Depending on your environment you should see a confirmation message similar to this one: <br>{noformat:borderStyle=solid|bgColor=#FFFFFF} <br></td></tr>
            <tr><td class="diff-changed-lines" ><span class="diff-changed-words">C:\geronimo-<span class="diff-deleted-chars"style="color:#999;background-color:#fdd;text-decoration:line-through;">2</span><span class="diff-added-chars"style="background-color: #dfd;">3</span>.0\bin&gt;deploy</span> --user system --password manager deploy \brokerage\plan\mysql-geronimo-plan.xml <br></td></tr>
            <tr><td class="diff-unchanged" >..\repository\org\tranql\tranql-connector-ra\1.3\tranql-connector-ra-1.3.rar <br>    Deployed user/database-pool-HibernateDS/2.0/car <br></td></tr>
            <tr><td class="diff-snipped" >...<br></td></tr>
    
            </table>
    </div>                            <h4>Full Content</h4>
                    <div class="notificationGreySide">
        <p><a name="JBosstoGeronimo-HibernateMigration-top"></a><br/>
This article will help you migrate applications using Hibernate 3.2 as the ORM tool from JBoss Application Server 7.0 to Apache Geronimo 3.0.</p>

<p>Hibernate is a powerful, high performance object/relational persistence and query service. It helps in the development of persistent (POJO) classes which have the getter and setter methods for attributes that are then mapped to fields in the database. You may follow object-oriented idiom - including association, inheritance, polymorphism, composition, and collections. Hibernate allows you to express queries in its own portable SQL extension (HQL), as well as in native SQL, or with an object-oriented Criteria and Example API.</p>

<p>Basically, Hibernate maps the Java classes to the database tables. It also provides the data query and retrieval facilities that significantly reduce the development time. It fits in naturally to the object-oriented mode of code development in the JAVA middle-tier. A unique feature of Hibernate is that it facilitates transparent persistence that enables the applications to switch to any database be it MySQL, Oracle or DB2. Hibernate can be used in Java Swing applications, Java Servlet-based applications, or Java EE applications using EJB session beans (Java Servlet based application in our case).</p>

<p>In order to illustrate the steps involved in the migration a sample application is provided which we will first deploy in JBoss and then migrate to Geronimo. The sample application will be the Online Brokerage Application which we already used in the JDBC migration example. This application has been changed to use Hibernate for persistence.</p>

<p>This article is organized in the following sections:</p>
<ul>
	<li><a href="#JBosstoGeronimo-HibernateMigration-implementation">Hibernate implementation analysis</a></li>
	<li><a href="#JBosstoGeronimo-HibernateMigration-sampleApp">Sample application</a></li>
	<li><a href="#JBosstoGeronimo-HibernateMigration-JBoss">The JBoss environment</a></li>
	<li><a href="#JBosstoGeronimo-HibernateMigration-Geronimo">The Geronimo environment</a></li>
	<li><a href="#JBosstoGeronimo-HibernateMigration-migration">Step-by-step migration</a></li>
	<li><a href="#JBosstoGeronimo-HibernateMigration-summary">Summary</a></li>
</ul>


<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h1><a name="JBosstoGeronimo-HibernateMigration-Hibernateimplementationanalysis"></a>Hibernate implementation analysis <a name="JBosstoGeronimo-HibernateMigration-implementation"></a></h1>

<p>Hibernate can provide the following services:</p>
<ul>
	<li>Connection Management</li>
	<li>Transaction Management</li>
	<li>Object Relational Mapping</li>
</ul>


<p>It is also very flexible and we can use any combinations of these services. In this article we will be configuring hibernate to provide only the O/R Mapping feature while JBoss/Geronimo will provide both Transaction Management and Connection Management. This is the most commonly used configuration of Hibernate with an application server. Hibernate requires a configuration file <tt>hibernate.cfg.xml</tt> which creates the connection pool and sets up the required environment. It contains parameters like the database driver, connection url, dialect (this specifies which RDBMS is being used), username, password, pool size among others. It also contains the location of the Mapping File <tt>&#42;.hbm.xml</tt>. A Mapping File is used to map the fields in the database table to the persistent class attributes.</p>

<p>These properties are <b>common</b> to any application server including <b>Apache Geronimo v3.0</b>.</p>

<p>However, JBoss (more specifically the Hibernate MBean) provides <b>two</b> additional deployment mechanisms.</p>

<p>The first is the Hibernate Archive (HAR file). Here, all the Hibernate classes and mapping files are packaged in a special archive, the HAR file. JBoss deploys this archive in the same way as it does with an EAR or a WAR file.</p>

<p>The alternative to the HAR file is to simply put all the Hibernate classes and mapping files with the other application classes, like in an EAR for example. The Hibernate MBean would be separately configured and told to search all application JARs for mapping files. Both deployment mechanisms allow you to provide Hibernate objects to your application code without performing any manual configuration or writing of the setup code normally required.</p>

<p>Structurally, a HAR file resembles a JBoss service archive (SAR file). The HAR file contains the Hibernate class files and the mapping files (*.hbm.xml) along with the standard <tt>jboss-service.xml</tt> file containing a definition for the Hibernate MBean configured for the needs of the Hibernate application being created. In the latest JBoss distribution, it has been renamed as <tt>hibernate-service.xml</tt>, but it retains the same structure and purpose.</p>

<p>Hibernate archives can be deployed as top-level packages or as a component of an EAR file. Since Hibernate archives are not a standard J2EE deployment type, we need to declare them in the <tt>jboss-app.xml</tt> file of an EAR file to use them in that context.</p>

<p>The following table provides a feature-to-feature comparison between these two applicaiton servers.</p>
<div class='table-wrap'>
<table class='confluenceTable'><tbody>
<tr>
<th class='confluenceTh'> Feature </th>
<th class='confluenceTh'> Apache Geronimo v3.0 </th>
<th class='confluenceTh'> JBoss v7.0 </th>
</tr>
<tr>
<td class='confluenceTd'> Container-managed datasource </td>
<td class='confluenceTd'> Supported. Hibernate is able to use a datasource given its JNDI name. This is because it is running in the same thread as the application. </td>
<td class='confluenceTd'> Supported. Hibernate can lookup a datasource from JNDI given its JNDI name. </td>
</tr>
<tr>
<td class='confluenceTd'> Automatic JNDI binding </td>
<td class='confluenceTd'> Not Supported. </td>
<td class='confluenceTd'> Supported. Once the property is set the session factory is bound to the JNDI context. </td>
</tr>
<tr>
<td class='confluenceTd'> JTA Session binding </td>
<td class='confluenceTd'> This feature is not supported out of the box. We need to write a lookup for the Geronimo Transaction Manager to enable this. </td>
<td class='confluenceTd'> Supported out of the Box. Hibernate provides a lookup class for the JBoss Transaction Manager. </td>
</tr>
<tr>
<td class='confluenceTd'> JMX deployment </td>
<td class='confluenceTd'> Not Supported out of the box. <b>Can be implemented by writing a GBean and a Hibernate Connection Provider class</b>. </td>
<td class='confluenceTd'> Supported. Hibernate is distributed with <tt>org.hibernate.jmx.HibernateService</tt> which can be deployed on JBoss. </td>
</tr>
<tr>
<td class='confluenceTd'> Hibernate Archive (HAR) </td>
<td class='confluenceTd'> Not Supported. Hibernate classes are deployed as a part of the J2EE archives. </td>
<td class='confluenceTd'> Supported. A HAR packages the configuration and mapping files enabling extra server support to deployment. </td>
</tr>
<tr>
<td class='confluenceTd'> Caching </td>
<td class='confluenceTd'> You can use caching mechanisms provided by hibernate. </td>
<td class='confluenceTd'> You can use caching mechanisms provided by hibernate. Integration with JBoss Cache is also supported. </td>
</tr>
<tr>
<td class='confluenceTd'> Session Management </td>
<td class='confluenceTd'> Not Supported. It is required to manually open sessions. Only the transaction needs to be closed. </td>
<td class='confluenceTd'> The Hibernate Session's lifecycle can be automatically bound to the scope of a <br class="atl-forced-newline" />
JTA transaction. This means you no longer have to manually open and close the Session, this becomes the job of a JBoss EJB interceptor. </td>
</tr>
<tr>
<td class='confluenceTd'> Hibernate Mapping Files </td>
<td class='confluenceTd'> We need to specify the locations of the Hibernate mapping files. </td>
<td class='confluenceTd'> If we use HAR deployment JBoss will automatically lookup the Hibernate mapping files. </td>
</tr>
</tbody></table>
</div>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h1><a name="JBosstoGeronimo-HibernateMigration-Sampleapplication"></a>Sample application <a name="JBosstoGeronimo-HibernateMigration-sampleApp"></a></h1>

<p>This article contains a sample application to demonstrate migrating an application from JBoss to Geronimo, called <a href="/confluence/download/attachments/20645282/brokerage.zip?version=1&amp;modificationDate=1204198993000">Online Brokerage</a> . It represents an online trading scenario in which users can buy and sell stocks. The application has the following five pages:</p>
<ul>
	<li>Login Page</li>
	<li>Registration Page</li>
	<li>User Information Page</li>
	<li>Available Stocks Page</li>
	<li>User Portfolio Page</li>
</ul>


<p>The following figure illustrates the application flow:<span class="image-wrap" style="display: block; text-align: center"><img src="/confluence/download/attachments/20645282/brokerage.jpg?version=1&amp;modificationDate=1204198993000" style="border: 0px solid black" /></span><br/>
First, the user accesses the Login page. From the Login page the user enters the user name and password. If the user name or password is not valid the application throws an error message and rejects the user's login attempt. If the user name and password are correct, the user is taken to the Available Stocks page where he/she can view all the stocks that are present for sale at that time.<br/>
The user can choose to buy as many stocks as wanted, depending on the available money in the account, by clicking the Buy button. After the transaction completes successfully the user is brought back to the Available Stocks page where he/she can buy more stocks if required. If the user has insufficient funds to buy stocks the application will throw an error and will not process the transaction. The error message is shown at the top of the Available Stocks page. There is a User Info button on this page. By clicking this button the user is taken to the User Info page and shown the user details.<br/>
>From the Available Stocks page there is a View your Portfolio link that shows all the stocks that the user owns. In that page, the user can select the stocks and quantity to sell. This page also shows the user's available cash in the User Cash field. If the user tries to sell more stocks than he/she has, the application will throw an error. The error message will be displayed on the same page. For each successful sale, the sale amount is added to the user's cash balance. The quantity text box shows the quantity of stocks of a particular company that the user has. The Quantity to Sell field allows the user to enter the quantity of stocks to sell for a specific company. For selling and buying, the radio button should be checked. This should be done after entering the values. If either the quantity to sell textbox is not filled or the selection box is not checked and you press on sell a JavaScript alert will be triggered saying that the required field is empty. On entering non numeric characters for quantity another alert will be triggered. This behavior is similar for the Available Stocks page as well.<br/>
New users can register by clicking the Register button in the login page. In the Registration page the user will enter a user id, user name, password, address and available cash.<br/>
<a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>
<h2><a name="JBosstoGeronimo-HibernateMigration-ApplicationclassesandJSPpages"></a>Application classes and JSP pages</h2>

<p>The Online Brokerage sample application consists of the following packages:</p>
<ul>
	<li>com.dev.trade.bo
	<ul>
		<li>Stock - Represents the stock of a company.</li>
		<li>User - Represents the user.</li>
		<li>UserStock - Represents the stock owned by a user.</li>
	</ul>
	</li>
</ul>


<ul>
	<li>com.dev.trade.dao
	<ul>
		<li>TradeDAO - Contains all the database access methods.</li>
	</ul>
	</li>
</ul>


<ul>
	<li>com.dev.trade.exception
	<ul>
		<li>DBException - Custom exception class that is thrown for all database exceptions.</li>
	</ul>
	</li>
</ul>


<ul>
	<li>com.dev.trade.servlet
	<ul>
		<li>TradeDispatcherServlet - Dispatches all the requests to the JSPs after performing required database functions.</li>
	</ul>
	</li>
</ul>


<p>The Online Brokerage also includes the following JSP pages:</p>
<ul>
	<li>login.jsp - The login page of the application.</li>
	<li>error.jsp - The default error page of the application.</li>
	<li>register.jsp - The user registration page.</li>
	<li>stocks.jsp - The Available Stocks page from where the user can buy stocks.</li>
	<li>userstocks.jsp - The user portfolio page which shows the user's stocks. The user can sell stocks from this page.</li>
</ul>


<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Toolsused"></a>Tools used</h2>

<p>The tools used for developing and building the sample application are:</p>

<h3><a name="JBosstoGeronimo-HibernateMigration-ApacheAnt"></a>Apache Ant</h3>

<p>Ant is a pure Java build tool. It is used for building the war files and populating the database for the Online Brokerage application. Ant can be downloaded from the following URL:</p>

<p><a href="http://ant.apache.org" class="external-link" rel="nofollow">http://ant.apache.org</a></p>

<h3><a name="JBosstoGeronimo-HibernateMigration-Hibernate"></a>Hibernate</h3>

<p>At the time of writing this article, Hibernate 3.2 is the latest version available and can be downloaded at the following URL:<br/>
<a href="http://www.hibernate.org" class="external-link" rel="nofollow">http://www.hibernate.org</a></p>

<p>Additional documentation on Hibernate may be found at the following URL:<br/>
<a href="http://hibernate.org/5.html" class="external-link" rel="nofollow">http://hibernate.org/5.html</a><br/>
<a href="http://www.hibernate.org/hib_docs/v3/reference/en/html/tutorial.html" class="external-link" rel="nofollow">http://www.hibernate.org/hib_docs/v3/reference/en/html/tutorial.html</a></p>

<p>Download and install Hibernate, the installation directory will be later referred as <b>&lt;hibernate_home&gt;</b>.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Sampledatabase"></a>Sample database</h2>

<p>The database used for demonstrating this application is MySQL. The sample database name is <b>adi</b> and it consists of the following three tables, STOCKS, USERS and USERSTOCKS. The fields for each of these tables are described below.</p>
<div class='table-wrap'>
<table class='confluenceTable'><tbody>
<tr>
<th class='confluenceTh'> Table Name </th>
<th class='confluenceTh'> Fields </th>
</tr>
<tr>
<td class='confluenceTd'> STOCKS </td>
<td class='confluenceTd'> ID (PRIMARY KEY) <br class="atl-forced-newline" />
 NAME <br class="atl-forced-newline" />
 PRICE </td>
</tr>
<tr>
<td class='confluenceTd'> USERS </td>
<td class='confluenceTd'> USERID (PRIMARY KEY) <br class="atl-forced-newline" />
 NAME <br class="atl-forced-newline" />
 PASSWORD <br class="atl-forced-newline" />
 ADDRESS <br class="atl-forced-newline" />
 CASH </td>
</tr>
<tr>
<td class='confluenceTd'> USERSTOCKS </td>
<td class='confluenceTd'> ID (PRIMARY KEY) <br class="atl-forced-newline" />
 USERID (PRIMARY KEY) <br class="atl-forced-newline" />
 NAME <br class="atl-forced-newline" />
 PRICE <br class="atl-forced-newline" />
 QUANTITY </td>
</tr>
</tbody></table>
</div>

<p>The USERSTOCKS table is used to store the stocks that are owned by each user. The USERS and STOCKS tables are used to store the user and stock details. Because this is just a sample application the amount of money that a user has is entered during user registration by the user itself.</p>

<p>The DDL file used for populating this database is <b>db.sql</b> and it is located in the &lt;brokerage_home&gt;\sql directory.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h1><a name="JBosstoGeronimo-HibernateMigration-TheJBossenvironment"></a>The JBoss environment <a name="JBosstoGeronimo-HibernateMigration-JBoss"></a></h1>

<p>This section shows you how and where the sample JBoss reference environment was installed so you can map this scenario to your own implementation.</p>

<p>Detailed instructions for installing, configuring, and managing JBoss are provided in the product documentation. Check the product Web site for the most updated documents.</p>

<p>The following list highlights the general tasks you will need to complete to install and configure the<br/>
initial environment as the starting point for deploying the sample application.</p>
<ol>
	<li>Download and install JBoss v7.0 as explained in the product documentation guides. From now on the<br/>
installation directory will be referred as <b>&lt;jboss_home&gt;</b></li>
	<li>Create a copy of the default JBoss v7.0 application server. Copy recursively <b>&lt;jboss_home&gt;\server\default</b> to <b>&lt;jboss_home&gt;\server\&lt;your_server_name&gt;</b></li>
	<li>Start the new server by running the <tt><b>run.sh &#45;c &lt;your_server_name&gt;</b></tt> command from the <b>&lt;jboss_home&gt;\bin</b> directory.</li>
	<li>Once the server is started, you can verify that it is running by opening a Web browser and pointing it to this URL: <a href="http://localhost:8080" class="external-link" rel="nofollow">http://localhost:8080</a>. You should see the JBoss Welcome window and be able to access the JBoss console.</li>
	<li>Once the application server is up and running, the next step is to install and configure all the remaining prerequisite software required by the sample application. This step is described in the following section.</li>
</ol>


<h2><a name="JBosstoGeronimo-HibernateMigration-Installandconfigureprerequisitesoftware"></a>Install and configure prerequisite software</h2>

<p>In order to build and run the Library application included in this article, you need to install and configure the build tool and the database that is used by the application.</p>

<h3><a name="JBosstoGeronimo-HibernateMigration-Installthedatabase"></a>Install the database</h3>

<p>As mentioned earlier in the article, this application is using the MySQL database that can be downloaded from the following URL:</p>

<p><a href="http://www.mysql.com" class="external-link" rel="nofollow">http://www.mysql.com</a></p>

<p>Note: The appropriate version of the MySQL Connector/J should also be downloaded (3.1, 5.0, or 5.1), depending on your MySQL version.</p>

<p>This MySQL connector must also be placed in &lt;JBOSS_HOME&gt;/server/default/lib.&nbsp;</p>

<p>The Installation and configuration of MySQL is fairly intuitive and it is well documented in the MySQL Reference Manual available at the following URL:</p>

<p><a href="http://dev.mysql.com/doc/mysql/en" class="external-link" rel="nofollow">http://dev.mysql.com/doc/mysql/en</a></p>

<p><b>Note:</b> During the instance configuration I modified the security settings and specified "password" as the password for the root user. This user ID and password will later be used for accessing the database from the sample application.</p>

<h3><a name="JBosstoGeronimo-HibernateMigration-Createsampledatabase"></a>Create sample database</h3>

<p>Once the MySQL instance is configured you need to create the sample database that will be used by the Library application. From a command line, type the following command to start the MySQL monitor:</p>

<p><tt><b>mysql &#45;u root &#45;ppassword</b></tt></p>

<p>Note that there is no blank between the flag &#45;p and the password.</p>

<p>This will bring up the MySQL command interface as shown in the following example:</p>
<div class="preformatted panel" style="border-style: solid;border-width: 1px;"><div class="preformattedHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>MySQL monitor interface</b></div><div class="preformattedContent panelContent">
<pre>Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.14-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql&gt;
</pre>
</div></div>
<p>From the MySQL command interface create the <b>adi</b> sample database by typing the following command:</p>

<p><tt><b>mysql&gt; create database adi;</b></tt></p>

<h3><a name="JBosstoGeronimo-HibernateMigration-ConfigureAnt"></a>Configure Ant</h3>

<p>As mentioned before, Apache Ant is used to build the binaries for the Online Brokerage application. If you do not have Ant installed this is a good time for doing it and make sure that <b>&lt;ant_home&gt;\bin</b> directory is added to the system's path variable.</p>

<p>Apache Ant can be downloaded from the following URL:</p>

<p><a href="http://ant.apache.org" class="external-link" rel="nofollow">http://ant.apache.org</a></p>

<h3><a name="JBosstoGeronimo-HibernateMigration-ConfigureHibernate"></a>Configure Hibernate</h3>

<p>JBoss comes bundled with Hibernate so there is no need to download separate jars for hibernate.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Buildthesampleapplication"></a>Build the sample application</h2>

<p>The Online Brokerage application included with this article provides an Ant script that you will use in order to build the application and populate the database. Download the sample application by cliking on <a href="/confluence/download/attachments/20645282/brokerage.zip?version=1&amp;modificationDate=1204198993000">Online Brokerage</a>.</p>

<p>After extracting the zip file, a brokerage directory is created, throughout the rest of the article we will refer to this directory as <b>&lt;brokerage_home&gt;</b>. In that directory open the <b>build.properties</b> file and edit the properties to match your environment as shown in the following example:</p>
<div class="preformatted panel" style="border-style: solid;border-width: 1px;"><div class="preformattedHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>build.properties</b></div><div class="preformattedContent panelContent">
<pre>#Replace java.home with your jdk directory
java.home=&lt;java_home&gt;

#Replace jboss.home with the parent directory of lib/j2ee.jar
jboss.home=&lt;jboss_home&gt;/server/&lt;your_server_name&gt;

#Replace geronimo.home with the geronimo home directory.
geronimo.home=&lt;geronimo_home&gt;

#Fully qualified name of the JDBC driver class
db.driver=com.mysql.jdbc.Driver

#database url
db.url=jdbc:mysql://localhost:3306/adi

#database userId
db.userid=root

#database password
db.password=password

#script file for creating the tables
sql.file=sql/db.sql

#location of the jdbc driver jar.
driver.classpath=&lt;mysql-connector_home&gt;/mysql-connector-java-3.1.14-bin.jar

#location of the hibernate jars.
dependency.dir=&lt;hibernate_home&gt;/lib
</pre>
</div></div>
<p>Note that the path to the Hibernate jars defined by the <tt><b>dependency.dir</b></tt> tag are necessary by Geronimo, JBoss comes with it's own copy of Hibernate. Still you will need to copy to that directory the <b>hibernate3.jar</b> file located in the <b>&lt;hibernate_home&gt;</b> directory.</p>
<div class='panelMacro'><table class='noteMacro'><colgroup><col width='24'><col></colgroup><tr><td valign='top'><img src="/confluence/images/icons/emoticons/warning.gif" width="16" height="16" align="absmiddle" alt="" border="0"></td><td><b>Important:</b> When specifying the paths in this file, make sure you use forward slash "<b>/</b>" otherwise you will get compilation errors.</td></tr></table></div>
<p>From a command prompt or shell change directory to &lt;brokerage_home&gt; and run the <b>ant</b> command. This will build the war, har and ear files and place them in the <b>&lt;brokerage_home&gt;\jboss-artefact</b> directory. The war created by the <b>ant</b> build contains a JBoss specific deployment descriptor <b>jboss-web.xml</b> file in the WEB-INF directory of the WAR. The HAR contains a JBoss specific <b>hibernate-service.xml</b> file in the META-INF directory and the EAR contains a JBoss specific deployment descriptor <b>jboss-app.xml</b>. These files are shown below.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>jboss-web.xml</b></div><div class="codeContent panelContent">
<pre class="code-xml">
<span class="code-tag">&lt;?xml version=<span class="code-quote">"1.0"</span> encoding=<span class="code-quote">"UTF-8"</span>?&gt;</span>
<span class="code-tag">&lt;jboss-web&gt;</span>
  <span class="code-tag">&lt;context-root&gt;</span>/brokerage<span class="code-tag">&lt;/context-root&gt;</span>
  <span class="code-tag">&lt;resource-ref&gt;</span>
      <span class="code-tag">&lt;res-ref-name&gt;</span>jdbc/HibernateDB<span class="code-tag">&lt;/res-ref-name&gt;</span>
      <span class="code-tag">&lt;res-type&gt;</span>javax.sql.DataSource<span class="code-tag">&lt;/res-type&gt;</span>
      <span class="code-tag">&lt;jndi-name&gt;</span>jdbc/HibernateDS<span class="code-tag">&lt;/jndi-name&gt;</span>
  <span class="code-tag">&lt;/resource-ref&gt;</span>
<span class="code-tag">&lt;/jboss-web&gt;</span>
</pre>
</div></div>
<p>The resource-ref element is used to map the resource referred to by the name <b>jdbc/HibernateDB</b> in the web.xml file to the resource with the JNDI name <b>java:jdbc/</b> <b>HibernateDS</b>, for example MySQL datasource.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>hibernate-service.xml</b></div><div class="codeContent panelContent">
<pre class="code-xml">
<span class="code-tag">&lt;?xml version=<span class="code-quote">"1.0"</span> encoding=<span class="code-quote">"UTF-8"</span>?&gt;</span>
<span class="code-tag">&lt;server&gt;</span>
    &lt;mbean code=<span class="code-quote">"org.jboss.hibernate.jmx.Hibernate"</span>
           name=<span class="code-quote">"jboss.har:service=Hibernate"</span>&gt;
        <span class="code-tag">&lt;attribute name=<span class="code-quote">"DatasourceName"</span>&gt;</span>java:jdbc/HibernateDS<span class="code-tag">&lt;/attribute&gt;</span>

        <span class="code-tag">&lt;attribute name=<span class="code-quote">"Dialect"</span>&gt;</span>
            org.hibernate.dialect.MySQLDialect
        <span class="code-tag">&lt;/attribute&gt;</span>
        <span class="code-tag">&lt;attribute name=<span class="code-quote">"SessionFactoryName"</span>&gt;</span>
            java:/hibernate/BrokerageSessionFactory
        <span class="code-tag">&lt;/attribute&gt;</span>
        <span class="code-tag">&lt;attribute name=<span class="code-quote">"CacheProviderClass"</span>&gt;</span>
            org.hibernate.cache.HashtableCacheProvider
        <span class="code-tag">&lt;/attribute&gt;</span>
         <span class="code-tag"><span class="code-comment">&lt;!-- &lt;attribute name=<span class="code-quote">"ScanForMappingsEnabled"</span>&gt;</span>true<span class="code-tag">&lt;/attribute&gt;</span> --&gt;</span>
        <span class="code-tag">&lt;attribute name=<span class="code-quote">"ShowSqlEnabled"</span>&gt;</span>true<span class="code-tag">&lt;/attribute&gt;</span>
    <span class="code-tag">&lt;/mbean&gt;</span>
<span class="code-tag">&lt;/server&gt;</span>
</pre>
</div></div>
<p>This file contains the hibernate properties that need to be set. The property names and their functions are:</p>
<ul>
	<li><b>DatasourceName</b> &#45; The JNDI name of the datasource that Hibernate should use.</li>
	<li><b>Dialect</b> &#45; The SQL Dialect that should be used.</li>
	<li><b>SessionFactoryName</b> &#45; JNDI name to which the session factory should be bound.</li>
	<li><b>CacheProviderClass</b> &#45; The Class of the Cache Provider</li>
	<li><b>ShowSqlEnabled</b> &#45; Show the executed SQL statements in the output.</li>
</ul>


<p>The <b>hibernate-service.xml</b> file should be present in the META-INF directory of the EAR.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>jboss-app.xml</b></div><div class="codeContent panelContent">
<pre class="code-xml">
<span class="code-tag">&lt;!DOCTYPE jboss-app PUBLIC <span class="code-quote">"-//JBoss//DTD J2EE Application 1.4//EN"</span> <span class="code-quote">"http://www.jboss.org/j2ee/dtd/jboss-app_4_0.dtd"</span>&gt;</span>
<span class="code-tag">&lt;jboss-app&gt;</span>
    <span class="code-tag">&lt;module&gt;</span>
        <span class="code-tag">&lt;har&gt;</span>brokerage.har<span class="code-tag">&lt;/har&gt;</span>
    <span class="code-tag">&lt;/module&gt;</span>
<span class="code-tag">&lt;/jboss-app&gt;</span>
</pre>
</div></div>
<p>The <b>jboss-app.xml</b> file located in the META-INF directory of the EAR specifies the name of the har file present in the EAR.</p>

<p>The following example shows the deployment descriptor <b>web.xml</b> used in this application. The <b>web.xml</b> file located in the WEB-INF directory of <tt><b>brokerage.war</b></tt> is the deployment descriptor where you specify, among other things, the servlets name and default JSP for the application.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>web.xml</b></div><div class="codeContent panelContent">
<pre class="code-xml">
<span class="code-tag">&lt;?xml version=<span class="code-quote">"1.0"</span> encoding=<span class="code-quote">"UTF-8"</span>?&gt;</span>
&lt;web-app xmlns=<span class="code-quote">"http://java.sun.com/xml/ns/j2ee"</span> version=<span class="code-quote">"2.4"</span> <span class="code-keyword">xmlns:xsi</span>=<span class="code-quote">"http://www.w3.org/2001/XMLSchema-instance"</span>
xsi:schemaLocation=<span class="code-quote">"http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"</span>&gt;
    <span class="code-tag">&lt;display-name&gt;</span>brokerage<span class="code-tag">&lt;/display-name&gt;</span>
    <span class="code-tag">&lt;servlet&gt;</span>
        <span class="code-tag">&lt;display-name&gt;</span>Trade-Dispatcher<span class="code-tag">&lt;/display-name&gt;</span>
        <span class="code-tag">&lt;servlet-name&gt;</span>TradeDispatcher<span class="code-tag">&lt;/servlet-name&gt;</span>
        <span class="code-tag">&lt;servlet-class&gt;</span>com.dev.trade.servlet.TradeDispatcherServlet<span class="code-tag">&lt;/servlet-class&gt;</span>
    <span class="code-tag">&lt;/servlet&gt;</span>
    <span class="code-tag">&lt;servlet-mapping&gt;</span>
        <span class="code-tag">&lt;servlet-name&gt;</span>TradeDispatcher<span class="code-tag">&lt;/servlet-name&gt;</span>
        <span class="code-tag">&lt;url-pattern&gt;</span>/login<span class="code-tag">&lt;/url-pattern&gt;</span>
    <span class="code-tag">&lt;/servlet-mapping&gt;</span>
    <span class="code-tag">&lt;servlet-mapping&gt;</span>
        <span class="code-tag">&lt;servlet-name&gt;</span>TradeDispatcher<span class="code-tag">&lt;/servlet-name&gt;</span>
        <span class="code-tag">&lt;url-pattern&gt;</span>/stocks<span class="code-tag">&lt;/url-pattern&gt;</span>
    <span class="code-tag">&lt;/servlet-mapping&gt;</span>
    <span class="code-tag">&lt;servlet-mapping&gt;</span>
        <span class="code-tag">&lt;servlet-name&gt;</span>TradeDispatcher<span class="code-tag">&lt;/servlet-name&gt;</span>
        <span class="code-tag">&lt;url-pattern&gt;</span>/userstocks<span class="code-tag">&lt;/url-pattern&gt;</span>
    <span class="code-tag">&lt;/servlet-mapping&gt;</span>
    <span class="code-tag">&lt;servlet-mapping&gt;</span>
        <span class="code-tag">&lt;servlet-name&gt;</span>TradeDispatcher<span class="code-tag">&lt;/servlet-name&gt;</span>
        <span class="code-tag">&lt;url-pattern&gt;</span>/buy<span class="code-tag">&lt;/url-pattern&gt;</span>
    <span class="code-tag">&lt;/servlet-mapping&gt;</span>
    <span class="code-tag">&lt;servlet-mapping&gt;</span>
        <span class="code-tag">&lt;servlet-name&gt;</span>TradeDispatcher<span class="code-tag">&lt;/servlet-name&gt;</span>
        <span class="code-tag">&lt;url-pattern&gt;</span>/sell<span class="code-tag">&lt;/url-pattern&gt;</span>
    <span class="code-tag">&lt;/servlet-mapping&gt;</span>
    <span class="code-tag">&lt;servlet-mapping&gt;</span>
        <span class="code-tag">&lt;servlet-name&gt;</span>TradeDispatcher<span class="code-tag">&lt;/servlet-name&gt;</span>
        <span class="code-tag">&lt;url-pattern&gt;</span>/register<span class="code-tag">&lt;/url-pattern&gt;</span>
    <span class="code-tag">&lt;/servlet-mapping&gt;</span>
    <span class="code-tag">&lt;welcome-file-list&gt;</span>
  <span class="code-tag">&lt;welcome-file&gt;</span>/login.jsp<span class="code-tag">&lt;/welcome-file&gt;</span>
    <span class="code-tag">&lt;/welcome-file-list&gt;</span>
    <span class="code-tag">&lt;error-page&gt;</span>
     <span class="code-tag">&lt;exception-type&gt;</span>javax.servlet.ServletException<span class="code-tag">&lt;/exception-type&gt;</span>
     <span class="code-tag">&lt;location&gt;</span>/error.jsp<span class="code-tag">&lt;/location&gt;</span>
    <span class="code-tag">&lt;/error-page&gt;</span>

    <span class="code-tag">&lt;resource-ref&gt;</span>
        <span class="code-tag">&lt;res-ref-name&gt;</span>jdbc/HibernateDB<span class="code-tag">&lt;/res-ref-name&gt;</span>
        <span class="code-tag">&lt;res-type&gt;</span>javax.sql.DataSource<span class="code-tag">&lt;/res-type&gt;</span>
        <span class="code-tag">&lt;res-auth&gt;</span>Container<span class="code-tag">&lt;/res-auth&gt;</span>
        <span class="code-tag">&lt;res-sharing-scope&gt;</span>Shareable<span class="code-tag">&lt;/res-sharing-scope&gt;</span>
    <span class="code-tag">&lt;/resource-ref&gt;</span>
<span class="code-tag">&lt;/web-app&gt;</span>
</pre>
</div></div>
<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Populatesampledata"></a>Populate sample data</h2>

<p>As we mentioned before, the <b>db.sql</b> script is provided to populate the sample data. The location of this file is already defined in the <b>build.properties</b> by the tag <b>sql.file</b>. To populate the sample data simply run the following command from the <b>&lt;brokerage_home&gt;</b> directory.</p>

<p><tt><b>ant populateDB</b></tt></p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Deploythesampleapplication"></a>Deploy the sample application</h2>

<p>Before you deploy the sample application you need to configure the datasource required by this application. To deploy the datasource configuration in JBoss copy the <b>mysql-ds.xml</b> file located in the <b>&lt;brokerage_home&gt;\plan</b> directory to the following directory:</p>

<p><tt><b>&lt;jboss_home&gt;\server\&lt;your_server_name&gt;\deploy</b></tt></p>

<p>Similarly to the database deployment, to deploy the Online Brokerage application in JBoss, copy the <b>brokerage.ear</b> file you just built with Ant to the following directory:</p>

<p><tt><b>&lt;jboss_home&gt;\server\&lt;your_server_name&gt;\deploy</b></tt></p>

<p>If JBoss is already started, it will automatically deploy and start the application; otherwise, the application will be deployed and started at the next startup.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Testthesampleapplication"></a>Test the sample application</h2>

<p>To test the application, open a Web browser and access the following URL:</p>

<p><a href="http://localhost:8080/brokerage" class="external-link" rel="nofollow">http://localhost:8080/brokerage</a></p>

<p>This brings up the login screen of the Online Brokerage application. Enter j2ee as the user name and password as the password and click on login. This takes you to the available stocks page illustrated in the following figure. The application is now configured and running.<span class="image-wrap" style="display: block; text-align: center"><img src="/confluence/download/attachments/20645282/available.jpg?version=1&amp;modificationDate=1204198993000" style="border: 0px solid black" /></span><br/>
<a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>
<h1><a name="JBosstoGeronimo-HibernateMigration-TheGeronimoenvironment"></a>The Geronimo environment <a name="JBosstoGeronimo-HibernateMigration-Geronimo"></a></h1>

<p>Download and install Geronimo from the following URL:</p>

<p><a href="http://geronimo.apache.org/downloads.html" class="external-link" rel="nofollow">http://geronimo.apache.org/downloads.html</a></p>

<p>The release notes available there provide clear instructions on system requirements and how to install and start Geronimo. Throughout the rest of this article we will refer to the Geronimo installation directory as <b>&lt;geronimo_home&gt;</b>.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-ConfigureResources"></a>Configure Resources</h2>

<p>For running the Online Brokerage application in Geronimo, you will be using the same MySQL database that was used with JBoss. So the first task you need to do in order to prepare the Geronimo environment is to configure the data source.</p>

<h3><a name="JBosstoGeronimo-HibernateMigration-Configurethedatasource"></a>Configure the datasource</h3>

<p>You need to copy the MySQL database driver into the Geronimo repository so that you can refer to it in the data source deployment plan. The Geronimo repository is located in the <b>&lt;geronimo_home&gt;/repository</b> directory. Inside this directory, create a new directory called <b>mysql/jars</b> and copy the <b>mysql-connector-java-3.1.14-bin.jar</b> file into it.</p>

<p>Now, you need to define a data source deployment plan. For your convenience, the sample application already provides a deployment plan called <b>mysql-geronimo-plan.xml</b> located in the <b>&lt;brokerage_home&gt;\plan</b> directory. The following example shows the content of this deployment plan.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>mysql-geronimo-plan.xml</b></div><div class="codeContent panelContent">
<pre class="code-xml">
<span class="code-tag">&lt;?xml version=<span class="code-quote">"1.0"</span> encoding=<span class="code-quote">"UTF-8"</span>?&gt;</span>
<span class="code-tag">&lt;connector xmlns=<span class="code-quote">"http://geronimo.apache.org/xml/ns/j2ee/connector-1.2"</span>&gt;</span>
  <span class="code-tag">&lt;dep:environment <span class="code-keyword">xmlns:dep</span>=<span class="code-quote">"http://geronimo.apache.org/xml/ns/deployment-1.1"</span>&gt;</span>
    <span class="code-tag">&lt;dep:moduleId&gt;</span>
	  <span class="code-tag">&lt;dep:groupId&gt;</span>user<span class="code-tag">&lt;/dep:groupId&gt;</span>
	  <span class="code-tag">&lt;dep:artifactId&gt;</span>database-pool-HibernateDB<span class="code-tag">&lt;/dep:artifactId&gt;</span>
	  <span class="code-tag">&lt;dep:version&gt;</span>2.0<span class="code-tag">&lt;/dep:version&gt;</span>
	  <span class="code-tag">&lt;dep:type&gt;</span>car<span class="code-tag">&lt;/dep:type&gt;</span>
	<span class="code-tag">&lt;/dep:moduleId&gt;</span>
	<span class="code-tag">&lt;dep:dependencies&gt;</span>
	  &lt;dep:dependency
	    <span class="code-tag">&lt;dep:groupId&gt;</span>mysql<span class="code-tag">&lt;/dep:groupId&gt;</span>
		<span class="code-tag">&lt;dep:artifactId&gt;</span>mysql-connector-java<span class="code-tag">&lt;/dep:artifactId&gt;</span>
		<span class="code-tag">&lt;dep:version&gt;</span>3.1.14-bin<span class="code-tag">&lt;/dep:version&gt;</span>
		<span class="code-tag">&lt;dep:type&gt;</span>jar<span class="code-tag">&lt;/dep:type&gt;</span>
	  <span class="code-tag">&lt;/dep:dependency&gt;</span>
	<span class="code-tag">&lt;/dep:dependencies&gt;</span>
  <span class="code-tag">&lt;/dep:environment&gt;</span>
  <span class="code-tag">&lt;resourceadapter&gt;</span>
    <span class="code-tag">&lt;outbound-resourceadapter&gt;</span>
      <span class="code-tag">&lt;connection-definition&gt;</span>
        <span class="code-tag">&lt;connectionfactory-interface&gt;</span>javax.sql.DataSource<span class="code-tag">&lt;/connectionfactory-interface&gt;</span>
        <span class="code-tag">&lt;connectiondefinition-instance&gt;</span>
          <span class="code-tag">&lt;name&gt;</span>HibernateDS<span class="code-tag">&lt;/name&gt;</span>
          <span class="code-tag">&lt;config-property-setting name=<span class="code-quote">"Password"</span>&gt;</span>password<span class="code-tag">&lt;/config-property-setting&gt;</span>
          <span class="code-tag">&lt;config-property-setting name=<span class="code-quote">"CommitBeforeAutocommit"</span>&gt;</span>false<span class="code-tag">&lt;/config-property-setting&gt;</span>
          <span class="code-tag">&lt;config-property-setting name=<span class="code-quote">"Driver"</span>&gt;</span>com.mysql.jdbc.Driver<span class="code-tag">&lt;/config-property-setting&gt;</span>
          <span class="code-tag">&lt;config-property-setting name=<span class="code-quote">"ExceptionSorterClass"</span>&gt;</span>org.tranql.connector.AllExceptionsAreFatalSorter<span class="code-tag">&lt;/config-property-setting&gt;</span>
          <span class="code-tag">&lt;config-property-setting name=<span class="code-quote">"UserName"</span>&gt;</span>root<span class="code-tag">&lt;/config-property-setting&gt;</span>
          <span class="code-tag">&lt;config-property-setting name=<span class="code-quote">"ConnectionURL"</span>&gt;</span>jdbc:mysql://localhost:3306/adi<span class="code-tag">&lt;/config-property-setting&gt;</span>
          <span class="code-tag">&lt;connectionmanager&gt;</span>
            <span class="code-tag">&lt;local-transaction/&gt;</span>
            <span class="code-tag">&lt;single-pool&gt;</span>
              <span class="code-tag">&lt;max-size&gt;</span>10<span class="code-tag">&lt;/max-size&gt;</span>
              <span class="code-tag">&lt;min-size&gt;</span>0<span class="code-tag">&lt;/min-size&gt;</span>
              <span class="code-tag">&lt;blocking-timeout-milliseconds&gt;</span>5000<span class="code-tag">&lt;/blocking-timeout-milliseconds&gt;</span>
              <span class="code-tag">&lt;idle-timeout-minutes&gt;</span>30<span class="code-tag">&lt;/idle-timeout-minutes&gt;</span>
              <span class="code-tag">&lt;match-one/&gt;</span>
            <span class="code-tag">&lt;/single-pool&gt;</span>
          <span class="code-tag">&lt;/connectionmanager&gt;</span>
        <span class="code-tag">&lt;/connectiondefinition-instance&gt;</span>
      <span class="code-tag">&lt;/connection-definition&gt;</span>
    <span class="code-tag">&lt;/outbound-resourceadapter&gt;</span>
  <span class="code-tag">&lt;/resourceadapter&gt;</span>
<span class="code-tag">&lt;/connector&gt;</span>
</pre>
</div></div>
<p>Now that you have a deployment plan and have copied the drivers the next step is to acutally deploy the datasource connection pool. If you have not yet started Geronimo please do so by running the following command:</p>

<p><tt><b>&lt;geronimo_home&gt;\bin\geronimo start</b></tt></p>

<p>To deploy the datasource connection pool run the following command:</p>

<p><tt><b>&lt;geronimo_home&gt;\bin\deploy &#45;-user system &#45;-password manager deploy &lt;brokerage_home&gt;\plan\mysql-geronimo-plan.xml ..\repository\org\tranql\tranql-connector-ra\1.3\tranql-connector-ra-1.3.rar</b></tt></p>

<p>Depending on your environment you should see a confirmation message similar to this one:</p>
<div class="preformatted panel" style="background-color: #FFFFFF;border-style: solid;border-width: 1px;"><div class="preformattedContent panelContent" style="background-color: #FFFFFF;">
<pre>C:\geronimo-3.0\bin&gt;deploy --user system --password manager deploy \brokerage\plan\mysql-geronimo-plan.xml
..\repository\org\tranql\tranql-connector-ra\1.3\tranql-connector-ra-1.3.rar
    Deployed user/database-pool-HibernateDS/2.0/car
</pre>
</div></div>
<p><font color="white">&nbsp;</font></p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h1><a name="JBosstoGeronimo-HibernateMigration-Stepbystepmigration"></a>Step-by-step migration <a name="JBosstoGeronimo-HibernateMigration-migration"></a></h1>

<p>Apache Geronimo does not support HAR archives so we will be having all the classes inside a WAR archive. We need to write two classes for making the application work on Geronimo. One is a TransactionManagerLookup class for Geronimo and the other is a utility class HibernateUtil to get the SessionFactory. In addition to this we will need to make some changes to the TradeDispatcherServlet and TradeDAO classes.</p>

<p>As a first step we will see the changes that need to be made to the application as illustrated in the following list.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-TradeDAO">TradeDAO</a><br/>
<a href="#JBosstoGeronimo-HibernateMigration-HibernateUtil">HibernateUtil</a><br/>
<a href="#JBosstoGeronimo-HibernateMigration-TradeDispatcherServlet">TradeDispatcherServlet</a></p>

<h3><a name="JBosstoGeronimo-HibernateMigration-TradeDAO"></a>TradeDAO <a name="JBosstoGeronimo-HibernateMigration-TradeDAO"></a></h3>

<p>In JBoss the HibernateMBean will create and bind the SessionFactory to the Global JNDI Context. So we can obtain the SessionFactory through a simple lookup. We can then get the session from the SessionFactory.</p>

<p><tt>TradeDAO.java</tt> is located in the <tt>&lt;brokerage_home&gt;/src/com/dev/trade/dao</tt> directory.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>Excerpt from TradeDAO.java for JBoss</b></div><div class="codeContent panelContent">
<pre class="code-java">
<span class="code-keyword">package</span> com.dev.trade.dao;

<span class="code-keyword">import</span> java.sql.Connection;
<span class="code-keyword">import</span> java.sql.SQLException;
<span class="code-keyword">import</span> java.util.ArrayList;
<span class="code-keyword">import</span> java.util.Iterator;
<span class="code-keyword">import</span> java.util.List;
<span class="code-keyword">import</span> java.util.Set;

<span class="code-keyword">import</span> javax.naming.InitialContext;
<span class="code-keyword">import</span> javax.naming.NamingException;

<span class="code-keyword">import</span> org.hibernate.Query;
<span class="code-keyword">import</span> org.hibernate.Session;
<span class="code-keyword">import</span> org.hibernate.SessionFactory;

<span class="code-keyword">import</span> com.dev.trade.bo.Stock;
<span class="code-keyword">import</span> com.dev.trade.bo.User;
<span class="code-keyword">import</span> com.dev.trade.bo.UserStock;
<span class="code-keyword">import</span> com.dev.trade.exception.DBException;
<span class="code-keyword">import</span> com.dev.trade.util.HibernateUtil;

<span class="code-keyword">public</span> class TradeDAO {

	SessionFactory factory  = <span class="code-keyword">null</span>;
	Session session = <span class="code-keyword">null</span>;

	<span class="code-keyword">public</span> TradeDAO() <span class="code-keyword">throws</span> Exception {

		<span class="code-keyword">try</span> {
			InitialContext ctx = <span class="code-keyword">new</span> InitialContext();
		    factory  = (SessionFactory)ctx.lookup(<span class="code-quote">"java:hibernate/BrokerageSessionFactory"</span>);

		} <span class="code-keyword">catch</span> (NamingException e1) {
			<span class="code-comment">// TODO Auto-generated <span class="code-keyword">catch</span> block
</span>			e1.printStackTrace();
		}
	}

	<span class="code-keyword">public</span> User getUserByUserId(<span class="code-object">String</span> userId) <span class="code-keyword">throws</span> DBException {

		session = factory.getCurrentSession();
		Query q = session.createQuery(<span class="code-quote">"from User u where u.userId=:userId"</span>);
		q.setString(<span class="code-quote">"userId"</span>, userId);
		<span class="code-keyword">return</span> (User) q.uniqueResult();

	}
	...
</pre>
</div></div>
<p>In Geronimo we will write a new utility class to create the SessionFactory, this class will be the HibernateUtil class. It has a method getCurrentSession() that will return the session.</p>

<p>Modify the first part of <tt>TradeDAO.java</tt> to match the changes in the following excerpt.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>Excerpt from TradeDAO.java for Geronimo</b></div><div class="codeContent panelContent">
<pre class="code-java">
<span class="code-keyword">package</span> com.dev.trade.dao;

<span class="code-keyword">import</span> java.sql.Connection;
<span class="code-keyword">import</span> java.sql.SQLException;
<span class="code-keyword">import</span> java.util.ArrayList;
<span class="code-keyword">import</span> java.util.Iterator;
<span class="code-keyword">import</span> java.util.List;
<span class="code-keyword">import</span> java.util.Set;

<span class="code-keyword">import</span> org.hibernate.Query;
<span class="code-keyword">import</span> org.hibernate.Session;

<span class="code-keyword">import</span> com.dev.trade.bo.Stock;
<span class="code-keyword">import</span> com.dev.trade.bo.User;
<span class="code-keyword">import</span> com.dev.trade.bo.UserStock;
<span class="code-keyword">import</span> com.dev.trade.exception.DBException;
<span class="code-keyword">import</span> com.dev.trade.util.HibernateUtil;

<span class="code-keyword">public</span> class TradeDAO {


      Session session = <span class="code-keyword">null</span>;

       <span class="code-keyword">public</span> TradeDAO() <span class="code-keyword">throws</span> Exception {

        }

       <span class="code-keyword">public</span> User getUserByUserId(<span class="code-object">String</span> userId) <span class="code-keyword">throws</span> DBException {

            session = HibernateUtil.getCurrentSession();
                Query q = session.createQuery(<span class="code-quote">"from User u where u.userId=:userId"</span>);
                q.setString(<span class="code-quote">"userId"</span>, userId);
              <span class="code-keyword">return</span> (User) q.uniqueResult();

       }
       ...
</pre>
</div></div>
<p>Do a search and replace, look for the following string:</p>

<p><tt><b>factory.getCurrentSession()</b></tt></p>

<p>and replace it with</p>

<p><tt><b>HibernateUtil.getCurrentSession()</b></tt></p>

<p><em>You should count 9 replacements.</em></p>

<p>This difference in obtaining the session will be the main change in the codebase for the application to run in Apache Geronimo.</p>

<h3><a name="JBosstoGeronimo-HibernateMigration-HibernateUtil"></a>HibernateUtil <a name="JBosstoGeronimo-HibernateMigration-HibernateUtil"></a></h3>

<p>As mentioned above we will use this class to create the SessionFactory and provide the application with Hibernate sessions. The source code for the class is given below</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>HibernateUtil.java for Geronimo</b></div><div class="codeContent panelContent">
<pre class="code-java">
<span class="code-keyword">package</span> com.dev.trade.util;

<span class="code-keyword">import</span> org.hibernate.HibernateException;
<span class="code-keyword">import</span> org.hibernate.Session;
<span class="code-keyword">import</span> org.hibernate.cfg.Configuration;

/**
 * Configures and provides access to Hibernate sessions, tied to the
 * current thread of execution.  Follows the <span class="code-object">Thread</span> Local Session
 * pattern, see {@link http:<span class="code-comment">//hibernate.org/42.html}.
</span> */
<span class="code-keyword">public</span> class HibernateUtil {

    /** location of the Hibernate Configuration File */
    <span class="code-keyword">private</span> <span class="code-keyword">static</span> <span class="code-object">String</span> CONFIG_FILE_LOCATION = <span class="code-quote">"hibernate.cfg.xml"</span>;

    /** Holds a single instance of Session */
    <span class="code-keyword">private</span> <span class="code-keyword">static</span> <span class="code-keyword">final</span> ThreadLocal threadLocal = <span class="code-keyword">new</span> ThreadLocal();

    /** The single instance of hibernate configuration */
    <span class="code-keyword">private</span> <span class="code-keyword">static</span> <span class="code-keyword">final</span> Configuration cfg = <span class="code-keyword">new</span> Configuration();

    /** The single instance of hibernate SessionFactory */
    <span class="code-keyword">private</span> <span class="code-keyword">static</span> org.hibernate.SessionFactory sessionFactory;

    /**
     * Returns the ThreadLocal Session instance.  Lazy initialize
     * the &lt;code&gt;SessionFactory&lt;/code&gt; <span class="code-keyword">if</span> needed.
     *
     *  @<span class="code-keyword">return</span> Session
     *  @<span class="code-keyword">throws</span> HibernateException
     */
    <span class="code-keyword">public</span> <span class="code-keyword">static</span> Session getCurrentSession() <span class="code-keyword">throws</span> HibernateException {
        Session session = (Session) threadLocal.get();

        <span class="code-keyword">if</span> (session == <span class="code-keyword">null</span> || ! session.isConnected()) {
            <span class="code-keyword">if</span> (sessionFactory == <span class="code-keyword">null</span>) {
                <span class="code-keyword">try</span> {
                    cfg.configure(CONFIG_FILE_LOCATION);
                    sessionFactory = cfg.buildSessionFactory();
                }
                <span class="code-keyword">catch</span> (Exception e) {
                    <span class="code-object">System</span>.err.println(<span class="code-quote">"%%%% Error Creating SessionFactory %%%%"</span>);
                    e.printStackTrace();
                }
            }
            session = sessionFactory.openSession();
            threadLocal.set(session);
        }

        <span class="code-keyword">return</span> session;
    }

    /**
     *  Close the single hibernate session instance.
     *
     *  @<span class="code-keyword">throws</span> HibernateException
     */
    <span class="code-keyword">public</span> <span class="code-keyword">static</span> void closeSession() <span class="code-keyword">throws</span> HibernateException {
        Session session = (Session) threadLocal.get();


        <span class="code-keyword">if</span> (session != <span class="code-keyword">null</span>) {
            session.close();
        }
    }



}
</pre>
</div></div>
<p><tt>HibernateUtil.java</tt> is located in the <tt>&lt;brokerage_home&gt;/src/com/dev/trade/util</tt> directory. For your convenience, a copy of this file is already provided with the sample application.</p>

<h3><a name="JBosstoGeronimo-HibernateMigration-TradeDispatcherServlet"></a>TradeDispatcherServlet <a name="JBosstoGeronimo-HibernateMigration-TradeDispatcherServlet"></a></h3>

<p>In this class there will also be a difference in getting the SessionFactory. In JBoss we get it from the JNDI Context but in Geronimo we will get it through the utility class.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>doGet method for JBoss</b></div><div class="codeContent panelContent">
<pre class="code-java">
<span class="code-keyword">protected</span> void doGet(HttpServletRequest request,
   HttpServletResponse response) <span class="code-keyword">throws</span> ServletException, IOException {

   Session hsession = <span class="code-keyword">null</span>;
   <span class="code-keyword">try</span> {
         InitialContext ctx = <span class="code-keyword">new</span> InitialContext();
         SessionFactory factory  =  (SessionFactory)ctx.lookup(<span class="code-quote">"java:hibernate/BrokerageSessionFactory"</span>);
         hsession = factory.openSession();
       } <span class="code-keyword">catch</span> (NamingException e1) {
            e1.printStackTrace();
       }

    Transaction tr = hsession.beginTransaction();
</pre>
</div></div>
<p><tt>TradeDispatcherServlet.java</tt> is located in the <tt>&lt;brokerage_home&gt;/src/com/dev/trade/servlet</tt> directory. Replace the doGet method for the one shown in the following example.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>doGet method for Geronimo</b></div><div class="codeContent panelContent">
<pre class="code-java">
<span class="code-keyword">protected</span> void doGet(HttpServletRequest request,
    HttpServletResponse response) <span class="code-keyword">throws</span> ServletException, IOException {

    Transaction tr = HibernateUtil.getCurrentSession().getTransaction();
    tr.begin();
</pre>
</div></div>
<p>Hibernate comes with transaction manager lookup classes for many application servers. Unfortunately Hibernate 3.2 does not have a lookup class specific for Apache Geronimo, so we need to write our own. The code for the Geronimo specific transaction manager lookup is shown in the following example.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>GeronimoTransactionManagerLookup</b></div><div class="codeContent panelContent">
<pre class="code-java">
<span class="code-keyword">package</span> org.hibernate.transaction;

<span class="code-keyword">import</span> java.util.Iterator;
<span class="code-keyword">import</span> java.util.Properties;
<span class="code-keyword">import</span> java.util.Set;

<span class="code-keyword">import</span> javax.transaction.TransactionManager;
<span class="code-keyword">import</span> org.hibernate.HibernateException;
<span class="code-keyword">import</span> org.hibernate.transaction.TransactionManagerLookup;

<span class="code-keyword">import</span> org.apache.geronimo.gbean.AbstractName;
<span class="code-keyword">import</span> org.apache.geronimo.gbean.AbstractNameQuery;
<span class="code-keyword">import</span> org.apache.geronimo.kernel.Kernel;
<span class="code-keyword">import</span> org.apache.geronimo.kernel.KernelRegistry;
<span class="code-keyword">import</span> org.apache.geronimo.kernel.proxy.ProxyManager;

<span class="code-keyword">public</span> class GeronimoTransactionManagerLookup <span class="code-keyword">implements</span>
        TransactionManagerLookup {

    <span class="code-keyword">public</span> <span class="code-keyword">static</span> <span class="code-keyword">final</span> <span class="code-object">String</span> UserTransactionName = <span class="code-quote">"java:comp/UserTransaction"</span>;

    <span class="code-keyword">public</span> <span class="code-object">Object</span> getTransactionIdentifier(Transaction arg0) {
		<span class="code-keyword">return</span> <span class="code-keyword">null</span>;
    }

    <span class="code-keyword">public</span> TransactionManager getTransactionManager(Properties props) <span class="code-keyword">throws</span> HibernateException {
       /*
         * <span class="code-keyword">try</span> { Kernel kernel = KernelRegistry.getSingleKernel(); ProxyManager
         * proxyManager = kernel.getProxyManager(); AbstractNameQuery query =
         * <span class="code-keyword">new</span> AbstractNameQuery(TransactionManager.class.getName()); Set names =
         * kernel.listGBeans(query); AbstractName name = <span class="code-keyword">null</span>; <span class="code-keyword">for</span> (Iterator it =
         * names.iterator(); it.hasNext();) name = (AbstractName) it.next();
         * <span class="code-object">Object</span> transMg = (<span class="code-object">Object</span>) proxyManager.createProxy(name,
         * TransactionManager.class); <span class="code-keyword">return</span> (TransactionManager)transMg; }<span class="code-keyword">catch</span>
         * (Exception e) { e.printStackTrace(); <span class="code-object">System</span>.out.println(); <span class="code-keyword">throw</span> <span class="code-keyword">new</span>
         * HibernateException(<span class="code-quote">"Geronimo Transaction Manager Lookup Failed"</span>, e); }
         */
       <span class="code-keyword">try</span> {
       Kernel kernel = KernelRegistry.getSingleKernel();
       AbstractNameQuery query = <span class="code-keyword">new</span> AbstractNameQuery(TransactionManager.class.getName ());
       Set&lt;AbstractName&gt; names = kernel.listGBeans(query);
       <span class="code-keyword">if</span> (names.size() != 1) {
           <span class="code-keyword">throw</span> <span class="code-keyword">new</span> IllegalStateException(<span class="code-quote">"Expected one transaction manager, not "</span> + names.size());
       }
       AbstractName name = names.iterator().next();
       TransactionManager transMg = (TransactionManager)
       kernel.getGBean(name);
       <span class="code-keyword">return</span> (TransactionManager)transMg;
       } <span class="code-keyword">catch</span> (Exception e) {
           e.printStackTrace();
           <span class="code-object">System</span>.out.println();
           <span class="code-keyword">throw</span> <span class="code-keyword">new</span> HibernateException(<span class="code-quote">"Geronimo Transaction Manager Lookup Failed"</span>, e);
       }
   }

    <span class="code-keyword">public</span> <span class="code-object">String</span> getUserTransactionName() {
        <span class="code-keyword">return</span> UserTransactionName;
    }
}
</pre>
</div></div>
<p>For your convenience this class is already provided in the <tt>&lt;brokerage_home&gt;/TransactionManager</tt> directory. Create the following directory structure and copy the <tt>GeronimoTransactionManagerLookup.java</tt> there.</p>

<p>&#42;<tt>brokerage_home&gt;/src/org/hibernate/transaction</tt></p>

<p>Now you need to create the hibernate configuration file hibernate-cfg.xml. Inside this file you will specify the required hibernate configuration attributes. Note that the <tt>hibernate-service.xml</tt> in JBoss is for doing the same thing. For your convenience this file is also provided with the sample application in the <tt>&lt;brokerage_home&gt;/hibrenate</tt> directory.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>hibernate-cfg.xml</b></div><div class="codeContent panelContent">
<pre class="code-xml">
<span class="code-tag">&lt;?xml version='1.0' encoding='utf-8'?&gt;</span>
&lt;!DOCTYPE hibernate-configuration PUBLIC
        <span class="code-quote">"-//Hibernate/Hibernate Configuration DTD 3.0//EN"</span>
        <span class="code-quote">"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"</span>&gt;

<span class="code-tag">&lt;hibernate-configuration&gt;</span>
 <span class="code-tag">&lt;session-factory&gt;</span>
 <span class="code-tag"><span class="code-comment">&lt;!-- properties --&gt;</span></span>
 <span class="code-tag">&lt;property name=<span class="code-quote">"connection.datasource"</span>&gt;</span>java:comp/env/jdbc/HibernateDB<span class="code-tag">&lt;/property&gt;</span>
 <span class="code-tag">&lt;property name=<span class="code-quote">"hibernate.transaction.manager_lookup_class"</span>&gt;</span>
    org.hibernate.transaction.GeronimoTransactionManagerLookup
 <span class="code-tag">&lt;/property&gt;</span>

  <span class="code-tag">&lt;property name=<span class="code-quote">"hibernate.dialect"</span>&gt;</span>org.hibernate.dialect.MySQLDialect<span class="code-tag">&lt;/property&gt;</span>

 <span class="code-tag"><span class="code-comment">&lt;!-- Disable the second-level cache  --&gt;</span></span>
<span class="code-tag">&lt;property name=<span class="code-quote">"hibernate.cache.provider_class"</span>&gt;</span>org.hibernate.cache.NoCacheProvider<span class="code-tag">&lt;/property&gt;</span>
<span class="code-tag">&lt;property name=<span class="code-quote">"hibernate.current_session_context_class"</span>&gt;</span>org.hibernate.context.JTASessionContext<span class="code-tag">&lt;/property&gt;</span>
 <span class="code-tag"><span class="code-comment">&lt;!-- Echo all executed SQL to stdout --&gt;</span></span>
 <span class="code-tag">&lt;property name=<span class="code-quote">"hibernate.show_sql"</span>&gt;</span>true<span class="code-tag">&lt;/property&gt;</span>

 <span class="code-tag"><span class="code-comment">&lt;!-- Drop and re-create the database schema on startup --&gt;</span></span>
<span class="code-tag"><span class="code-comment">&lt;!--&lt;property name=<span class="code-quote">"hibernate.hbm2ddl.auto"</span>&gt;</span>create<span class="code-tag">&lt;/property&gt;</span> --&gt;</span>

 <span class="code-tag"><span class="code-comment">&lt;!-- mapping files --&gt;</span></span>
 <span class="code-tag">&lt;mapping resource=<span class="code-quote">"Stock.hbm.xml"</span>/&gt;</span>
 <span class="code-tag">&lt;mapping resource=<span class="code-quote">"UserStock.hbm.xml"</span>/&gt;</span>
 <span class="code-tag">&lt;mapping resource=<span class="code-quote">"User.hbm.xml"</span>/&gt;</span>

 <span class="code-tag">&lt;/session-factory&gt;</span>
<span class="code-tag">&lt;/hibernate-configuration&gt;</span>
</pre>
</div></div>
<p>Additional details for the specific functions of each of these properties can be found in the hibernate manual.</p>

<p>One last step before building is to create a <b>geronimo-web.xml</b> file which is the Geronimo specific deployment descriptor as illustrated in the following example. Once again, for your convenience this file is also provided with the sample application in the <tt>&lt;brokerage_home&gt;/web/descriptors/geronimo</tt> directory.</p>
<div class="code panel" style="border-style: solid;border-width: 1px;"><div class="codeHeader panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;"><b>geronimo-web.xml</b></div><div class="codeContent panelContent">
<pre class="code-xml">
<span class="code-tag">&lt;?xml version=<span class="code-quote">"1.0"</span> encoding=<span class="code-quote">"ISO-8859-1"</span>?&gt;</span>
<span class="code-tag">&lt;web-app xmlns=<span class="code-quote">"http://geronimo.apache.org/xml/ns/j2ee/web-1.1"</span> <span class="code-keyword">xmlns:naming</span>=<span class="code-quote">"http://geronimo.apache.org/xml/ns/naming-1.1"</span>&gt;</span>
    <span class="code-tag">&lt;dep:environment <span class="code-keyword">xmlns:dep</span>=<span class="code-quote">"http://geronimo.apache.org/xml/ns/deployment-1.1"</span>&gt;</span>
	    <span class="code-tag">&lt;dep:moduleId&gt;</span>
		    <span class="code-tag">&lt;dep:groupId&gt;</span>BrokerageApp<span class="code-tag">&lt;/dep:groupId&gt;</span>
			<span class="code-tag">&lt;dep:artifactId&gt;</span>MySqlDS<span class="code-tag">&lt;/dep:artifactId&gt;</span>
			<span class="code-tag">&lt;dep:version&gt;</span>2.0<span class="code-tag">&lt;/dep:version&gt;</span>
			<span class="code-tag">&lt;dep:type&gt;</span>car<span class="code-tag">&lt;/dep:type&gt;</span>
		<span class="code-tag">&lt;/dep:moduleId&gt;</span>

		<span class="code-tag">&lt;dep:dependencies&gt;</span>
		    <span class="code-tag">&lt;dep:dependency&gt;</span>
		        <span class="code-tag">&lt;dep:groupId&gt;</span>user<span class="code-tag">&lt;/dep:groupId&gt;</span>
			    <span class="code-tag">&lt;dep:artifactId&gt;</span>database-pool-HibernateDB<span class="code-tag">&lt;/dep:artifactId&gt;</span>
			    <span class="code-tag">&lt;dep:version&gt;</span>2.0<span class="code-tag">&lt;/dep:version&gt;</span>
			    <span class="code-tag">&lt;dep:type&gt;</span>car<span class="code-tag">&lt;/dep:type&gt;</span>
			<span class="code-tag">&lt;/dep:dependency&gt;</span>
		<span class="code-tag">&lt;/dep:dependencies&gt;</span>

		<span class="code-tag">&lt;dep:hidden-classes&gt;</span>
		    <span class="code-tag">&lt;dep:filter&gt;</span>org.springframework<span class="code-tag">&lt;/dep:filter&gt;</span>
			<span class="code-tag">&lt;dep:filter&gt;</span>META-INF/spring<span class="code-tag">&lt;/dep:filter&gt;</span>
			<span class="code-tag"><span class="code-comment">&lt;!--dep:filter&gt;</span>antlr<span class="code-tag">&lt;/dep:filter--&gt;</span></span>
		<span class="code-tag">&lt;/dep:hidden-classes&gt;</span>
	<span class="code-tag">&lt;/dep:environment&gt;</span>

	<span class="code-tag">&lt;context-root&gt;</span>/brokerage<span class="code-tag">&lt;/context-root&gt;</span>

    <span class="code-tag">&lt;resource-ref&gt;</span>
        <span class="code-tag">&lt;ref-name&gt;</span>jdbc/HibernateDB<span class="code-tag">&lt;/ref-name&gt;</span>
        <span class="code-tag">&lt;resource-link&gt;</span>HibernateDS<span class="code-tag">&lt;/resource-link&gt;</span>
    <span class="code-tag">&lt;/resource-ref&gt;</span>
<span class="code-tag">&lt;/web-app&gt;</span>
</pre>
</div></div>
<p>The <tt>&lt;hidden-classes&gt;</tt> element is for preventing certain classes that come with Apache Geronimo from being visible to the war classloader which may result in version problems.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Buildthemigratedsampleapplication"></a>Build the migrated sample application</h2>

<p>To build the application run the following commands</p>
<ul>
	<li>Add the hibernate jar to the classpath. You will now need to build hibernate with the <tt>GeronimoTransactionManagerLookup</tt> class. If you have not downloaded the hibernate source you can compile the class after putting the hibernate jar in the classpath and then manually add that class to the hibernate jar file.<br/>
<tt><b>set CLASSPATH=%CLASSPATH%;&lt;hibernate_home&gt;/lib/hibernate3.jar</b></tt></li>
	<li>Add the Geronimo kernel to your classpath<br/>
<tt><b>set CLASSPATH=%CLASSPATH%;&lt;geronimo_home&gt;/lib/geronimo-kernel-2.2.jar</b></tt></li>
</ul>


<ul>
	<li>To add the class manually, although not needed for this particular sample, you can use the tool of your preference and add the GeronimoTransactionManagerLookup.class to the <tt>org\hibernate\transaction</tt> directory in the <tt>hibernate_home&gt;/lib/hibernate3.jar</tt> file.</li>
</ul>


<ul>
	<li>Now build the migrated application by running the following command:</li>
</ul>


<p><tt><b>&lt;brokerage_home&gt;/ant war</b></tt></p>

<p>Note that we are just building the <b>war</b> target because the Online Brokerage sample application is just a web application. In the JBoss section we used an <b>ear</b> to package the <b>war</b> and the <b>har</b>, this last one is not supported by Apache Geronimo.</p>

<p>This will create a <b>brokerage.war</b> file in the <b>&lt;brokerage_home&gt;/geronimo-artefact</b> directory.</p>

<p>The <b>&lt;brokerage_home&gt;/solutions</b> directory has the source files already migrated to compile for and run in Apache Geronimo.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h2><a name="JBosstoGeronimo-HibernateMigration-Deploythemigratedsampleapplication"></a>Deploy the migrated sample application</h2>

<p>To deploy the migrated Online Brokerage application, make sure the Geronimo server is up and running and run the following command:</p>

<p><tt><b>deploy &#45;-user system &#45;-password manager deploy &lt;brokerage_home&gt;/geronimo-artefact/brokerage.war</b></tt></p>

<p>Once the application is deployed, open a Web browser and access the following URL:</p>

<p><a href="http://localhost:8080/brokerage" class="external-link" rel="nofollow">http://localhost:8080/brokerage</a></p>

<p>Login with the same user name and password you used when testing the application from JBoss.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></p>

<h1><a name="JBosstoGeronimo-HibernateMigration-Summary"></a>Summary <a name="JBosstoGeronimo-HibernateMigration-summary"></a></h1>

<p>This article has shown you how to migrate a sample application that uses Hibernate as its O/R mapping layer, from JBoss to the Apache Geronimo application server. Some of the features/functionalities already provided by JBoss may not yet be implemented in Geronimo, as a consequence some minor additional coding may be required but the overall migration complexity is low.</p>

<p><a href="#JBosstoGeronimo-HibernateMigration-top">Back to Top</a></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/JBoss+to+Geronimo+-+Hibernate+Migration">View Online</a>
        |
        <a href="https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=20645282&revisedVersion=2&originalVersion=1">View Changes</a>
                |
        <a href="https://cwiki.apache.org/confluence/display/GMOxDOC30/JBoss+to+Geronimo+-+Hibernate+Migration?showComments=true&amp;showCommentArea=true#addcomment">Add Comment</a>
            </div>
</div>
</div>
</div>
</div>
</body>
</html>

Mime
View raw message