web.show_document() secure URL [message #318470] |
Tue, 06 May 2008 23:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
paradoxkhan
Messages: 92 Registered: April 2008 Location: Pakistan
|
Member |
|
|
hi
im using web.show_document() to call reports.im using 10g DB,DEVon windowsxpSP2
im using Java bean to hide userid in URL
i have readed all the documents
steps i have performed
1:add bean in form and set implementation as: oracle.reports.utility.FrmReportsInteg
on when_button_press i have use code
---
V_URL:='/reports/rwservlet?server=repserver&report=d:\matrix.rdf'||'&desformat=htmlcss&destype=cache&userid=';
set_custom_property('emp.userid_bean',1,'WRITE_LOGOUTPUT','true');
set_custom_property('emp.userid_bean',1,'ADD_USERID',get_application_property(username)||'/'||
get_application_property(password)||'@'||get_application_property(connect_string));
set_custom_property('emp.userid_bean',1,'SET_COOKIE_PATH','/reports/');
set_custom_property('emp.userid_bean',1,'SET_MAX_AGE','30');
set_custom_property('emp.userid_bean',1,'WRITE_USERID_COOKIE','10g');
web.show_document(v_url,'_blank');
end;
2: formsweb.cfg
[MYAPP]
userid=scott/tiger@orcl
FORM=abc.fmx
envfile=default.env
archive_jini=f90all_jinit.jar,frmrwinteg.jar
3:<PARAM NAME="MAYSCRIPT" VALUE="TRUE"> in baseini htmlsource
4:places frmrwinteg.jar file in froms/java/ directory
5:http://localhost:8889/forms/frmservlet?config=myapp
but it gives error java.lang.classnotfoundexception:oracle.forms.engine.main
in console it says
oad: class oracle.forms.engine.Main not found.
java.lang.ClassNotFoundException: java.io.IOException: open HTTP connection failed.
at sun.applet.AppletClassLoader.getBytes(Unknown Source)
at sun.applet.AppletClassLoader.access$100(Unknown Source)
at sun.applet.AppletClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.applet.AppletClassLoader.findClass(Unknown Source)
at sun.plugin.security.PluginClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.applet.AppletClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.applet.AppletClassLoader.loadCode(Unknown Source)
at sun.applet.AppletPanel.createApplet(Unknown Source)
at sun.plugin.AppletViewer.createApplet(Unknown Source)
at sun.applet.AppletPanel.runLoader(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
but when i eliminate
archive_jini=f90all_jinit.jar,frmrwinteg.jar from formsweb.cfg
i-e
[MYAPP]
userid=scott/tiger@orcl
FORM=abc.fmx
envfile=default.env
forms runs but when i call reprts it prompt for
username and password
waiting for your kind replyyyyyyyyyyyyyyyyy
|
|
|
|
Re: web.show_document() secure URL [message #319128 is a reply to message #318518] |
Fri, 09 May 2008 02:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
irvs79
Messages: 7 Registered: April 2008
|
Junior Member |
|
|
Hello Mr. Martin,
I would like to try the same approach in hiding the user information when displaying reports via WEB.SHOW_DOCUMENT function. However, I was not able to find the "frmrwinteg.jar" program. I tried searching at http://otn.oracle.com/products/ forms but I was not able to find it. I also tried searching using google but I got the same result.
Would you know where else I could find the jar file? If you have a copy, kindly email it to me (irvs79@yahoo.com).
Thank you,
Irvin
|
|
|
|
|
|
Re: web.show_document() secure URL [message #319787 is a reply to message #319550] |
Tue, 13 May 2008 01:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
irvs79
Messages: 7 Registered: April 2008
|
Junior Member |
|
|
Hey dude!
Thanks for that quick response. I was able to download the file from the link that you sent. I am still on the testing phase of the application. There are still some errors that I need to fix. Don't worry it doesn't look like connected to the one you sent.
|
|
|
Re: web.show_document() secure URL [message #320379 is a reply to message #319550] |
Wed, 14 May 2008 22:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
irvs79
Messages: 7 Registered: April 2008
|
Junior Member |
|
|
Hello Paradoxkhan,
I was able to setup the .jar file and formsweb.cfg. I am now facing the same problem as yours. I am still searching for solutions though. If ever you find out the solution to the problem, please let me know.
Thanks in advance,
Irvin
|
|
|
|
|
|
Re: web.show_document() secure URL [message #321975 is a reply to message #318470] |
Thu, 22 May 2008 00:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
paradoxkhan
Messages: 92 Registered: April 2008 Location: Pakistan
|
Member |
|
|
Dear Martin
1) Im trying to Hide URL string when calling Reports
using Web.show().
2) i used Java bean to hide the Username/password.
3) i performed the above steps(mentioned in my first post).
but still not able to hide thr URL information....i have explained all errors i encounterd, in my first post ....
waiting for kind reply
|
|
|
|
|
|
Re: web.show_document() secure URL [message #383644 is a reply to message #321975] |
Thu, 29 January 2009 07:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
scorpio_
Messages: 8 Registered: October 2008
|
Junior Member |
|
|
Hello! I´m using the cookie method to hide a reports url, using the steps found in the web, I can run the report, I don´t have problems with errors (any type of errors), the reports run successfully, but the cookie has not write, then the reports server show the login page to authenticate with the data base and then the reports run...
The cookie method is not working fine.. someone has managed to successfully using this method?
|
|
|
|
|