Running a Forms Developer Application

quicksandwalleyeInternet and Web Development

Oct 31, 2013 (3 years and 8 months ago)

95 views

Copyright © 2006, Oracle. All rights reserved.

Running a Forms

Developer Application

2
-
2

Copyright © 2006, Oracle. All rights reserved.

Objectives

After completing this lesson, you should be able to do
the following:


Start OC4J


Describe the run
-
time environment


Describe the elements in a running form


Navigate a Forms application


Describe the two main modes of operation


Run a form in a Web browser


Retrieve both restricted and unrestricted data


Insert, update, and delete records


Display database errors

2
-
3

Copyright © 2006, Oracle. All rights reserved.

Testing a Form: OC4J Overview

Oracle Application Server Containers for J2EE (OC4J)
is:


Preferred to run Forms applications


Included with Oracle Developer Suite to enable
testing

2
-
4

Copyright © 2006, Oracle. All rights reserved.

Testing a Form: Starting OC4J


On NT, run batch file to start

OC4J:
startinst.bat
.


OC4J starts in DOS window:


Minimize window.


Closing window aborts OC4J.


Run batch file to stop OC4J:
stopinst.bat
.

2
-
5

Copyright © 2006, Oracle. All rights reserved.

Running a Form

Oracle Forms Services deployment:

Browser URL

Java applet

2
-
6

Copyright © 2006, Oracle. All rights reserved.

Running a Form: Browser

http://summit.com:8889/forms/frmservlet

?form=d
<formname>
.fmx

&userid=
<username>
/
<password>
@
<database>

&buffer_records=NO&debug_messages=NO&array=YES

&query_only=NO

http://summit.com:8889/forms/frmservlet?form=customers.fmx&userid=pg

How do I

access

this
application?

2
-
7

Copyright © 2006, Oracle. All rights reserved.

Java Runtime Environment


The Forms applet runs in a Java Runtime
Environment (JRE) on the client machine.


Types of JREs:


Java
-
enabled browser (native)


JInitiator (Oracle
-
supplied plug
-
in to

Web browser) that provides:

Incremental Java Archive (JAR) file downloading

JAR file caching

Automatic Java security configuration


Sun Java plug
-
in

2
-
8

Copyright © 2006, Oracle. All rights reserved.

Starting a Run
-
Time Session

URL


http://summit.com:8889/forms/frmse

Static HTML files

OC4J

or HTTP Server

Forms Servlet


Forms Listener Servlet


Forms Runtime Engine

Web browser

1

2

3

DB

PLX files

MMX files

Forms application executables

FMX files

Web server

Forms services

Client tier

Middle tier: Application Server

2
-
9

Copyright © 2006, Oracle. All rights reserved.

Static HTML files

OC4J

or HTTP Server

Forms Servlet


Forms Listener Servlet


Forms Runtime Engine

URL

Web browser

Starting a Run
-
Time Session

4

5

Applet started

6

DB

PLX files

MMX files

Forms application executables

FMX files

Web server

Forms services

Middle tier: Application Server

Client tier


http://summit.com:8889/forms/frmse

2
-
10

Copyright © 2006, Oracle. All rights reserved.

Web server

Static HTML files

OC4J

or HTTP Server

Forms Servlet


Forms Listener Servlet


Forms Runtime Engine

Forms services

8

URL

Web browser

Starting a Run
-
Time Session

Middle tier: Application Server

8

7

DB

PLX files

MMX files

Forms application executables

FMX files

Client tier


http://summit.com:8889/forms/frmse

2
-
11

Copyright © 2006, Oracle. All rights reserved.

Forms Client

Base HTML files

Forms Servlet

Forms Listener Servlet

Forms Runtime Engine

Application Server

Static HTML files

HTTP Server or OC4J

Forms Servlet

Dynamic

HTML file is
created.

Desktop client

URL PARAMETERS:

?form=customers.fmx

&userid=un/pw@db

&buffer_records=NO

...

URL pointing to Forms Servlet

basejini.html

formsweb.cfg


http://summit.com:8889/forms/frmservlet?form=customer

Web server

Forms services

2
-
12

Copyright © 2006, Oracle. All rights reserved.

Forms Client


Generic Java applet


Responsibilities:


Displays the form’s user interface


Processes user interaction back to

Forms Services


Processes incoming messages

from Forms Services

Generic

Java applet

Forms client

Desktop client

2
-
13

Copyright © 2006, Oracle. All rights reserved.

Forms Listener Servlet

Java Servlet that:


Creates Forms

Runtime process

for each client


Stops the Runtime process at the end of a session


Manages network communications between the
client and the Forms Runtime process


Communicates through a Web server process

HTTP Server

or

OC4J

Middle tier

HTTP/

HTTPS

Forms

Listener

Servlet

Forms

Runtime

process

2
-
14

Copyright © 2006, Oracle. All rights reserved.

Forms Runtime Engine

The Forms Runtime Engine:


Is a process (
ifweb90
) that runs on the
Application Server


Manages application logic and processing


Communicates with the client browser and the
database

2
-
15

Copyright © 2006, Oracle. All rights reserved.

What You See at Run Time

1

3

5

2

4

2
-
17

Copyright © 2006, Oracle. All rights reserved.

Identifying the Data Elements

5

1

2

7

8

6

4

9

3

10

2
-
18

Copyright © 2006, Oracle. All rights reserved.

Navigating a Forms Developer Application

Methods of navigation:


Default menu


Menu toolbar


Mouse


Buttons


Function keys

2
-
20

Copyright © 2006, Oracle. All rights reserved.

Modes of Operation: Enter
-
Query Mode

Allows:


Unrestricted and
restricted queries


Query/Where dialog
box


Record count by using
Query
>

Count Hits

Does not allow:


Navigation out of
current data block


Exiting run
-
time
session


Certain functions


Insert, update, delete

2
-
21

Copyright © 2006, Oracle. All rights reserved.

Modes of Operation: Normal Mode

Allows:


Unrestricted queries


Insert, update, delete


Commit (Save)


Navigation out of
current data block


Exiting run
-
time
session

Does not allow:


Restricted queries


Query/Where dialog
box

2
-
22

Copyright © 2006, Oracle. All rights reserved.

Retrieving Data

1

3

4

2

A B C D

1

2

Restricted query

A

B

C

D

A B C D

1

2

3

4

Unrestricted query

A

B

C

D

1

2

3

4

2
-
23

Copyright © 2006, Oracle. All rights reserved.

Retrieving Restricted Data


Do not use quotation marks with character and
date items.


The
LIKE

operator is implied with % or _.


Use hash (#) in front of SQL operators.


Use Query/Where for complex query conditions.


Use default date format (DD
-
MON
-
RR) in
Query/Where.


Use double quotation marks around literals in
Query/Where.

2
-
25

Copyright © 2006, Oracle. All rights reserved.

Using the Query/Where Dialog Box


Invoke by:


Entering

:
<
variable_name

>

&
<variable_name

>

:


&


Executing query


Used to write:


Complex search conditions


Queries with
OR

predicates


The
ORDER

BY

clause

2
-
27

Copyright © 2006, Oracle. All rights reserved.

Inserting, Updating, and Deleting

Form module

Deletes

Updates

Inserts

Memory

2
-
29

Copyright © 2006, Oracle. All rights reserved.

Making Changes Permanent


Select Action
>
Save to
make changes
permanent.


Select Action
>

Clear
All to discard changes.

or

Toolbar

Menu

To commit or

roll back:

Deletes

Updates

Inserts

Memory

2
-
30

Copyright © 2006, Oracle. All rights reserved.

Displaying Errors



Use to view Oracle errors



Select Help
>

Display Error



Shows Database Error window:


SQL statement


Error information

2
-
31

Copyright © 2006, Oracle. All rights reserved.

Summary

In this lesson, you should have learned that:


You can use OC4J on the development machine to
run a Forms application in a Web browser


At run time:


The Forms Client is downloaded


The Forms Servlet creates a start HTML file


The Forms Listener Servlet starts a run
-
time
session and maintains communication between it
and the Forms Client


The Forms Runtime Engine carries out application
logic and maintains a database connection on
behalf of the Forms Client

2
-
32

Copyright © 2006, Oracle. All rights reserved.

Summary

In this lesson, you should have learned that:


When you run a form, you see a Java applet
running in a browser and displaying a menu, menu
toolbar, console, and several kinds of data
elements


Users navigate a Forms application using the
menu, toolbar, the mouse, buttons, or function
keys


The two main modes of operation are Normal
mode and Enter
-
Query mode


Executing a query returns all records, unless the
query is restricted by search criteria

2
-
33

Copyright © 2006, Oracle. All rights reserved.

Summary

In this lesson, you should have learned that:


In Normal mode, you can insert, update, and
delete records and commit changes to the
database.


You display database errors from the menu (Help
> Display Error).

2
-
34

Copyright © 2006, Oracle. All rights reserved.

Practice 2: Overview

This practice covers the following topics:


Starting OC4J


Running the course application:


Querying records


Inserting a record


Updating a record


Deleting a record


Displaying a database error