OpenScript and Oracle forms 10g
Well, have I had fun today.
Trying to record a functional test script with Oracle forms. It's been a long day, and I have had enough. To cut a very,very,very long story short here is the output from the Java console once I got the 10g forms demo working with IE7.
Oracle JInitiator: Version 1.3.1.22
Using JRE version 1.3.1.22-internal Java HotSpot(TM) Client VM
User home directory = C:\Documents and Settings\wayne.SCLOFFICE
Proxy Configuration: no proxy
JAR cache enabled
Location: C:\Documents and Settings\wayne.SCLOFFICE\Oracle Jar Cache
Maximum size: 50 MB
Compression level: 0
----------------------------------------------------
c: clear console window
f: finalize objects on finalization queue
g: garbage collect
h: display this help message
l: dump classloader list
m: print memory usage
q: hide console
s: dump system properties
t: dump thread list
x: clear classloader cache
0-5: set trace level to <n>
----------------------------------------------------
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndforms.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndformsi18n.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndewt.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndswing.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndbalishare.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndaol.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndctx.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndlist.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndutil.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndtcf.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndgantt.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndpromise.jar
Downloading...http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndjewt.jar
Error1: File not found: http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndjewt.jar
java.io.FileNotFoundException: File not found: http://apollo.scloffice.com:8889/forms/java/oracle/apps/fnd/jar/fndjewt.jar
at sun.plugin.protocol.jdk12.http.HttpURLConnection.getInputStream(Unknown Source)
at java.net.URL.openStream(Unknown Source)
at oracle.oats.scripting.modules.formsFT.classloader.FormsFTClassLoader.download(Unknown Source)
at oracle.oats.scripting.modules.formsFT.classloader.FormsFTClassLoader.loadFormsClient(Unknown Source)
at oracle.oats.scripting.modules.formsFT.classloader.FormsFTClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(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)
Load Forms Jars from target instance ...
0...http://apollo.scloffice.com:8889/forms/java/frmall_jinit.jar
1...http://apollo.scloffice.com:8889/forms/formsdemo/jars/demo.jar
2...http://apollo.scloffice.com:8889/forms/formsdemo/jars/icons.jar
3...http://apollo.scloffice.com:8889/forms/java/
cracked oracle.forms.engine.Main
cracked oracle.forms.engine.Runform
Forms Version: 10.1.2.0
cracked oracle.ewt.lwAWT.LWScrollbar
cracked oracle.forms.net.SocketConnection
servarg: escapeParams=true module=healthyliving.fmx userid= sso_userid=%20 sso_formsid=%25OID_FORMSID%25 sso_subDN= sso_usrDN= debug=no host= port= output_dir=g:\oracle\DevSuiteHome_1\forms\demos\temp record=names
cracked oracle.forms.net.HTTPConnection
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
Forms Applet version is : 10.1.2.0
log4j:WARN No appenders could be found for logger (oracle.oats.scripting.modules.formsFT.helper.helperService.HelperServiceConnection).
log4j:WARN Please initialize the log4j system properly.
Helper Service Message :<Message name = "StartConnection" port="44444"/>
Initialize Debugger: null
java.lang.NoClassDefFoundError: oracle/apps/fnd/ui/ChoiceBox
at oracle.oats.scripting.modules.formsFT.helper.Context.getComponent(Unknown Source)
at oracle.oats.scripting.modules.formsFT.helper.Engine.onPutMessage(Unknown Source)
at oracle.oats.scripting.modules.formsFT.helper.OracleFormHook.onPutMessage(Unknown Source)
at oracle.forms.net.HTTPConnection.putMessage(Unknown Source)
at oracle.forms.engine.FormsDispatcher.putMessage(Unknown Source)
at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
at oracle.forms.engine.Runform.onMessage_C(Unknown Source)
at oracle.forms.engine.Runform.onMessage(Unknown Source)
at oracle.forms.engine.Runform.sendInitialMessage(Unknown Source)
at oracle.forms.engine.Runform.startRunform_C(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(Unknown Source)
at java.lang.Thread.run(Unknown Source)
OpenScript server port is 44444
Now then points to note:
1) Openscript does not ship with the complete forms jars. Hence the download failure from the server (I think?).
2) The NoClassDefFoundError java.lang.NoClassDefFoundError: oracle/apps/fnd/ui/ChoiceBox makes sure the app does not appear (although outside of Openscript everything is cool!!). After an age, I found that this particular class is located is EBS11i_CrackedClass.jar which is a jar file in one of the lib directories of Openscript. On my install G:\oracleATS9\OpenScript\openscript_configuration\org.eclipse.osgi\bundles\49\1\.cp\lib\formsClient\EBS11i_CrackedClass.jar to be precise.
Question: Does this file need to be referenced by the app config?? I'm sure I'm very close to getting this working but ClassNotFoundErrors do not help.
Any input woudl be GREATLY appreciated.
Regards
Wayne.