WEBUTIL installation in Oracle Application Server10.1.2.0.2
1.download http://www.oracle.com/technology/software/products/forms/files/webutil/webutil_106.zip
2.upzip webutil_106.zip
3.copy java\frmwebutil.jar to the directory [OraHome]\forms\java
4.copy all files in directory server\ to the directory [OraHome]\forms\server;
5.copy directory webutil to the directory [OraHome]\forms\;
6.unzip jacob_18.zip
http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip
7.copy jacob.jar to the directory %ORACLE_HOME\forms\java;
8.copy jacob.dll to the directory %ORACLE_HOME\forms\webutil;
9.set environment variablePath :[OraHome]\jdk\bin
10.open command window,sign frmwebutil.jar and jacob.jar
cd [OraHome]\forms\webutil\
[OraHome]\forms\webutil\sign_webutil [OraHome]\forms\java\frmwebutil.jar
[OraHome]\forms\webutil\sign_webutil [OraHome]\forms\java\jacob.jar
note:Do not care if key is duplicated when signing
11.create webutil_db package;
login db as sysdba
CREATE USER webutil IDENTIFIED BY webutil
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
GRANT CONNECT, resource, CREATE PUBLIC SYNONYM TO webutil;
grant execute on dbms_lob to webutil;
grant execute on utl_encode to webutil;
grant execute on utl_raw to webutil;
CONNECT webutil/webutil@orcl
@[OraHome]\forms\create_webutil_db.sql
CREATE PUBLIC SYNONYM webutil_db FOR webutil.webutil_db;
grant execute on webutil_db to public;
12.modify [OraHome]\forms\server\default.env
CLASSPATH=[OraHome]\forms\java\frmwebutil.jar;[OraHome]\jdk\jre\lib\jacob.jar;[OraHome]\jdk\jre\lib\rt.jar ;
13.modify [OraHome]\forms\server\formsweb.cfg
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar,frmall.jar
14.modify [OraHome]\forms\server\webuitl.cfg
transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE
15.modify webutil.pll
replace webutil.pll by webutil.pll in the directory Oracle Developer Suit-home/forms/webutil.pll
and rename webutil.pll to webutil_lib.pll
WEBUTIL installation in Oracle Developer Suit10.1.2.0.2
In Forms DS 10.1.2.0.2, almost all the required configurations are done by the Oracle Universal Installer itself, except for the part related to jacob.
1) Download http://prdownloads.sourceforge.net/jacob-project/jacob_18.zip
and extract to a temporary staging area. Do not attempt to use 1.7 or 1.9.
2) Copy or move jacob.jar and jacob.dll
C:\webutile is the folder where you extracted Jacob, and will end in ...\jacob_18
cd C:\webutile
copy jacob.jar Oracle_Home\forms\java\.
copy jacob.dll Oracle_Home\forms\webutil\.
The Jacob staging area is no longer needed, and may be deleted.
3) Sign frmwebutil.jar and jacob.jar
Open a DOS command prompt.
Add Oracle_Home\jdk\bin to the PATH:
set PATH=C:\oracle\developer\jdk\bin;%PATH%
Sign the files, and check the output for success:
C:\oracle\developer\forms\webutil\sign_webutil C:\oracle\developer\forms\java\frmwebutil.jar
C:\oracle\developer\forms\webutil\sign_webutil C:\oracle\developer\forms\java\jacob.jar
4) If you already have a schema in your RDBMS which contains the WebUtil stored code,
you may skip this step. Otherwise,
Create a schema to hold the WebUtil stored code, and privileges needed to
connect and create a stored package. Schema name "WEBUTIL" is recommended
for no reason other than consistency over the user base.
Login as sysdba
CREATE USER webutil IDENTIFIED BY webutil
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
GRANT CONNECT, resource, CREATE PUBLIC SYNONYM TO webutil;
grant execute on dbms_lob to webutil;
grant execute on utl_encode to webutil;
grant execute on utl_raw to webutil;
CONNECT webutil/webutil@orcl
@[OraHome]\forms\create_webutil_db.sql
CREATE PUBLIC SYNONYM webutil_db FOR webutil.webutil_db;
grant execute on webutil_db to public;
5) Modify Oracle_Home\forms\server\default.env, and append C:\oracle\developer\jdk\jre\lib\rt.jar
to the CLASSPATH entry.
6) Modify Oracle_Home\forms\server\formsweb.cfg insde [default] add :
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
also add :
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar,frmall.jar
archive=frmwebutil.jar,frmall.jar
lookAndFeel=oracle
7) Modify Oracle_Home\forms\server\webutil.cfg and add :
transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE
8)rename webutil.pll to webutil_lib.pll
8) Start the OC4J instance
9) Start Forms Builder and connect to a schema in the RDBMS used in step (4).
Open webutil.pll, do a "Compile ALL" (shift-Control-K), and generate to PLX (Control-T).
It is important to generate the PLX, to avoid the FRM-40039 discussed in
Note 303682.1
If the PLX is not generated, the Webutil.pll library would have to be attached with
full path information to all forms wishing to use WebUtil. This is NOT recommended.
10) Create a new FMB.
Open webutil.olb, and Subclass (not Copy) the Webutil object to the form.
There is no need to Subclass the WebutilConfig object.
Attach the Webutil.pll Library, and remove the path.
Add an ON-LOGON trigger with the code
NULL;
to avoid having to connect to an RDBMS (optional).
Create a new button on a new canvas, with the code
show_webutil_information (TRUE);
in a WHEN-BUTTON-PRESSED trigger.
Compile the FMB to FMX, after doing a Compile-All (Shift-Control-K).
11) Under Edit->Preferences->Runtime in Forms Builder, click on "Reset to Default" if
the "Application Server URL" is empty.
Then append "?config=webutil" at the end, so you end up with a URL of the form
http://server:port/forms/frmservlet?config=webutil
分享到:
相关推荐
WebUtil相关包
WebUtil.java,HtmlUtil.java,PathUtil.java,DateUtil.java,StringFormat.java 有获取ip,获取mac,字符串参数化,时间转换,html标签过滤等方法,下载下来后见项目,放到包里面,注意包名的一致
WebUtil(常用web工具类) java,java web日常开发中经常用到一些工具, 网上找的往往并不适合, 需要自己的改进。 为此,封装一些常用工具非常必要。 常用工具类列表: name function json json处理工具类 xml ...
webutil Web开发实用程序 包含用于实现Web开发中常见任务的各种功能分组。 URL_Util 允许操纵URL的查询参数。 参数称为选项。 [removed][removed] [removed] const { URL_Util } = WebUtil; let query = ...
慕课网上jsp+servlet技术生成报表 一课的源码。并不完全,且要配数据库,但是基础知识点都是用到的,且能正常运行。希望对初学者有所帮助。我也是花了很多时间编写和调试的。
String path = WebUtil.getWebinfPath()+File.separatorChar+"properties"+File.separatorChar+"mcc.properties"; File file = new File(path); InputStream is = new java.io.FileInputStream(file); ...
j2ee书籍,对j2ee进行了全面的介绍,使读者能够很好的掌握j2ee,相信读过本书的人能学习到自己需要的知识--连池,Eclipse操作,Struts,Spring,Hibernate,iBATIS,xml, Log4J 学习笔记.
xss attack test2 xss attack test2 xss attack test2 xss attack test2
webutil Python Webapp的通用实用程序和处理程序代码。 模块是通用的; 其余模块主要针对 。 webutil未开发,维护或作为独立软件包分发。 相反,它作为库的一部分分发。 使用pip install oauth-dropins 。 支持...
WebUtil 执行基本的HTTP请求以使您的服务器执行操作。 您可以在网络浏览器中使用服务器中的实用程序! 如果您想为系统编写对HTTP的自定义调用,这很好。 我建议使用HTTP身份验证对此进行保护。 安全 代码内已采取...
快逸报表使用 在网上找个很多资料,也按着资料去尝试了多次,最终都...--webutil.jar,快逸报表自身带的jar是不能用的,本人所用版本这个jar包为3.6kb,替换成一个网上找打一个新的4.05kb大小的webutil.jar后,问题解决了.
rest高级api)、消息中间件(RabbitMQ发送与接受消息)、阿里云通信、开源单点登陆系统CAS、分布式事务、微信扫码支付(微信支付二维码、支付回调逻辑处理...WebUtil工具类(GET字符集设置处理、通过ip获取城市、浏览器类型)...
glmall-api模块的主要实体和通用映射器的服务接口glmall-commonUtil放置的是通用的第三方工具包工具:springboot,common等依赖的glmall-serviceUtil主要管理连接数据库层操作的依赖包glmall-webUtil主要管理的是...