Arun Gupta, Miles to go ...

Arun Gupta is a technology enthusiast, a passionate runner, and a community guy who works for Sun Microsystems.

« Previous day (Sep 30, 2009) | Main | Next day (Oct 2, 2009) »

Thursday October 01, 2009

TOTD #108: Java EE 6 web application (JSF 2.0 + JPA 2.0 + EJB 3.1) using Oracle, NetBeans, and GlassFish

TOTD #106 explained how to install Oracle database 10g R2 on Mac OS X. TOTD #107 explained how to connect this Oracle database using NetBeans. This Tip Of The Day will explain how to use the sample HR database (that comes with Oracle database server) to write a simple Java EE 6 application.

This application will use Java Server Faces 2.0 for displaying the results, Enterprise Java Beans 3.1 + Java Persistence API 2.0 for middle tier, and Oracle database server + GlassFish v3 as the backend. The latest promoted build (65 of this writing) will not work because of the issue #9885 so this blog will use build 63 instead.

Several improvements have been made over NetBeans 6.8 M1 build and this blog is using the nightly build of 9/27. The environment used in this blog is:

NetBeans 9/27 nightly
GlassFish v3 build 63
Oracle database server 10.2.0.4.0 R2 on Mac OS X
Oracle JDBC Driver type 4 (ojdbc6.jar)

Lets get started!

Configure GlassFish v3 with JDBC connection

Download and unzip build 63.
Download ojdbc6.jar and copy to "glassfishv3/glassfish/domains/domain1/lib/ext" directory.
Start the Application Server as:
```
./bin/asadmin start-domain --verbose &
```

Create a JDBC connection pool as:

./bin/asadmin create-jdbc-connection-pool --datasourceclassname oracle.jdbc.pool.OracleDataSource --restype javax.sql.DataSource --property "User=hr:Password=hr:URL=jdbc\:oracle\:thin\:@localhost\:1521\:orcl" jdbc/hr

and verify the connection pool as:

./bin/asadmin ping-connection-pool jdbc/hr

Create a JDBC resource as:

./bin/asadmin create-jdbc-resource --connectionpoolid jdbc/hr jdbc/hr

Configure GlassFish v3 build 63 in NetBeans
1. In NetBeans IDE "Services" panel, right-click on "Servers" and click on "Add Server...". Choose "GlassFish v3" and provide a name as shown below:
2. Click on "Next >" and specify the unzipped GlassFish location as:
  
  and click on "Finish".
Create the Java EE 6 application
1. In "Projects" pane, right-click and select "New Project...".
2. Choose "Java Web" and "Web Application" and click on "Next". Choose the project name as "HelloOracle":
  
  and click on "Next >".
3. Select the recently added GlassFish v3 server and choose "Java EE 6 Web" profile:
  
  and click on "Next >". Notice "Java EE 6 Web" profile is chosen as the Java EE version.
4. Select "JavaServer Faces" on the frameworks page:
  
  and click on "Finish". Notice the JSF libraries bundled with the App Server are used.
Create the Java Persistence Unit
1. Right-click on the project, select "New", "Entity Classes from Database...":
2. From the Data Source, select "jdbc/hr" as shown:
  
  This is the same JDBC resource created earlier. Select "EMPLOYEES" from the Available Table, click on "Add >" to see the output as:
  
  The related tables are automatically included. Click on "Next >".
3. Click on "Create Persistence Unit ..." and take all the defaults and click on "Create".
4. Specify the package name as "model":
  
  and click on "Finish". This generates a JPA-compliant POJO class that provide access to tables in the underlying Oracle database. The class name corresponding to each table is shown in the wizard.
Create Enterprise Java Beans
1. Right-click on the project and select "New Class...".
2. Specify the class name as "EmployeesBean" and package as "controller", click on "Finish".
3. Annotate the class to make it an Enterprise Java Bean and a JSF Managed Bean as:
```
@javax.ejb.Stateless
@javax.faces.bean.ManagedBean
```
  Notice, the EJB is bundled in the WAR file and no special type of modules are required. Java EE 6 provides simplified packaging of EJB which makes it really ease to use.
  
  Also this application is currently using JSF managed bean but will use JSR 299 (aka Web Beans) in a future blog.
4. Inject the Persistence Unit by adding the following variable:
```
@PersistenceUnit
EntityManagerFactory emf;
```
5. Add a new method to retrieve the list of all employees as:
```
public List getEmployees() {
 return em.createNamedQuery("Employees.findAll").getResultList();
}
```
  "Employees.findAll" is a default NamedQuery generated by NetBeans and makes it easy to query the database. Several other queries are generated for each mapped JPA class, such as "Employees.findByEmployeeId" and "Employees.findByFirstName". Custom queries can also be created and specified on the POJO class.
  
  The completed class looks like:
```
@Stateless
@ManagedBean
public class EmployeesBean {

 @PersistenceContext
 EntityManager em;

 public List getEmployees() {
 return em.createNamedQuery("Employees.findAll").getResultList();
 }
}
```
Use EJB in the generated JSF page
1. JSF 2 uses Facelets as the templating mechanism and NetBeans generate a simple "index.xhtml" file to start with. Expand "Web Pages" and open "index.xhtml".
2. Replace the body template with:
```
<h1>First Java EE 6 app using Oracle database</>
<h:dataTable var="emp" value="#{employeesBean.employees}" border="1">
 <h:column><h:outputText value="#{emp.lastName}"/>, <h:outputText value="#{emp.firstName}"/></h:column>
 <h:column><h:outputText value="#{emp.email}"/></h:column>
 <h:column><h:outputText value="#{emp.hireDate}"/></h:column>
 </h:dataTable>
```
  It uses JSF value expressions to bind the Enterprise Java Bean and dumps the HTML formatted name, email, and hire date of each employee in the database.
Run the project: Right-click on the project and select "Run" to see the output at "http://localhost:8080/HelloOracle/" as:

So we can easily create a Java EE 6 application using NetBeans, Oracle, and GlassFish.

A complete archive of all the TOTDs is available here.

This and other similar applications will be demonstrated at the upcoming Oracle Open World.

Technorati: totd oracle database glassfish v3 javaee javaserverfaces ejb jpa netbeans oow

Posted by Arun Gupta in General | Comments[0]

|
|

Running Summary Q3 2009 – 400 miles, 80% of running days

Here is the summary of my running logs from Q3 2009 (Jul - Sep):

Even though 3 days of less running than Q2, but the overall mileage was increased. Barely hit that 400 miles mark in Q3 and it did took some extra efforts to reach there ;-) But now tapering for the upcoming Rock-n-Roll 1/2 Marathon this weekend.