|Home > Documentation > Apache Geronimo v1.1 - User's Guide > Migrating to Apache Geronimo > JBoss to Geronimo - JDBC Migration|
This article will help you migrate JDBC applications developed for JBoss v4.0.5 to Apache Geronimo v1.1 and is part of a series of migration articles covering different types of applications migration.
This article provides details on the JDBC implementation differences between these two application servers as well as a detailed step-by-step migration procedure for porting JDBC applications from JBoss v4.0.5 to Apache Geronimo. To define a common starting point (the source environment), this article provides steps for deploying the Online Brokerage sample application into the JBoss source environment. Then, you will be guided through the application migration and deployment process in Apache Geronimo.
This article is organized in the following sections:
JDBC implementation may vary from one vendor to another. The purpose of this section is to provide a JDBC specific feature-to-feature comparison between JBoss and Apache Geronimo so you can clearly identify the differences and plan accordingly before migration.
Given that JBoss and Geronimo both use J2CA connectors for accessing JDBC resources, there will be an overlap of some J2CA features when comparing the platform specific JDBC features.
JDBC access in JBoss is through JDBC connectors based on the JCA specification.
Geronimo does not have any direct integration with JDBC but supports access through the generic J2CA framework. The TranQL project has J2CA adapters for various databases.
JBoss AS 4.0 implements the JCA (Java Connector Architecture) 1.5 specification instead of the JCA 1.0 in JBoss AS 3.2.
Geronimo supports the JCA 1.5 specification and is backward compatible to the JCA 1.0 specification.
Data sources supported
Supports 5 types of data sources:
TranQL has generic wrappers for data source, ConnectionPoolDatasource, and XADataSource.
Data source failover
JBoss has data source failover capabilities implemented through two data sources.
TranQL has specialized drivers for certain databases (including Apache Derby, Oracle and soon DB2) that provide a tighter integration with the advanced features of the driver.
Supports XA transactions, Local Transactions, and No transaction.
Supports XA transactions, Local Transactions, and No transaction.
Connection Manager Configurability
You can plug in your own custom connection manager if required.
The J2CA framework is interceptor based which allows different parts of the connection framework to be plugged in.
Full support for JTA through JBossJTA.
Transaction support is provided through JOTM and HOWL.
Connection pooling and management
JBossCX framework used for connection pooling and management.
Custom Geronimo Code and TranQL used for connection pooling and management.
Legacy driver support
JBoss provides connection to RDBMS that have not yet implemented JCA- JDBC drivers through JCA wrappers for JDBC drivers.
Geronimo also provides this through the TranQL- connector JDBC to JCA wrapper in Geronimo. Supports JDBC 3.0 and 2.1.
This article contains a sample application to demonstrate the migration of an application from JBoss to Geronimo, called Online Brokerage. It represents an online trading scenario in which users can buy and sell stocks. The application has the following five pages:
The following figure illustrates the application flow:
First, the user accesses the Login page. From the Login page the user enters the username and password. If the username or password is not valid the application throws an error message and rejects the user's login attempt. If the username 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.
The user can choose to buy as many stocks as required, depending on the funds availabe 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. On clicking this button the user is taken to the User Info page and shown the user details.
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 has, the application will throw an error. The error message will be shown on the same page. For each successful sale the sale amount is added to the user's cash balance.
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.
The Online Brokerage sample application consists of the following packages:
The Online Brokerage also includes the following JSP pages:
The tools used for developing and building the Online Brokerage application are:
The Eclipse IDE was used for development of the sample application. This is a very powerful and popular open source development tool. Integration plug-ins are available for both JBoss and Geronimo. Eclipse can be downloaded from the following URL:
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:
The database used for demostrating this application is MySQL. The name of the sample database is tradedb and it consists of the following three tables; STOCKS, USERS and TRADINGACCOUNT. The fields for each of these tables are described below.
The TRADINGACCOUNT 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.
The DDL file used for populating this database is db.sql and it is located in the brokerage/config/sql directory.
This section shows you how and where the sample JBoss reference environment was installed so you can map this scenario to your own implementation.
Detailed instructions for installing, configuring, and managing JBoss are provided in the product documentation. Check the product Web site for the most updated documents.
The following list highlights the general tasks you will need to complete to install and configure the initial environment as the starting point for deploying the sample application.
In order to build and run the Online Brokerage application included in this article, you need to install and configure the build tool and the database that is used by the application.
As mentioned earlier in the article, this application is using the MySQL database and that can be downloaded from the following URL:
The installation and configuration of MySQL is fairly intuitive and it is well documented in the MySQL Reference Manual available at the following URL:
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.
Once the MySQL instance is configured you need to create the sample database that will be used by the Online Brokerage application. From command line, type the following command to start the MySQL monitor:
mysql -u root -p
Then enter your password to enter log in to the MySQL command interface as shown in the following example:
From the MySQL command interface create the tradedb sample database by typing the following command:
mysql> create database tradedb;
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 <ant_home>/bin directory is added to the system's path variable.
Apache Ant can be downloaded from the following URL:
In order to successfully build and deploy the Online Brokerage application and database, you will first need to configure some resources. This section describes how to configure a MySQL data source in JBoss.
The Online Brokerage application is a Web application that uses a data source to connect to the MySQL database. To use JBoss with MySQL you need to copy the MySQL driver into the JBoss server classpath. The driver, which is provided by the database vendor, is called Connector/J 3.0 and can be downloaded from the following URL:
After downloading and extracting the driver, copy the mysql-connector-java-3.0.17-ga-bin.jar file to the <jboss_home>/server/<your_server_name>/lib directory.
The data source configuration in JBoss is done through an XML configuration file. The JBoss installation contains sample configuration files for many popular databases including MySQL.
The sample data source configuration file for MySQL is mysql-ds.xml and it is located in the <jboss_home>/docs/examples/jca directory:
Copy the mysql-ds.xml file to the deploy directory of your JBoss server (<jboss_home>/server/<your_server_name>/deploy) and edit it as shown in the following example:
Delete all the other tags inside the <local-tx-datasource> tag and save the file. JBoss will automatically deploy the data source.
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 Online Brokerage application from the following link:
After extracting the zip file, a brokerage directory is created. In that directory open the build.properties file and edit the properties to match your environment as shown in the following example:
When specifying the driver.classpath in the build.properties file, make sure to use just the forward slash "/" , otherwise the build will not find the jar file.
From a command prompt or shell go to the brokerage directory and run ant war-jboss. This will build the war file and place it directly in the brokerage directory. The war created by the ant build contains a JBoss specific deployment descriptor, the jboss-web.xml file in the WEB-INF directory of the WAR is shown in the following example.
The resource-ref element is used to map the resource referred to by the name jdbc/TradeDB in the web.xml file to the resource with the JNDI name java:jdbc/TradeDB i.e. the MySQL datasource.
To deploy the sample application just copy the brokerage.war will be created under the brokerage/releases/jboss folder to the <jboss_home>/server/<your_server_name>/deploy folder.
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.
To test the application, open a Web browser and access the following URL:
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.
If you want to use another root password for the database, replace the occurrences of 'password' with the required password. This has to be changed in the following three places:
Download and install Geronimo from the following URL:
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 <geronimo_home>.
If you are planning to run JBoss and Geronimo on the same machine consider to change the default service ports on, at least, one of these servers.
In Geronimo the JDBC resources are implemented using J2EE connectors. Therefore, you need to write a Geronimo specific deployment plan for deploying a JDBC datasource. Additionally, while doing the deployment you need to provide the deployer with the tranql-connector-1.2.rar file. This RAR file contains the connection pool management logic for Geronimo.
For running the Online Brokerage application in Geronimo, you will be using the same MySQL database that was used with JBoss. So the only task you need to do in order to prepare the Geronimo environment is to configure the data source.
First part of the configuration is to upload the mysql-connector-java-3.0.17-ga-bin.jar library to the application server. Using the Geronimo console is the easiest way to achieve this task without much of configuration issues.
There are three types of data sources that Geronimo supports:
Next user have to deploy database connection pool of the Geronimo. Given is the sample database pool deployment plan comes with this application. This configuration file is going to deploy as a Global datasource in the Geronimo server.
First part of this xml deployment plan is more of a Maven 2 configuration file. Following are some of the other important parts of the above deployment plan.
The following table shows the configuration properties that are specified by the config-property-setting element.
Fully qualified class name of the JDBC driver.
The JDBC connection URL. This can contain parameters when supported by the driver. For example, for MySQL to use named pipes instead of TCP/IP you can attach ?socketFactory=com.mysql.jdbc.NamedPipeSocketFactory to the JDBC connection URL.
The user name needed to connect to the database.
The password needed to connect to the database.
In case the JDBC driver does not commit the pending data changes when setAutoCommit (true) is called.
To provide information to the pool whether the Exceptions that occur are fatal or not.
To deploy the Database connection pool follow the given steps in the Geronimo console.
Now you are ready to proceed with the migration.
Geronimo does not support accessing external resources(JDBC datasources) by setting JNDI properties at runtime.
This is because reference resolution is done at deploy time and is based on the JSR-77 object names of the target component. In order to migrate the Online Brokerage application to Geronimo, you first need to replace the jboss-web.xml file with a geronimo-web.xml file which is the Geronimo-specific descriptor file.
The geronimo-web.xml file is located in the brokerage/web/WEB-INF directory and looks like the following example. Note that naming:resource-ref element maps the TradeDS data source to the name jdbc/TradeDB in this deployment plan.
To build the Geronimo version of the application use ant war-geronimo in your command prompt. It will create the brokerage.war under the brokerage/releases/geronimo folder.
To deploy the migrated Online Brokerage application, make sure the Geronimo server is up and running.
Open Geronimo console in your browser and follow the given steps:
Once the application is deployed, open a Web browser and access the following URL:
Login with the same user name and password you used when testing the application from JBoss.
This article has shown you how to migrate a sample application, from JBoss to the Apache Geronimo application server. You followed step-by-step instructions to build the application, deploy and run it, and then migrate it to the Geronimo environment.
The following list summarizes the major differences found during this sample application migration.