| web.show_document() secure URL [message #318470] |
Tue, 06 May 2008 23:46  |
paradoxkhan Messages: 23 Registered: April 2008 Location: Pakistan |
Junior 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   |
irvs79 Messages: 6 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 #319533 is a reply to message #319159 ] |
Mon, 12 May 2008 02:09   |
irvs79 Messages: 6 Registered: April 2008 |
Junior Member |
|
|
Hello Paradoxkhan!
Unfortunately, I have not received anything from you. I checked my email twice and I did not see any java file. Can you please send it again and please make sure that you send it to: irvs79@yahoo.com.
Thank you so much!
|
|
|
|
| Re: web.show_document() secure URL [message #319787 is a reply to message #319550 ] |
Tue, 13 May 2008 01:02   |
irvs79 Messages: 6 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   |
irvs79 Messages: 6 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
|
|
|
|
|
|
|