The%20Power%20of%20Webutil

1
The Power of WebUtil Gerd Volberg, OPITZ
CONSULTING
2
Why use Webutil?

• Have you ever tried a migration from Forms6i C/S
  to Forms9i?
• Rewrite the client side integration with
  individual Java beans
• Change the form to use your Java bean
• Test and bug-fix your code!
• Problems
• Client File Handling ( TEXT_IO)
• Client Command Execution ( HOST)
• Desktop Integration (OLE / DDE)
• OS Integration (ORA_FFI)
• Document Handling / Round Trips ?

3
Why use Webutil?

• Any Forms developer can implement complex tasks
  on client machines through WebUtil
• No need for Java, only PL/SQL !

Simplify migration!
4
What is WebUtil?
5
WebUtil architecture
6
WebUtil runtime install checklist
WebUtil pre-requisites
WebUtil-ZIP distribution
Configuration database

• Logging
• File Up-/Downlowd
• Work Area

Configuration HTTP Server

• formsweb.cfg
• environment files

WebUtil entries
Configuration of Options
Add required Objects in Forms
Change Runtime environment
Run and test Form
7
WebUtil extensibility

• You can extend WebUtil!
• New functions implemented are transparent for
  developers
• Be aware of release problems!
• Use packaged APIs to define new functionality
• Extended Logging and Error-Handling
• Message Dispatching
• Localisation / Language support
• Object caching
• Installation Helpers

8
WebUtil maintainability / scalability

• Auto-Cleanup
• Logging and Error Reporting
• Java Console
• Client side alerts
• Server side logs
• Multi-Lingual
• Translation of Error Messages possible

9
Installation

• Pre-Requisites
• Windows-NT, Windows 2000, Windows XP
• Oracle 9iDS Rel.2 v9.0.2
• JInitiator 1.3.1.8
• WebUtil 1.02
• Install WebUtil to ltORAHOME Forms9igt\forms90
• signer.properties in ltWEBUTIL-Utilitiesgt
• JDK_HOMEC\oracle\oraForms9\jdk
• JINIT_HOMEC\Programme\Oracle\JInitiator 1.3.1.8
• Add DN-Parameters for your Company

10
Installation (2)

• Certificate the JAR
• Start makecert
• Sign webutil.jar
• Registry Changes
• Modify FORMS90_BUILDER_CLASSPATH
• Append C\oracle\oraForms9\forms90\WEBUTIL\lib\web
  util.jar
• orion-web.xml in ltORAHOME Forms9igt\j2ee\Oracle9iDS
  \application-deployments\forms\forms90web
• Add
• ltvirtual-directory virtual-path"/webutil"
  real-path"C\oracle\oraForms9\forms90\WEBUTIL\lib
  " /gt

11
Installation (3)

• forms90.conf in ltORAHOME Forms9igt\forms90\server
• Add
• AliasMatch /forms90/webutil/(..)
  "C\oracle\oraForms9\forms90\WEBUTIL\lib/1"
• formsweb.cfg in ltORAHOME Forms9igt\forms90\server
• Add
• webUtilArchive/forms90/webutil/webutil.jar,/forms
  90/webutil/jacob.jar
• default.env in ltORAHOME Forms9igt\forms90\server
• Add
• Webutil-Section
• WEBUTIL_CONFIGC\oracle\oraForms9\forms90\WEBUTIL
  \server\webutil.cfg

12
Installation (4)

• default.env
• Add to the CLASSPATH
• C\oracle\oraForms9\forms90\WEBUTIL\lib\jacob.jar
  C\oracle\oraForms9\jdk\jre\bin\classic\jvm.dll
• Add to the FORMS90_PATH
• C\oracle\oraForms9\forms90\WEBUTIL\formsC\oracl
  e\oraForms9\forms90
• Changes in Forms
• Attach WebUtil.pll to the form
• Subclass WebUtil Objectgroup from the webutil.olb

13
Demo

• Simple Text I/O
• OLE integration
• File handling
• Using WebUtil-package functions

14
Best practice performance / tuning

• Reduce network traffic
• only enable the forms that use WebUtil components
• use functions efficient (f.e. read files into a
  work area on server)
• Disable logging / error recording at production
  time

15
Best practice

• Try object reuse on the client to save destroying
  and recreating the objects
• Free client resources when possible
• Evaluate File transfer vs. File uploading

16
Experience

• Forms 6i C/S to 6i Web (years ago)
• C/S functions like text_io were rewritten in java
  code
• Write java code
• Integrate it in java bean areas
• Interact with the bean with set-, get-functions
  and WHEN-CUSTOM-ITEM-EVENT-Trigger
• Forms 6i C/S to 9i (actually)
• Installing WebUtil
• C/S functionality went 11 to Webutil with
  client_ltcodegt

17
Thank you!
Q

A