Home » Developer & Programmer » Forms » Oracle Forms Is this possible?!?!?!
Oracle Forms Is this possible?!?!?! [message #351510] Wed, 01 October 2008 03:59 Go to next message
mnenchev
Messages: 6
Registered: October 2008
Junior Member
hi, all.
I am a java developer and i am not familiar with oracle forms 10g.
Recently i had a project about digital signing of web forms(on java). So the idea was: We have applet that runs in the client browser, it uses the JSObject to collect all input fields and it's values from CUSTOM web form and create xml document, that must be signed. This applet is like a lib.
I must do the same thing with a oracle form.
Is this possible: collect the oracle form's items on the client??? The form is custom i.e. unspecified items and count items.

If this is possible the next step is to verify the signed xml on the server. So how does oracle forms work. Is there a server side. What is the architecture? Could the xml be passed to the server and how the oracle form's items must be accessed on the server(i need them to verify the xml).

I will be glad if you could help me soon.
Excuse me for my bad english Sad.
Best regards.
Re: Oracle Forms Is this possible?!?!?! [message #351643 is a reply to message #351510] Wed, 01 October 2008 18:55 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Why are you going to use Forms? Why not use Java for everything?

David
Re: Oracle Forms Is this possible?!?!?! [message #351838 is a reply to message #351643] Fri, 03 October 2008 07:34 Go to previous messageGo to next message
mnenchev
Messages: 6
Registered: October 2008
Junior Member
Well, sir, my client wants this to be done in java, .net and oracle forms i.e. it must work for web projects in java and .net where i use aplet for this purpose. But in oracle forms how could i use only java.
Here is what i must do:
Collect all form item names and values and generate from them xml document(kept in the memory) like this:
<?xml version="1.0" encoding="UTF-8"?>
<form-fields>
<firstName type="text">Svetlin</firstName>
<lastName type="text">Nakov</lastName>
<gender type="select-one">Male</gender>
<maritalStatus type="radio">Married</maritalStatus>
<comments type="textarea">Some comments</comments>
<fileUpload type="file" file-name="Nakov-CV.pdf">
LS0tPV9OZXh0UGFydF8wM...MDE4NV8wMUM5MTQMC0tDQo=</fileUploadCV>
<termsAgree type="checkbox">true</termsAgree>
</form-fields>

This is done on the client side(i.e. i must use some VBean and in it to call method traverse(...)). After that the bean must 'sign' this document and after that the signature (string) must be send to the server and verified there. How could this be done? I managed to create a bean that collects the data and signs it but is it possible to execute java code on the server and how to pass this data to the server?

One more technical question how to debug bean?
I read about this and created this:
<HTML>
<!-- FILE: debug_pjc.htm (Oracle Forms) -->
<!-- -->
<!-- This is a HTML file used for debugging Pluggable Java Components -->
<!-- update the serverArgs parameter to include your test module -->
<!-- name and any other required Forms arguments -->
<!-- Amend references of 127.0.0.1:8889 to the correct server and -->
<!-- Port number if you are using a remote server -->
<HEAD><TITLE>Debug My PJC</TITLE></HEAD>
<BODY>
<APPLET CODEBASE="mnenchev-pc:8889/forms/java"
CODE="oracle.forms.engine.Main"
ARCHIVE="frmall.jar"
WIDTH="1000"
HEIGHT="1000">
<PARAM NAME="serverURL" VALUE="http://mnenchev-pc:8889/forms/lservlet">
<PARAM NAME="serverArgs" VALUE="module=perosnaldataform userid=test/test@xe">
</APPLET>
</BODY>
</HTML>

I use oracle forms 10g. But this exception is thrown(using vista 64):
D:\DevSuiteHome\jdk\bin\javaw.exe -ojvm -XXdebug,quiet,port52351 -Xbootclasspath/a:D:\DevSuiteHome\jdev\mywork\WebFormSignerBean\WebFormSignerBean\classes;D:\DevSuiteHome\forms\java\frmall.jar sun.applet.AppletViewer file:/D:/DevSuiteHome/forms/java/debug_pjc.html
Debugger connected to local process.
proxyHost=null

proxyPort=0

connectMode=HTTP, native.

Forms Applet version is : 10.1.2.0

java.lang.ClassNotFoundException: com/digisign/WebFormSignerBean

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:141)

at oracle.forms.handler.UICommon.instantiate(Unknown Source)

at oracle.forms.handler.UICommon.onCreate(Unknown Source)

at oracle.forms.handler.JavaContainer.onCreate(Unknown Source)

at oracle.forms.engine.Runform.onCreateHandler(Unknown Source)

at oracle.forms.engine.Runform.processMessage(Unknown Source)

at oracle.forms.engine.Runform.processSet(Unknown Source)

at oracle.forms.engine.Runform.onMessageReal(Unknown Source)

at oracle.forms.engine.Runform.onMessage(Unknown Source)

at oracle.forms.engine.Runform.sendInitialMessage(Unknown Source)

at oracle.forms.engine.Runform.startRunform(Unknown Source)

at oracle.forms.engine.Main.createRunform(Unknown Source)

at oracle.forms.engine.Main.start(Unknown Source)

at sun.applet.AppletPanel.run(AppletPanel.java:377)

at java.lang.Thread.run(Thread.java:534)

Re: Oracle Forms Is this possible?!?!?! [message #352254 is a reply to message #351838] Mon, 06 October 2008 22:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You want to have an Oracle Forms form into which the user types their data, this form then turns this data into a string which is 'wrapped' and 'signed' and sent to the server to do something. Is this correct?

David
Re: Oracle Forms Is this possible?!?!?! [message #352915 is a reply to message #352254] Fri, 10 October 2008 04:16 Go to previous messageGo to next message
mnenchev
Messages: 6
Registered: October 2008
Junior Member
yes exactly. I almost managed to do that. I have a VBean that collects all fields from a canvas in oracle form and then "sign" them and finally place the result as string in other form field. I managed to do the server side. I.e. i import some java classes from the oracle forms builder and wrap the methods as pl/sql functions and i can call them on some events.
It was quite easy, but the configuration of the oracle forms and other stuff was discusting.
I have another problem now, is it possible to access the applet or the applet context under the form? I need to place some links on my java dialogs popuped from the bean. Do you know how to do that?
Best regards

[Updated on: Fri, 10 October 2008 04:18]

Report message to a moderator

Re: Oracle Forms Is this possible?!?!?! [message #353964 is a reply to message #352915] Wed, 15 October 2008 22:48 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Of course it is disgusting! Performing an abortion in any world, whether it be the physical, meta-physical or computing world, is disgusting, and that is what you are doing to your form and its data.

Does this mean your are trying to get the form to do a 'read'?

David
Previous Topic: Forms 6i
Next Topic: Dcoumentation of Forms
Goto Forum:
  


Current Time: Mon Feb 10 01:00:48 CST 2025