Regina M. King

Winter Term 06 - CIS444

A reading of the glossary of Oracle 9i Databae Administrator II
by Lannes L. Morris-Murphy, PhD to prepare for Oracle certification exam
#1ZO-032

 

 

 

 

CIS435

Midterm Exam

10/29/05

1. Oracle JDeveloper Introduction

Developer Quick Tour

The Oracle JDeveloper Introduction demonstrates a complete Integrated Development Environment that uses multiple platforms and offers productivity choices. It lists the various uses as: coding, modeling, deployment, testing, versioning, debugging and tuning. The JDeveloper uses a J2EE framework for Rapid Application Development. JDeveloper allows the developer to choose and display objects within the schema to create user interfaces, business services, testing and profiling.

JDeveloper’s application workspaces are customized or tailored to meet the needs of the user. The JDeveloper will generate code and produce views that will display data from multiple tables. The JDeveloper uses various tool such as the data component pallet, and the property inspector to add objects such as views and to create associations and data flows among them. Add the objects to the pallet using the database connection navigator. JDeveloper uses wizards for various steps in creating an application. For example, when you go to the database connection, expand the database and select a few tables, JDeveloper asks what you will do with those tables and then take you through steps to create that project.

ADF Quick Tour

In the Oracle ADF (Application Development Framework) tour, to create an application, go to the Application Navigator and right click on Applications. Give it a name and choose an application template. You can write and edit your templates as well but the system templates offer a choice of: no template (all technologies), web application default, web application default – no controller, web app with JSP, STRUTS, EJB, web app with JSP, EJB, Java App with default or Java App with Java, Swing. The developer makes the choice of what best suits the application needs. Each template has various associated technologies and you can select them under the manage templates button.

The ADF tour demonstrates a Struts configuration that uses the component pallet and the property inspector. It inserts two data pages and associates data action to handle data binding events. Click and drag the pages, select or create a page and choose the language – HTML, JSP, etc. To insert contents open the data control pallet and expand it. Then select an object and expand that to display the data fields, choose an association. The example chooses the master detail so the end result is that one record from the displays the many associated with it when you click the run icon. For example, it can list a department as the master and the details would be the employees within that department.

The introduction shows us some of the ways that JDeveloper can be used to create web based applications that can be assembled in one place to create user interfaces that will display, read and manipulate data using various platforms such as Windows, Linux, or Unix and others that support am SQL 92 Database.

2. J2EE Applications

ADF Overview

Creates a new application with web application default template. It creates a view and controller template and selects from the available technologies. Then it creates a Model project, names it and chooses the web application default template. Right click on Model to create a new project using project technologies by selecting Business Tier/Business Components/Business Components Diagram and name it. It is displayed in the Applications Navigator. Go to the connections navigator, find the database, display and choose the tables you want to use here. Pick all technologies and business component entity objects. It will create a diagram, right click, generate data model components. Work through the wizard and give it a name. After the data model is done, create the view controller project by creating a struts-config.xml that is summarized in more detail under other topics in this exam. Briefly, though, edit the stuts-config.xml, create a data page, drop and drag from the component pallet, and follow all the steps listed under web services as appropriate. The end result is a master detail application that when run displays the department master and lists all employees as detail

Model: Web Services

This demonstration creates a data control from a web service and uses it in a Struts controlled JSP application. There is a live connection with a number of web services displayed in the connection navigator. Open the service to see the source code. The web service structure is visible beneath the connection navigator and the operation there says “hello.” The source code shows that the parameter is a string. To create a new data control for the web service, use its context menu by selecting it, right clicking and choosing “Create Data Control,” and it will generate the required files, displayed in the data control pallet. It can be used in a struts page by opening the components pallet, selecting the struts flow page. Drag and drop it on the struts config.xml to create a jsp to capture some data in the form. Click on it to create the underlying jsp form and insert a data page that is bound to a struts action. The property inspector opens and click on the .jsp setup at the top and edit it to include an HTML form that is aware of the strut’s actions. Choose an action from the tag editor, (greeting.do). Add a text field and add properties using the property inspector and it should be named to agree with the Struts action (pname). Add a button to submit it with a get greeting value (under the property inspector). Make any other appropriate settings. Right click on the setup.jsp and select “Set as default Run Target.” Right click and “Refresh the diagram from page.” A broken line is drawn between the setup.jsp towards (arrow pointing to) the greeting. No add the sayHello operation to the /greeting action by selecting sayHello from the Data Component pallet and drag and drop it as a method on the action – select method from the drop down. View the structure pane to see how the /greeting action mapping of sayHello data control. The property inspector shows there is one parameter and write an expression for the value and double click on the greeting action to create a page to define the page that is bound to the action. Drag the return from under the sayHello operation on the data component pallet and drop it after selecting result from the drop down. Add some text and headings, etc.. Open the components pallet, choose HTML/ CSS and click on JDeveloper. Click the run icon, and test the new control

Model: Enterprise JavaBeans Development

Create a new application workspace. Name it and choose the web applications [JSP, Struts, EJB] to create a data bound web application. There will be two projects one for view and controller and the other for the data model. Right click on the model and choose Enterprise JavaBeans under Business Tier and then select EJB Diagram. Name the new diagram, press okay and see the property inspector, the application diagram and the component pallet displayed. Model session beans and forward or reverse engineer database tables as container managed persistence (CMP) or create container managed relationships (CMR) here. Go to the connections navigator, select the tables, drag and drop and the wizard will appear. Select EJB 2.0 entity beans from the list and project technologies from the drop down. The diagram is created and the new entity beans are visible in the applications navigator. Select EJB from the component pallet drop down, create a session bean, name it and follow through the wizard. The session bean is now on the diagram, and the reference to the bean is displayed on the diagram. It can be found by the Application Navigator under Meta-Inf and is listed in the Application Structure. Select the entity bean in the diagram, right click and choose, generate, data object. Now java classes is added to the diagram. You can edit relationships here. Double click on the entity bean to view methods and relationships, etc. Finally, you can verify the bean

Model: TopLink

First create a Java class diagram under the HR application Model. Right click, select General/Diagram, Java Class diagram and name. Go to connections, open the database, select tables from the schema, drag and drop, select Java classes from the project filtered list and the tables are added to the diagram. Both classes are added to the application navigator. Expand Top Link Mappings in the Structure pallet and it will create descriptions for each of the pallets. Use the TopLink Mapping editor to configure deployment and sequencing information. Use the defaults tab to configure other run time defaults. Display information about descriptors when they are selected and it will provide a mapping report under the Applications Navigator. Right click on the TopLink mappings to generate a report that will compile the source, verify the mappings, and report errors.

ADF Business Components

This examples begins with a demonstration of how to connect to a database using the wizard. Then it demonstrates how to select tables from the schema to add to the HR Diagram. It asks what the tables will be used for and in this case they are used as Business Component Entity objects filtered by All Technologies (the other choice is Project Technologies). The components pallet is opened. The diagram displays the tables, data field names, and associations between tables. It shows an opened Entity Object Editor to create a validation rule as we did using another method in lab 3 or 4. The demonstration shows how to create the salary range by selecting a “compareValidator” from the drop down, choosing the attribute and maximum value and then adding an error message. Right click to generate default model components for diagram. A two step wizard opens and they select EmployeesView, give it a name and click finish, etc. Now it is listed in the Applicatons Navigator. Use the View object editor to view the attributes, arrange the display order and format. Then select edit app module and test the views. There is some unvalidated data due to the created rule.

Controller: Struts

This is an overview of the Apache Struts Page Flow Editor. Go to the application

and select the view controller. Right click to open the struts editor. It displays the zoom in and out and the source code. Use the property inspector you see what the page does. The structure pane displays an alternative view. Right click on Struts Config to add a new page. Add a new action from the component pallet and name it checkout. Click on the forward component and then double click on the action then logout as shown, define the action and go to the form bean. Create the checkout action and follow through with the wizard. This shows you can add or delete actions from the diagram.

View: JSP

This creates a web service. Select model, go to the connections navigator, open the UDDI Registry/Xmethods/Services/method. Right click on the desired method and generate web service …. Check the Applications navigator under Model. Expand it to view new services and then check the source code under the structure. Select the ViewController, open the struts diagram and create a struts-config diagram as elsewhere in this exam. Create the actions and associations, add headings and the JDEveloper, create the input form and display the return as described under Web services.

View: Swing – ADF JClient

This demonstration creates an input form under View/Client Tier/SwingClient for ADF and choose empty form to open a wizard. Name it and follow through to finish. Drag and drop attributes from the data component pallet and format with the property inspector, etc. Create a form somewhat as in Access but more complicated. Add components from the swing component pallet. This demonstration shows how to add a graph by using a wizard. Test the form and display the data.

View: ADF UIX

This demonstration builds a view based on ADF UIX Technology.

3. XML Development

Visual XML Schema Editor

This lesson displays Schema101 located in the XML Schema application. Add files by following the path to the schema. This is a web content schema. The Structure, component and property inspector pallets are open. Elements and processes are listed. Elements and processes can be added. Properties can be changed. Basically everything that goes on in the web application is charted here.

XML Schema Registration and XML Editor

This lesson displays an XML schema of library books and creates a new project under the schema projects as Instances. It sets preferences under the tools menu to add a schema and browses to library.xsd. Then it creates a new workspace under instances – General/XML/XML Document. It names it, creates and validates the source code.

4. UML Modeling and Generation

UML Class Modeling

This lesson demonstrates the step by step creation of a UML Class Model. Create the workspace/General/UML Class Diagram and name it. They give it a new package name, analysis. They add UML interfaces and classes to the diagram and create associations using the component pallet. They add attributes and methods to the interfaces and format them. They transform it to a Java Class diagram and insert a link, generate the documentation and view it using internet explorer.

UML Use Case Modeling

UML Use Case Modeling creates a visual diagram, add requirement details to HTML and publish in JavaDoc. Create a new application workspace/General/Diagrams/UML Use Case Diagram and names it. Add actors and use case to the diagram from the component pallet. Create communication between actors and use cases. Add documentation to the components. Add links, format the components and add notes. Process the documentation and view it.

UML Activity Modeler

This lesson shows how swim lanes are created and how activities, objects, initiation point, and decisions are added to the diagram. It demonstrates the program flow by using the arrow tool to draw lines between components and decision points where the lines will be drawn to more than one activity. It sets transition properties and guard events

Java Class Modeling

Create application workspace and the Java class Diagram. Click and drag the search google application source, right click and drill down to display the Java classes. This demonstration shows how to format the diagram and you can add methods to the classes. Change Class names and they will be where ever applicable. You can display more than one package.

Database Schema Modeler

Create a new diagram using the context menu of the Project. Create a database diagram and name it. Go to the connections navigator, select the database and tables and work offline. Use the wizard to generate SQL. Set properties and alter tables.

5. Complete J2EE Applications

Struts/JSP Application

This is a web based application that requests that

a user log in. A struts diagram is used to create the log in page and bind data to the actions. A detailed sequence of a struts diagram is shown above. If the login fails the user will try again.

Oracle ADF Business Components Based Application – Business Services Layer

This creates a database connection, creates a business components diagram, add tables and validation rules to display a one to many, Department to Employee list. Some of the data is invalid due to the salary range rule.

Oracle ADF Business Components Based Application – View Controller Layer (Struts-JSP)

This application displays a master to detail relationship between department and department employees but it different because there are button controls to move among the departments.

Oracle ADF Business Components Based Application – View Layer (UIX)

This application displays all the departments and uses radio buttons to display the detail. It is a master detail application and uses struts and JSP.

EJB Based Application (EJB-Struts-JSP)

This is a complicated web based application that uses struts, beans and a JSP page to display department id, department name and department location. All the steps were described in greater detail above.

Web Services Based Application (Web Services-Stuts-JSP)

This creates a web service using struts technology and a JSP page, it adds headers, etc and uses the JDEveloper to request input. HTML components are used. The web service was described above. This application returns the value of the stock.

6. Generating Oracle ADF Business Components form Oracle Designer

Reviews a basic Designer mode

Reviews the generated output

The reviews the generated output. It shows the designer module, the entity object and its attributes in the structure that also shows the validation rules.

Making changes in Designer and regenerating

Can edit and make changes and then regenerate

Reviews the generated output after the changes.

Review after changes

CIS435

Midterm Exam

10/29/05

1. Oracle JDeveloper Introduction

Developer Quick Tour

The Oracle JDeveloper Introduction demonstrates a complete Integrated Development Environment that uses multiple platforms and offers productivity choices. It lists the various uses as: coding, modeling, deployment, testing, versioning, debugging and tuning. The JDeveloper uses a J2EE framework for Rapid Application Development. JDeveloper allows the developer to choose and display objects within the schema to create user interfaces, business services, testing and profiling.

JDeveloper’s application workspaces are customized or tailored to meet the needs of the user. The JDeveloper will generate code and produce views that will display data from multiple tables. The JDeveloper uses various tool such as the data component pallet, and the property inspector to add objects such as views and to create associations and data flows among them. Add the objects to the pallet using the database connection navigator. JDeveloper uses wizards for various steps in creating an application. For example, when you go to the database connection, expand the database and select a few tables, JDeveloper asks what you will do with those tables and then take you through steps to create that project.

ADF Quick Tour

In the Oracle ADF (Application Development Framework) tour, to create an application, go to the Application Navigator and right click on Applications. Give it a name and choose an application template. You can write and edit your templates as well but the system templates offer a choice of: no template (all technologies), web application default, web application default – no controller, web app with JSP, STRUTS, EJB, web app with JSP, EJB, Java App with default or Java App with Java, Swing. The developer makes the choice of what best suits the application needs. Each template has various associated technologies and you can select them under the manage templates button.

The ADF tour demonstrates a Struts configuration that uses the component pallet and the property inspector. It inserts two data pages and associates data action to handle data binding events. Click and drag the pages, select or create a page and choose the language – HTML, JSP, etc. To insert contents open the data control pallet and expand it. Then select an object and expand that to display the data fields, choose an association. The example chooses the master detail so the end result is that one record from the displays the many associated with it when you click the run icon. For example, it can list a department as the master and the details would be the employees within that department.

The introduction shows us some of the ways that JDeveloper can be used to create web based applications that can be assembled in one place to create user interfaces that will display, read and manipulate data using various platforms such as Windows, Linux, or Unix and others that support am SQL 92 Database.

2. J2EE Applications

ADF Overview

Creates a new application with web application default template. It creates a view and controller template and selects from the available technologies. Then it creates a Model project, names it and chooses the web application default template. Right click on Model to create a new project using project technologies by selecting Business Tier/Business Components/Business Components Diagram and name it. It is displayed in the Applications Navigator. Go to the connections navigator, find the database, display and choose the tables you want to use here. Pick all technologies and business component entity objects. It will create a diagram, right click, generate data model components. Work through the wizard and give it a name. After the data model is done, create the view controller project by creating a struts-config.xml that is summarized in more detail under other topics in this exam. Briefly, though, edit the stuts-config.xml, create a data page, drop and drag from the component pallet, and follow all the steps listed under web services as appropriate. The end result is a master detail application that when run displays the department master and lists all employees as detail

Model: Web Services

This demonstration creates a data control from a web service and uses it in a Struts controlled JSP application. There is a live connection with a number of web services displayed in the connection navigator. Open the service to see the source code. The web service structure is visible beneath the connection navigator and the operation there says “hello.” The source code shows that the parameter is a string. To create a new data control for the web service, use its context menu by selecting it, right clicking and choosing “Create Data Control,” and it will generate the required files, displayed in the data control pallet. It can be used in a struts page by opening the components pallet, selecting the struts flow page. Drag and drop it on the struts config.xml to create a jsp to capture some data in the form. Click on it to create the underlying jsp form and insert a data page that is bound to a struts action. The property inspector opens and click on the .jsp setup at the top and edit it to include an HTML form that is aware of the strut’s actions. Choose an action from the tag editor, (greeting.do). Add a text field and add properties using the property inspector and it should be named to agree with the Struts action (pname). Add a button to submit it with a get greeting value (under the property inspector). Make any other appropriate settings. Right click on the setup.jsp and select “Set as default Run Target.” Right click and “Refresh the diagram from page.” A broken line is drawn between the setup.jsp towards (arrow pointing to) the greeting. No add the sayHello operation to the /greeting action by selecting sayHello from the Data Component pallet and drag and drop it as a method on the action – select method from the drop down. View the structure pane to see how the /greeting action mapping of sayHello data control. The property inspector shows there is one parameter and write an expression for the value and double click on the greeting action to create a page to define the page that is bound to the action. Drag the return from under the sayHello operation on the data component pallet and drop it after selecting result from the drop down. Add some text and headings, etc.. Open the components pallet, choose HTML/ CSS and click on JDeveloper. Click the run icon, and test the new control

Model: Enterprise JavaBeans Development

Create a new application workspace. Name it and choose the web applications [JSP, Struts, EJB] to create a data bound web application. There will be two projects one for view and controller and the other for the data model. Right click on the model and choose Enterprise JavaBeans under Business Tier and then select EJB Diagram. Name the new diagram, press okay and see the property inspector, the application diagram and the component pallet displayed. Model session beans and forward or reverse engineer database tables as container managed persistence (CMP) or create container managed relationships (CMR) here. Go to the connections navigator, select the tables, drag and drop and the wizard will appear. Select EJB 2.0 entity beans from the list and project technologies from the drop down. The diagram is created and the new entity beans are visible in the applications navigator. Select EJB from the component pallet drop down, create a session bean, name it and follow through the wizard. The session bean is now on the diagram, and the reference to the bean is displayed on the diagram. It can be found by the Application Navigator under Meta-Inf and is listed in the Application Structure. Select the entity bean in the diagram, right click and choose, generate, data object. Now java classes is added to the diagram. You can edit relationships here. Double click on the entity bean to view methods and relationships, etc. Finally, you can verify the bean

Model: TopLink

First create a Java class diagram under the HR application Model. Right click, select General/Diagram, Java Class diagram and name. Go to connections, open the database, select tables from the schema, drag and drop, select Java classes from the project filtered list and the tables are added to the diagram. Both classes are added to the application navigator. Expand Top Link Mappings in the Structure pallet and it will create descriptions for each of the pallets. Use the TopLink Mapping editor to configure deployment and sequencing information. Use the defaults tab to configure other run time defaults. Display information about descriptors when they are selected and it will provide a mapping report under the Applications Navigator. Right click on the TopLink mappings to generate a report that will compile the source, verify the mappings, and report errors.

ADF Business Components

This examples begins with a demonstration of how to connect to a database using the wizard. Then it demonstrates how to select tables from the schema to add to the HR Diagram. It asks what the tables will be used for and in this case they are used as Business Component Entity objects filtered by All Technologies (the other choice is Project Technologies). The components pallet is opened. The diagram displays the tables, data field names, and associations between tables. It shows an opened Entity Object Editor to create a validation rule as we did using another method in lab 3 or 4. The demonstration shows how to create the salary range by selecting a “compareValidator” from the drop down, choosing the attribute and maximum value and then adding an error message. Right click to generate default model components for diagram. A two step wizard opens and they select EmployeesView, give it a name and click finish, etc. Now it is listed in the Applicatons Navigator. Use the View object editor to view the attributes, arrange the display order and format. Then select edit app module and test the views. There is some unvalidated data due to the created rule.

Controller: Struts

This is an overview of the Apache Struts Page Flow Editor. Go to the application

and select the view controller. Right click to open the struts editor. It displays the zoom in and out and the source code. Use the property inspector you see what the page does. The structure pane displays an alternative view. Right click on Struts Config to add a new page. Add a new action from the component pallet and name it checkout. Click on the forward component and then double click on the action then logout as shown, define the action and go to the form bean. Create the checkout action and follow through with the wizard. This shows you can add or delete actions from the diagram.

View: JSP

This creates a web service. Select model, go to the connections navigator, open the UDDI Registry/Xmethods/Services/method. Right click on the desired method and generate web service …. Check the Applications navigator under Model. Expand it to view new services and then check the source code under the structure. Select the ViewController, open the struts diagram and create a struts-config diagram as elsewhere in this exam. Create the actions and associations, add headings and the JDEveloper, create the input form and display the return as described under Web services.

View: Swing – ADF JClient

This demonstration creates an input form under View/Client Tier/SwingClient for ADF and choose empty form to open a wizard. Name it and follow through to finish. Drag and drop attributes from the data component pallet and format with the property inspector, etc. Create a form somewhat as in Access but more complicated. Add components from the swing component pallet. This demonstration shows how to add a graph by using a wizard. Test the form and display the data.

View: ADF UIX

This demonstration builds a view based on ADF UIX Technology.

3. XML Development

Visual XML Schema Editor

This lesson displays Schema101 located in the XML Schema application. Add files by following the path to the schema. This is a web content schema. The Structure, component and property inspector pallets are open. Elements and processes are listed. Elements and processes can be added. Properties can be changed. Basically everything that goes on in the web application is charted here.

XML Schema Registration and XML Editor

This lesson displays an XML schema of library books and creates a new project under the schema projects as Instances. It sets preferences under the tools menu to add a schema and browses to library.xsd. Then it creates a new workspace under instances – General/XML/XML Document. It names it, creates and validates the source code.

4. UML Modeling and Generation

UML Class Modeling

This lesson demonstrates the step by step creation of a UML Class Model. Create the workspace/General/UML Class Diagram and name it. They give it a new package name, analysis. They add UML interfaces and classes to the diagram and create associations using the component pallet. They add attributes and methods to the interfaces and format them. They transform it to a Java Class diagram and insert a link, generate the documentation and view it using internet explorer.

UML Use Case Modeling

UML Use Case Modeling creates a visual diagram, add requirement details to HTML and publish in JavaDoc. Create a new application workspace/General/Diagrams/UML Use Case Diagram and names it. Add actors and use case to the diagram from the component pallet. Create communication between actors and use cases. Add documentation to the components. Add links, format the components and add notes. Process the documentation and view it.

UML Activity Modeler

This lesson shows how swim lanes are created and how activities, objects, initiation point, and decisions are added to the diagram. It demonstrates the program flow by using the arrow tool to draw lines between components and decision points where the lines will be drawn to more than one activity. It sets transition properties and guard events

Java Class Modeling

Create application workspace and the Java class Diagram. Click and drag the search google application source, right click and drill down to display the Java classes. This demonstration shows how to format the diagram and you can add methods to the classes. Change Class names and they will be where ever applicable. You can display more than one package.

Database Schema Modeler

Create a new diagram using the context menu of the Project. Create a database diagram and name it. Go to the connections navigator, select the database and tables and work offline. Use the wizard to generate SQL. Set properties and alter tables.

5. Complete J2EE Applications

Struts/JSP Application

This is a web based application that requests that

a user log in. A struts diagram is used to create the log in page and bind data to the actions. A detailed sequence of a struts diagram is shown above. If the login fails the user will try again.

Oracle ADF Business Components Based Application – Business Services Layer

This creates a database connection, creates a business components diagram, add tables and validation rules to display a one to many, Department to Employee list. Some of the data is invalid due to the salary range rule.

Oracle ADF Business Components Based Application – View Controller Layer (Struts-JSP)

This application displays a master to detail relationship between department and department employees but it different because there are button controls to move among the departments.

Oracle ADF Business Components Based Application – View Layer (UIX)

This application displays all the departments and uses radio buttons to display the detail. It is a master detail application and uses struts and JSP.

EJB Based Application (EJB-Struts-JSP)

This is a complicated web based application that uses struts, beans and a JSP page to display department id, department name and department location. All the steps were described in greater detail above.

Web Services Based Application (Web Services-Stuts-JSP)

This creates a web service using struts technology and a JSP page, it adds headers, etc and uses the JDEveloper to request input. HTML components are used. The web service was described above. This application returns the value of the stock.

6. Generating Oracle ADF Business Components form Oracle Designer

Reviews a basic Designer mode

Reviews the generated output

The reviews the generated output. It shows the designer module, the entity object and its attributes in the structure that also shows the validation rules.

Making changes in Designer and regenerating

Can edit and make changes and then regenerate

Reviews the generated output after the changes.

Review after changes