Home » Developer & Programmer » Forms » web.show_document() secure URL
web.show_document() secure URL [message #318470] Tue, 06 May 2008 23:46 Go to next message
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 #318518 is a reply to message #318470 ] Wed, 07 May 2008 01:36 Go to previous messageGo to next message
djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Is your report server working now? See http://www.orafaq.com/forum/t/101956/67467/

David
Re: web.show_document() secure URL [message #319128 is a reply to message #318518 ] Fri, 09 May 2008 02:18 Go to previous messageGo to next message
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 #319159 is a reply to message #318470 ] Fri, 09 May 2008 03:59 Go to previous messageGo to next message
paradoxkhan
Messages: 23
Registered: April 2008
Location: Pakistan
Junior Member

dear irvin i have sent u Jar file....let me know if whole thing works .....waiting for reply
Re: web.show_document() secure URL [message #319533 is a reply to message #319159 ] Mon, 12 May 2008 02:09 Go to previous messageGo to next message
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 #319550 is a reply to message #318470 ] Mon, 12 May 2008 02:56 Go to previous messageGo to next message
paradoxkhan
Messages: 23
Registered: April 2008
Location: Pakistan
Junior Member

dear irvin

im out of town......u can download it from
http://www.oracle.com/technology/products/forms/techlisting10g.html
artical name:below integration cloumn[ Oracle Forms Services - Secure Web.Show_Document calls to Oracle Reports 15-Feb-2004]

download the zip file....but dear let me know if whole thing works...waiting for your reply ba bye Smile
Re: web.show_document() secure URL [message #319787 is a reply to message #319550 ] Tue, 13 May 2008 01:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: web.show_document() secure URL [message #321364 is a reply to message #318470 ] Tue, 20 May 2008 01:18 Go to previous messageGo to next message
paradoxkhan
Messages: 23
Registered: April 2008
Location: Pakistan
Junior Member

Dear

still stuck with the problem.....any solution?
im working on it but invain...let me know if any progress
Re: web.show_document() secure URL [message #321373 is a reply to message #321364 ] Tue, 20 May 2008 01:48 Go to previous messageGo to next message
djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Would you please restate the problem that you are having? Just the error code and error message please, or what is not happening.

David
Re: web.show_document() secure URL [message #321714 is a reply to message #321373 ] Wed, 21 May 2008 02:11 Go to previous messageGo to next message
djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Received by PM.
irvs79 wrote on Fri, 16 May 2008 19:38
Hello Mr. Martin,

I tried following the instructions on the whitepaper that I got from www.otn.com regarding Secure Web.Show_Document. I attached the zip file for your reference. However, I changed the file extension to .ora so I can attach it to this message. Please change the extension to .zip and extract the file. I followed every instruction stated on the said document but still, oracle logon screen is coming out. It seems like the form failed to update the java bean. The browser for the report is also producing a REP-51002 error. Lastly, I also noticed that the OC4J window is displaying the following messages:

Not able to load oracle.reports.util.EnvironmentGlobal class
Using oracle.reports.util.Environment class

I tried looking for possible reasons but I was not able to find an answer. Paradoxkhan and I were facing the same problem now. Please take a look on this and let us know what we are missing.

Thank you very much for your kind help.

Irvin

Removed frmwebshowdoc_rep.ora.zip

Irvin,

I will work on this over the next couple of days. If you solve the problem please post how you did it in the forum.

Would you be so kind as to post the link to the zip file that you sent to me.

David
Re: web.show_document() secure URL [message #321975 is a reply to message #318470 ] Thu, 22 May 2008 00:05 Go to previous message
paradoxkhan
Messages: 23
Registered: April 2008
Location: Pakistan
Junior 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
Previous Topic:Changing Tab Pages Colors in Forms 10g
Next Topic:How to display data in Dynamic columns grid
Goto Forum:
  


Current Time: Fri Jul 25 14:56:15 CDT 2008

Total time taken to generate the page: 0.05101 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.