Integrated DB2 with Apache Geronimo

Introduction: Apache Geronimo is a new and popular alternative to deploying Java™2 Platform, Enterprise Edition (Java ee) applications. IBM db2® is a mature relational database product, very suitable for the Java environment. IBM Software engineer Emilio Zegarra will detail how to integrate the two products into the Java EE application.

Overview: Apache Geronimo

The Apache Geronimo project successfully built an Open-source, Java-compliant application server. The application server is very powerful and reliable, thanks to its reuse of some of the existing open source projects as part of its implementation. In a sense, the Apache Geronimo application Server is a collection of several open source projects. For example, table 1 provides a list of some open source projects that make up Apache Geronimo.

Technology	Open Source Projects
Enterprise JavaBeans (EJB) container	Open EJB
Web container	Jetty, Tomcat
Java Messaging Service (JMS) Message delivery	Active MQ
Lightweight Directory Access Protocol (LDAP)	Apache Directory

The following products are used for the development or deployment of sample applications:

Apache Geronimo Application Server, Version 1.0

IBM DB2 Universal database™, Version 8.2

Eclipse, Version 3.1 (optional)

0.7.1 version of the Eclipse Web Tools Platform plug-in project (optional)

About the sample application

The sample application used in this article is a WEB module application with a defined JavaServer Pages (JSP) that demonstrates the integration of DB2 with Apache Geronimo. The JSP (named references.jsp) queries the table that is referenced by Apache Geronimo that is available in the database, as shown in Figure 1.

Figure 1. Application Overview

When the JSP obtains data from the database, it will display this data to the requesting client in a tabular format. Before you deploy the application to the server, you must complete the database configuration. To achieve this, a database deployment plan needs to be developed. This deployment plan is then used to deploy the DB2 data source definition on the Apache Geronimo server for the application that will be used.