Creating a Java client to access the bean

Click on the "Customers" bean to highlight it and right-click, "Create sample java client".

On the next dialogue, accept the default and click "Ok" to generate the Java client.

You will now see the java file, "SampleCustomersClient.java" added to the project.

Running the sample Java client

To see the Java client in action, we must first start the EJB process. Oracle9i JDeveloper allows you to run the EJB in it's embedded OC4J server.

To start the EJB:

Click on the "Customers" bean to select it.

Select "Run Customers" from the context menu (right-click)

The embedded OC4J will startup and the EJB will be deployed.

Once the OC4J server is running you'll see the following message in the message window.

Oracle9iAS (2.0.0.0) Containers for J2EE initialized

Now run the sample java client by right-clicking and select "
Run SampleCustomersClient.java". 

You will see the java code first compile and execute. 

As the java client executes you will see data from the database table appear 
in the message window at the bottom in the following format. 
. 
. 
customer_id = 981 
cust_first_name = Daniel 
cust_last_name = Gueney 
cust_address = null 
phone_numbers = +86 10 012 3839 
nls_language = zhs 
nls_territory = CHINA 
credit_limit = 200 
cust_email = Daniel.Gueney@REDPOLL.COM 
account_mgr_id = 149 

Process exited with exit code 0

Exercise 5: Creating a JSP client to access the EJB

A JSP page can access the EJB in the same way as the sample java client. In this exercise, we will use the same code in the Java client to access the EJB but from a JSP. This exercise will use a precoded JSP sample to access this EJB.

First, create a JSP page.

In the same project as before, select File->New...{ Web Objects | JSP } to create a JSP page, "untitled1.jsp".

Now we will take an existing JSP code sample and overwrite the entire JSP page.

Highlight the ENTIRE contents of the JSP page you just created, untitled1.jsp.

Now copy the entire contents of the JSP sample: ejbjsp.jsp

and place it in the new JSP.

The entire JSP should have been replaced by the sample JSP code to access the EJB.

Save all. File-> Save All..

Run the JSP to see it access the EJB..

Right-click "untitled1.jsp" and select "Run untitled1.jsp".

This will compile the JSP and launch it in a browser window.

Note: You may have to click "Refresh" on the browser if at first you see an error message.

Also, you have to make sure that your EJB is still running.

When the JSP client accesses the EJB, you will see all of the data from the Customers table in an HTML table.

You may now shutdown the embedded OC4J server by selecting "Run->Terminate->Embedded OC4J Server".

Exercise 6: Deploying Your JSP-EJB Application to Oracle9iAS (OC4J)

Oracle9i JDeveloper has the ability to integrate an Enterprise Application Archive (EAR) containing an EJB jar file, and a Web application WAR file. In this exercise we will create a WAR f and EJB JAR archive deployments and combine them into an Enterprise Archive (EAR) deployment profile. We will then deploy the entire application (EAR) to Oracle9iAS.

Create an EJB JAR deployment profile for your EJB

In the project, select File -> New... { Deployment | J2EE EJB Module (EJB JAR File) }. Click "Ok".

Click "Save" to store your deployment profile in the default location.

In the J2EE EJB Module Deployment Profile Settings page, click "Ok" to accept the defaults.

You will see the new deployment profile, "ejb1.deploy" added to your project

Create a WAR deployment profile for your JSP application - (untitled1.jsp)

In the project, select File -> New... { Deployment | J2EE Web Module (WAR File) }. Click "Ok".

Click "Save" to store your deployment profile in the default location.

In the J2EE Web Module Deployment Profile Settings page, click "Ok" to accept the defaults.

As before, you will see the new deployment profile, "webapp1.deploy" added to your project.

Create an EAR deployment profile for your entire application

In the project, select File -> New... { Deployment | J2EE Application (EAR File) }. Click "Ok".

Click "Save" to store your deployment profile in the default location.

In the J2EE Application Deployment Profile Settings page, click on "Application Assembly" to see the list of J2EE modules available for packaging.

Click on the checkboxes for both the EJB JAR (ejb1.deploy) and Web module WAR (webapp1.deploy) to package these archives into the EAR file.

Click "Ok" to save your settings.

You will now see the Enterprise Application deployment profile, "application1.deploy" added to your project.

Save all your files: File-> Save All.

Deploying and running the Enterprise Appliction

To deploy your enterprise application, right-click on the deployment profile, "application1.deploy" and select "Deploy to -> Oracle9iAS".

After the successful completion of your deployment, you will see the following message: Deployment Finished.

Exit status of Oracle9iAS admin tool (-bindWebApp): 0

---- Deployment finished. ---- ....

To run the application from the remote server,

Point your browser to:

//localhost:8888/Workspace2-EJB_JSP-context-root/untitled1.jsp

Lab 3 - Using BC4J in JSPs

Exercise 7: Building a Business Components Middle Tier

Setup

You will create a new Workspace and Business Components Project. The business components will be based on the OrderEntry schema and will serve as the business logic for your JSP applications.

Create a new Workspace.

As before, select File->New...{ Projects | Workspace }. Click "Ok".

Accept the default name for the Workspace, "Workspace3", and leave the "Add a New Empty Project" checkbox checked and click "Ok".

In the New Project dialogue, name the new project "bc4j".

Name the directory ...mywork\Workspace3\ bc4j

Name the Project file name bc4j.jpr

This project will contain your Business Components middle tier code.

Save your new project.

Now create default Business Components for the tables: "Customers" and "Orders".

Select the new project, "bc4j.jpr" in the navigator.

Select File->New...{Business Components | Business Components} to invoke the Business Components Project Wizard. Click "Ok".

As the Wizard appears, click "Next" to advance to the next page.

Accept the default connection, "local_oe", and click "Next".

Accept the default package, "mypackage", and click "Next".

Move over the "Customers" and "Orders" tables to the "Selected:" window and select "Finish" to generate the default Business Components.

Save and compile the project.

File-> Save All.

Project -> Build bc4j.jpr

You now have generated a middle tier set of Java classes which can communicate with the database.

Optional - Run the BC4J tester

To see the your newly created Business Components in action you can run the BC4J tester.

Open the mypackage package node on the navigator, and right-click on the MypackageModule node and select "Test..."

As the Tester appears click "Connect" to test your business components.

Now double-click on the nodes on the left tree to view data in the business components.

To close the tester, simply close the tester window by selecting "x" in the upper right corner..

Exercise 8: Creating a Simple BC4J DataBound JSP

In this exercise we will create a new project with a single JSP page which displays data from a Business Component (View Object). We will also observe some of the new JSP editing features such as JSP Insight and the JSP/HTML structure pane.

Create a JSPclient project

Create a New Project and name it "jsps"

File -> New... { Projects | Empty Project }. Click "Ok".

Name the directory ...mywork\Workspace3\ jsps

Name the Project file name jsps.jpr

This project will contain your BC4J JSP pages.

Create a JSP

Invoke the "New.." gallery again. File->New...{ Web Objects | JSP }. Click "Ok".

Accept the default JSP filename, "untitled1.jsp". Click "Ok".

The JSP page will automatically be opened in the editor and the Component Palette will also be turned on.

For easier usage of the Component Palette, place the palette in a vertical fashion and dock it to the right side of the IDE.

Select File-> Save All or to save the new project and JSP file.

Adding DataBinding to the JSP

We will now add code to display data from the Business Components we created earlier. This is done by inserting BC4J Data Tags into the JSP page using the Component Palette

To add BC4J Data Tags into the palette, the Component Palette must be turned on. (From the Menu, View->Component Palette. )

In the Component Palette page selector, select the "BC4J Connections" option. (Should be the default.)

Now place the cursor in the JSP file above the closing "" tags and enter a few carriage returns. This is where we will insert some BC4J JSP Data tags.

Connecting a JSP to a BC4J Application Module and View Object

Insert an "Application Module" tag by clicking on it on the Component Palette.

This will bring up a dialogue which allows for selection of BC4J application module information.

Accept all the defaults and click "Next".

Accept the remaining defaults and select "Finish" to insert the "ApplicationModule" tag onto the page.

By doing this we are identifying a BC4J Application Module to the Page. Our next step is to identify a Datasource (a ViewObject) to the JSP page.

To add a BC4J datasource (ViewObject) to the JSP page, place the cursor beneath the "ApplicationModule" tag in the JSP page and click on the "DataSource" tag on the Component Palette.

This will invoke a dialogue which allows us to specify a BC4J View Object to the page.

Once the dialogue appears, select the "CustomersView" View Object in the tree and select "Next".

On the next page, enter the following attribute value:

Id = customers

Leave the remaining attributes, blank and click "Finish".

Select File-> Save All.

The JSP page will now have access to Customer View Object's data when run. Now we must insert tags to show the data.

Displaying BC4J Data in a JSP

In order to display the View Object's data we will use 2 other tags: "RowsetIterate", to iterate through all of the records of the View Object, and "ShowValue" to display a specific column value.

On the Component Palette, change the Palette page from "BC4J Connections" to "BC4J Data Access" using the poplist.

In the JSP file, place the cursor beneath the appmodule and datasource tags and click on the tag: "RowsetIterate" in the Component Palette.

As the Tag dialogue appears, select "customers" as the datasource and click "Finish". This will insert the following code:

Place your cursor before the closing and insert a few carrage returns. Like this:

Insert an HTML line break "
" in the area between the RowsetIterate begin and end tags and then insert a "ShowValue" tag from the Component Palette.

The "ShowValue" tag dialogue will appear. Enter the following attribute values:

datasource = customers
dataitem = CustFirstName 

Note: Use the poplist on the right to select from a list of values.

Select "Finish" to dismiss the dialogue and insert the tag. The JSP page should now have the following code inserted.

Save the file as before, File -> Save All.

To run the JSP, right-click on the untitled1.jsp node in the navigator and select "Run untitled1.jsp".

You will first see the embedded OC4J process initializing itself in the message window.

When the browser appears, you should see a complete list of the customers from the database. ...

Constantin
Harrison
Manisha 
Harrison 
Matthias 

. 
. 

Exercise 9: Generating a Complete BC4J JSP

Oracle9i JDeveloper also provides a quick, productive way to generate fully functional data enabled JSP pages. The generated pages include preconfigured BC4J Data Tags which we just worked with.

The page generation options include the basic types database operation such as Browsing, Editing, Inserting and Querying of data.

You will now create a new set of JSP pages which perform complete browse and edit capabilities.

In the same project as before, "jsps.jpr" , create a "Browse and Edit" JSP application by clicking on: File->New...{ BC4J JSP | Browse and Edit. }. Click "Ok".

As the dialogue appears, click "Next" to progress to the View Object selection panel.

Select the "CustomersView" View Object and accept the other defaults. Click "Finish".

You should now see a new set of JSPs added to the project. These are Component Tags which render user-interface controls such as tables, forms etc.

Save all the files: File-> Save All.

Compile the "jsps.jpr" project: Project-> Build jsps.jpr.

Note: Ignore any warnings..

Run the JSP application by right-clicking the file "CustomersView_BrowseEdit.jsp" in the navigator and select: "Run CustomersView_BrowseEdit.jsp".

As the application starts up, you will be presented with a complete data enabled JSP application which allows for Browsing and editing of data from a single View Object (database table).

Shutting down...

Once finished viewing the application, shutdown the application by selecting: Run->Terminate Embedded OC4J Server... from the menu.

Exercise 10: Deploying your BC4J JSP application to Oracle9iAS (OC4J)

Deploying BC4J JSP applications to Oracle9iAS has become very easy with the new OC4J container. To deploy a BC4J JSP application to OC4J, you simply have to click on the deployment profile which has been pre-created for you and then deploy your application.

For this task we will deploy the "Browse and Edit" JSP application to your external OC4J server.

Deploying a BC4J JSP Application

Deploying a BC4J JSP application is simply a matter of invoking a prebuilt deployment profile which was created when you created your application, "jsps_jpr_War.deploy".

Before we deploy let's examine the Deployment Profile by right-clicking on the deployment profile, "jsps_jpr_War.deploy", and select "Settings..".

Notice the following:

WAR File: (location) - This is where a temporary WAR file is generated on the file system when a deployment occurs.

EAR File: (location) - This WAR file gets packaged into this EAR file before being sent to the application server.

Observe the other settings without changing anything and dismiss the dialogue by selecting "Cancel".

Now deploy the application by right clicking on the deployment profile and select: Deploy To -> "Oracle9iAS"

After the deployment successfully completes, you should be able to access the deployed JSP application at:

//localhost:8888/Workspace3-jsps-context-root/CustomersView_BrowseEdit.jsp

This concludes the J2EE Web Development Tutorial