Setting up Webutil for Oracle Forms

What is Webutil

While migrating Oracle Forms applications from 6i to 10g, it's possible that you'll face problems on parts of the form that won't work anymore. Oracle Forms 6i are Client based, this means that every form has to be on each client computer in order to work. The functionality that was written in the forms will be executed on the client machine. Oracle Forms 10g is Client - Server, this means that there are no forms needed on the client computer in order to work. This means that when you don't change your code, the code will be ran on the server instead of the client computer. Webutil is a utility which provides much of the client side functionality taken for granted with a client/server application by providing a set of pre-written Java Beans and an API to perform client side functions such as Host, OLE integration and Text_IO running on the client browser machine. With Webutil you'll be able to change all this and use the application as it was designed for.

 

Downloads

You can download the Webutil Software files (Version 1.0.6) from the oracle server: Click here

You also need the JACOB files (jar and dll) you can download them from Local or from their site

If you want to read the entire documentation file about Webutil: Click here

 

Features

Text_IO File transfer
Read and write text files on the client machine. Move from between the client, application server and database.
Tool_Env File Manipulation
Read client side variables Manipulate client side files.
C API on the client Client machine information
Interface with client side C. Read information from the client machine
Host READ/WRITE_IMAGE_FILE
Run Host commands on the client machine Read and write client side images
OLE2 Get_File_Name
Integrate with client side OLE (e.g. Word and Excel) Use a file selection dialog on the client machine
Enhanced Host commands D2KWUtil? features
Host command can now call back into Forms! Client side interface into the D2KWUtil? package.
Browser functions Integrate with the browser.

 

Configuration WebUtil

This installation can only be used when you have allready a working Forms 10g environment up and running!

1) Make sure that the JDK executables are in the windows path so the can be called from everywhere:
Go to control panel -> system-> environmentvariables->add c:\devsuitehome\jdk\bin at the beginning of PATH variable

2) Copy Jacob.jar and dll from the links above to C:\DevSuiteHome\forms\java and C:\DevSuiteHome\forms\webutil

3) frmwebutil.jar en Jacob.jar have to be signed:
Open cmd prompt
Go to C:\DevSuiteHome\forms\webutil
Execute the following commands: sign_webutil C:\DevSuiteHome\forms\java\frmwebutil.jar
and sign_webutil C:\DevSuiteHome\forms\java\jacob.jar

4) Add the following path C:\DevSuiteHome\forms\java\jacob.jar to this register key [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_DevSuiteHome] “FORMS_BUILDER_CLASSPATH” using regedit

5) Change the configuration file formsweb.cfg so webutiljpi.htm will be used as htm template for the forms:
baseHTML=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm

6) Also add the following part in the formsweb.cfg file after allownewconnections
#################################################
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
archive=frmall.jar, CaffoJavaClient.jar, frmwebutil.jar, jacob.jar
#################################################

7) Add the following to the CLASSPATH in the default.env file: C:\DevSuiteHome\forms\java\frmall.jar and C:\DevSuiteHome\forms\java\jacob.jar

 

 

Database development

UTL_FILE will not do implicit character conversion

UTL_FILE will not do implicit character conversion Recently we migrated a database from one server to another. We used this occasion to change the character set of the database from WE8ISO8859P15 to AL32UTF8. After this migration we started to see invalid characters in our database tables. This was due to the fact that utl_file will not use the NLS_LANG settings of your OS. So if on your...

Java

Number column as boolean

Number column as boolean When you use an Oracle database, you don't have a boolean type to use in your tables. Usually, you work around this problem by using a numeric column with values 0 and 1. This however could cause some extra programming work when building an application on top of your database. The numbers have to be converted to booleans, and vice versa. Now, in ADF...

ADF @ BlackBelftFactory

ADF @ BlackBelftFactory Contribute and Contribute4J are proud to inform you that BlackBeltFactory (formerly JavaBlackBelt) now has an ADF exam online. Feel free to contribute!   http://forums.oracle.com/forums/thread.jspa?threadID=1101786

ADF productivity

Increase your JEE development productivity with Oracle ADF   Java EE is a standard, robust, scalable, and secure platform that forms the basis for many of today’s enterprise applications. Java EE provides a set of specifications for building multi-tier applications using the JavaTM language. In the past, there was a direct correlation between the robust nature of an...

Nexus and maven

Nexus and maven Read More

New Spring 3 MVC model

New Spring 3 MVC model Intro   Creating web applications with spring 3 has become a lot easier. Restful URL are easily manageable using annotations. This is a real pleasure for developing web applications. A bare minimum of XML is required, just to scan the annotations in your project.   Spring != many XML files   This is the minimal xml required for creating a spring 3...

Calling a Java Class in PL/SQL

Calling a Java class in PL/SQL   Create your java class. Make sure the method you want to call from PL/SQL is declared static . From Oracle 8 and higher, you can use the commandline utility loadjava to load your Java class loadjava -user username/password@SID -force -resolve MyPath\MyFile.java Login as SYS to grant privileges to the user Call...

Enterprise 2.0

Inter-Portlet Communication With ADF Portlets

Inter-Portlet Communication With ADF Portlets in Webcenter 11g In a modern Enterprise 2.0 portal you will find the need to let 2 portlets communicate with each other. Because you are working with webcenter, the change is big you also are creating ADF portlets instead of normal JSP portlets. Webcenter currently does not implement the JSR286 standard which describes how to communicate...

Fusion middleware

Oracle Forms: What’s next?

Oracle Forms: What's next? With the release in July 2009 of Oracle Fusion Middleware 11 g , including tools such as Oracle Forms 11 g and Oracle Reports 11 g , Oracle customers are looking for guidance on their choice of development tools for existing and future application development.   Oracle customers...

ConributeNewsletter

Conribute Newsletter Recently we started sending out a newsletter to some of our customers. In our newsletter we want to regularly inform people of the latest Oracle news, usefull technical tips and specific Contribute updates. You can see an example of our newsletter by clicking on the link . Feel free, to subscribe to our newsletter on this page.

AreYouTheSmartest 2010

AreYouTheSmartest 2010 Every year Oracle provides their partners an overview of the latest 'hot topics' about the Oracle Fusion Middleware product portfolio. This year the following topics were on the agenda : - Layering your enterprise security - Database 11gR2 - Enterprise 2.0 - AYTS_ETL - Enterprise Manager from app to OS - Application Grid 11g  For each session there is an...

Setting up Webutil for Oracle Forms

Setting up Webutil for Oracle Forms What is Webutil While migrating Oracle Forms applications from 6i to 10g, it's possible that you'll face problems on parts of the form that won't work anymore. Oracle Forms 6i are Client based, this means that every form has to be on each client computer in order to work. The functionality that was written in the forms will be executed on the...

Java

Number column as boolean

Number column as boolean When you use an Oracle database, you don't have a boolean type to use in your tables. Usually, you work around this problem by using a numeric column with values 0 and 1. This however could cause some extra programming work when building an application on top of your database. The numbers have to be converted to booleans, and vice versa. Now, in ADF...

ADF productivity

Increase your JEE development productivity with Oracle ADF   Java EE is a standard, robust, scalable, and secure platform that forms the basis for many of today’s enterprise applications. Java EE provides a set of specifications for building multi-tier applications using the JavaTM language. In the past, there was a direct correlation between the robust nature of an...