How to install and configure Webutil on Oracle Application Server 10g/Developer 10g both on Windows/Linux
Setup WebUtil for Developer Suite 10g or Oracle AS 10g
WebUtil is a powerful component in Oracle Form 9i,10g, but setting up WebUtil is a nightmare for most of the developer. I hope the guideline below is useful for people who wish to setup WebUtil at Windows environment.
Steps to setup WebUtil in Developer Suite or Oracle AS
=======================================================
1. Download WebUtil and Jacob library
1.1.Webutil_106.zip from:
http://www.oracle.com/technology/software/product/forms/files/webutil/webutil_106.zip
1.2.Extract the zip file and put into the Oracle AS or Developer Suite 10g\forms
1.3.Download Jacob library from:
http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip
1.4.Extract the zip file then:
1.4.1. COPY JACOB.JAR file on D:\DevSuiteHome_1\forms\java
1.4.2. COPY JACOB.DLL file on D:\DevSuiteHome_1\forms\webutil
2.Signing frmwebutil.jar and Jacob.jar.
2.1. On Dos Prompt Sign frmwebutil.jar and jacob.jar with following commands
C:\>set path=D:\DevSuiteHome_1\jdk\bin;%PATH%
Sign the files by using
C:\>D:\oracle\DevSuiteHome_1\forms\webutil\sign_webutil D:\DevSuiteHome_1\forms\java\frmwebutil.jar
Output
Generating a self signing certificate for key=webutil2...
...successfully done.
Backing up D:\DevSuiteHome_1\forms\java\frmwebutil.jar as D:\DevSuiteHome_1\forms\java\frmwebutil.jar.old...
1 file(s) copied.
Signing D:\DevSuiteHome_1\forms\java\frmwebutil.jar using key=webutil2...
...successfully done.
C:\>D:\DevSuiteHome_1\forms\webutil\sign_webutil D:\DevSuiteHome_1\forms\java\jacob.jar
Output
Generating a self signing certificate for key=webutil2...
keytool error: java.lang.Exception: Key pair not generated, alias already exists
.
There were warnings or errors while generating a self signing certificate. Please review them.
.
Backing up D:\DevSuiteHome_1\forms\java\jacob.jar as D:\DevSuiteHome_1\forms\java\jacob.jar.old...
1 file(s) copied.
Signing D:\DevSuiteHome_1\forms\java\jacob.jar using key=webutil2...
...successfully done.
3.Create webutil package in the database.
3.1 Open sqlplus and run create_webutil_db.sql at \forms.
3.2 The script will create webutil package in the database user.
3.3 You need to run create_webutil_db.sql for all database users which need to make use of Webutil.
4.Compile the webutil.pll.
4.1 You can compile using Oracle Forms Developer or run the command below:
a.frmcmp module=ORACLE_HOME\forms\webutil.pll userid= module_type=library compile_all=yes
5.Modify the DEFAULT.ENV file,
you can find default.env file at D:\DevSuiteHome_1\forms\server\Default.env
append the following path in CLASSPATH entry
;D:\DevSuiteHome_1\jdk\jre\lib\rt.jar
append the following path in FORMS_PATH
;D:\DevSuiteHome_1\forms\webutil
6.Modify the FORMSWEB.CFG file,
you can find this file at D:\DevSuiteHome_1\forms\server\formsweb.cfg
add:
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
also add :
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar,f90all.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar,f90all.jar
lookAndFeel=oracle
7.Modify the WEBUTIL.CFG file
locate at the same place where you found the FORMSWEB.CFG file and change the following
#transfer.database.enabled=FALSE (default value)
transfer.database.enabled=TRUE
#transfer.appsrv.enabled=FALSE (default value)
transfer.appsrv.enabled=TRUE
Setup WebUtil for Developer Suite 10g or Oracle AS 10g
WebUtil is a powerful component in Oracle Form 9i,10g, but setting up WebUtil is a nightmare for most of the developer. I hope the guideline below is useful for people who wish to setup WebUtil at Windows environment.
Steps to setup WebUtil in Developer Suite or Oracle AS
=======================================================
1. Download WebUtil and Jacob library
1.1.Webutil_106.zip from:
http://www.oracle.com/technology/software/product/forms/files/webutil/webutil_106.zip
1.2.Extract the zip file and put into the Oracle AS or Developer Suite 10g\forms
1.3.Download Jacob library from:
http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip
1.4.Extract the zip file then:
1.4.1. COPY JACOB.JAR file on D:\DevSuiteHome_1\forms\java
1.4.2. COPY JACOB.DLL file on D:\DevSuiteHome_1\forms\webutil
2.Signing frmwebutil.jar and Jacob.jar.
2.1. On Dos Prompt Sign frmwebutil.jar and jacob.jar with following commands
C:\>set path=D:\DevSuiteHome_1\jdk\bin;%PATH%
Sign the files by using
C:\>D:\oracle\DevSuiteHome_1\forms\webutil\sign_webutil D:\DevSuiteHome_1\forms\java\frmwebutil.jar
Output
Generating a self signing certificate for key=webutil2...
...successfully done.
Backing up D:\DevSuiteHome_1\forms\java\frmwebutil.jar as D:\DevSuiteHome_1\forms\java\frmwebutil.jar.old...
1 file(s) copied.
Signing D:\DevSuiteHome_1\forms\java\frmwebutil.jar using key=webutil2...
...successfully done.
C:\>D:\DevSuiteHome_1\forms\webutil\sign_webutil D:\DevSuiteHome_1\forms\java\jacob.jar
Output
Generating a self signing certificate for key=webutil2...
keytool error: java.lang.Exception: Key pair not generated, alias already exists
.
There were warnings or errors while generating a self signing certificate. Please review them.
.
Backing up D:\DevSuiteHome_1\forms\java\jacob.jar as D:\DevSuiteHome_1\forms\java\jacob.jar.old...
1 file(s) copied.
Signing D:\DevSuiteHome_1\forms\java\jacob.jar using key=webutil2...
...successfully done.
3.Create webutil package in the database.
3.1 Open sqlplus and run create_webutil_db.sql at \forms.
3.2 The script will create webutil package in the database user.
3.3 You need to run create_webutil_db.sql for all database users which need to make use of Webutil.
4.Compile the webutil.pll.
4.1 You can compile using Oracle Forms Developer or run the command below:
a.frmcmp module=ORACLE_HOME\forms\webutil.pll userid= module_type=library compile_all=yes
5.Modify the DEFAULT.ENV file,
you can find default.env file at D:\DevSuiteHome_1\forms\server\Default.env
append the following path in CLASSPATH entry
;D:\DevSuiteHome_1\jdk\jre\lib\rt.jar
append the following path in FORMS_PATH
;D:\DevSuiteHome_1\forms\webutil
6.Modify the FORMSWEB.CFG file,
you can find this file at D:\DevSuiteHome_1\forms\server\formsweb.cfg
add:
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
also add :
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar,f90all.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar,f90all.jar
lookAndFeel=oracle
7.Modify the WEBUTIL.CFG file
locate at the same place where you found the FORMSWEB.CFG file and change the following
#transfer.database.enabled=FALSE (default value)
transfer.database.enabled=TRUE
#transfer.appsrv.enabled=FALSE (default value)
transfer.appsrv.enabled=TRUE