Home » Developer & Programmer » Forms » CLIENT_OLE2 functions are not working in Oracle Forms 12c (Oracle Forms 12c,Windows 8.1 64 bit)
CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #649859] Sun, 10 April 2016 01:20 Go to next message
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
Member
Hi Experts,
I hope you all are doing well.
Oracle Forms 12c,Windows 8.1 64 bit, Mozilla Firefox 44.0.2 32 bit.
I am really astonished about the fact that the only OLE(without webutil) is working correctly with ms office 2013,
But CLIENT_OLE2.Create_Obj of webutil is not working all all.
And another question is that i am not able to run forms 12c in IE 11 64 bit browser.

I am getting this error in java console.

Quote:

Forms Session ID is WLS_FORMS.formsapp.3
The proxy host is null, and the proxy port is 0.
Native HTTP implementation is being used for the connection.
The connection mode is HTTP.
Forms Applet version is 12.2.1.0
Exception in thread "AWT-EventQueue-2" java.lang.ExceptionInInitializerError
at oracle.forms.webutil.ole.OleFunctions.create_obj(Unknown Source)
at oracle.forms.webutil.ole.OleFunctions.getProperty(Unknown Source)
at oracle.forms.handler.UICommon.onGet(Unknown Source)
at oracle.forms.engine.Runform.onGetHandler(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.processEventEnd(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "jacob.dll.path" "read")
at java.security.AccessControlContext.checkPermission(Unknown Source)
at java.security.AccessController.checkPermission(Unknown Source)
at java.lang.SecurityManager.checkPermission(Unknown Source)
at sun.plugin2.applet.AWTAppletSecurityManager.checkPermission(Unknown Source)
at java.lang.SecurityManager.checkPropertyAccess(Unknown Source)
at java.lang.System.getProperty(Unknown Source)
at com.jacob.com.LibraryLoader.loadJacobLibrary(LibraryLoader.java:143)
at com.jacob.com.ComThread.<clinit>(ComThread.java:167)


Any help is appreciated.
Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #650643 is a reply to message #649859] Thu, 28 April 2016 10:33 Go to previous messageGo to next message
javigarsan
Messages: 4
Registered: April 2016
Location: Spain
Junior Member
Hi kalpataru,

I get the same error using client_ole2.create_obj('Excel.Application'), but with ole2.create_obj('Excel.Application') it works!!

Have you solved it? How?

Thanks
Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #650686 is a reply to message #650643] Fri, 29 April 2016 09:07 Go to previous messageGo to next message
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
Member
Yes i have solved by signing the jacob.jar file. Laughing Mad
Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #650687 is a reply to message #650686] Fri, 29 April 2016 09:18 Go to previous messageGo to next message
javigarsan
Messages: 4
Registered: April 2016
Location: Spain
Junior Member
My problem must be other because I'm not using ssl yet.
Thanks for your information. I'll continue looking for a solution
Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #650707 is a reply to message #650687] Sat, 30 April 2016 09:45 Go to previous messageGo to next message
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
Member
Hi javigarsan,

Can you describe your problem so that i can help you ?
What are you getting in your java console error if any like me as posted above ?

What do you mean by this Quote:
My problem must be other because I'm not using ssl yet.
?

What do you mean by ssl i am not getting ?
I think if you sign the jacob.jar your problem will be solved.

Check this link https://docs.oracle.com/middleware/1221/formsandreports/FRREL/forms.htm#FRREL4135
Forms 12c supports JACOB version 1.18-M2.

Download link https://sourceforge.net/projects/jacob-project/files/jacob-project/1.18-M2/
Direct download link https://sourceforge.net/projects/jacob-project/files/jacob-project/1.18-M2/jacob-1.18-M2.zip/download
Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #650780 is a reply to message #650707] Tue, 03 May 2016 10:19 Go to previous messageGo to next message
javigarsan
Messages: 4
Registered: April 2016
Location: Spain
Junior Member
Hi Kalpataru:

I've had some days off and I can't answear earler.

In my case, I can use for example functions like client_get_file_name without problems.

But when I use CLIENT_OLE2.CREATE_OBJ('Excel.Application') I get an error.

I think I must sign the jacob.jar file when I use secure https://.... Now I'm using http://

Must I sign jacob.jar anyway? How sign it?

When I get the error, in my console get this:

Java Plugin 11.91.2.14
Usando versión de JRE 1.8.0_91-b14 Java HotSpot(TM) Client VM
Directorio de inicio del usuario = C:\Users\jgs
----------------------------------------------------
c: borrar ventana de consola
f: finalizar objetos en la cola de finalización
g: recopilación de basura
h: mostrar este mensaje de ayuda
l: volcar lista de classloader
m: imprimir uso de memoria
o: disparar registro
q: ocultar consola
r: recargar configuración de política
s: volcar propiedades del sistema y de despliegue
t: volcar lista de threads
v: volcar pila de threads
x: borrar caché de classloader
0-5: definir nivel de rastreo en <n>
----------------------------------------------------
CacheEntry[http://192.168.0.10:9001/forms/java/jacob.jar]: updateAvailable=true,lastModified=Wed Aug 05 05:01:26 CEST 2015,length=-1
El identificador de sesión de Forms es WLS_FORMS.formsapp.27
El host del proxy es null y el puerto del proxy es 0.
Se esta utilizando la implantación HTTP nativa para la conexión.
El modo de conexión es HTTP.
La versión del applet Forms es 12.2.1.0
0
Exception in thread "AWT-EventQueue-2" java.lang.ExceptionInInitializerError
at oracle.forms.webutil.ole.OleFunctions.create_obj(Unknown Source)
at oracle.forms.webutil.ole.OleFunctions.getProperty(Unknown Source)
at oracle.forms.handler.UICommon.onGet(Unknown Source)
at oracle.forms.engine.Runform.onGetHandler(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.processEventEnd(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "jacob.dll.path" "read")
at java.security.AccessControlContext.checkPermission(Unknown Source)
at java.security.AccessController.checkPermission(Unknown Source)
at java.lang.SecurityManager.checkPermission(Unknown Source)
at sun.plugin2.applet.AWTAppletSecurityManager.checkPermission(Unknown Source)
at java.lang.SecurityManager.checkPropertyAccess(Unknown Source)
at java.lang.System.getProperty(Unknown Source)
at com.jacob.com.LibraryLoader.loadJacobLibrary(LibraryLoader.java:143)
at com.jacob.com.ComThread.<clinit>(ComThread.java:167)
... 32 more

Thank you for your interest...

I hope you can help me.
Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #656159 is a reply to message #650687] Mon, 26 September 2016 04:40 Go to previous messageGo to next message
jiju_alex_mathew
Messages: 2
Registered: May 2011
Junior Member
Hi,

How to sign jacob.jar in forms 12c in windows environment? Please help me.

Regards
Jiju

Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #657180 is a reply to message #656159] Fri, 28 October 2016 18:22 Go to previous messageGo to next message
nnigam
Messages: 12
Registered: May 2012
Location: Washington, DC
Junior Member
You will need to get a code signing certificate from a provider trusted by your browser. You can use that to sign the file using jarsigner.

replace your keystore with your p12 file or any supported format using the storetype parameter. I also timestamp mine

jarsigner -verbose -keystore d:\certs\nnino.p12 -storetype pkcs12 -tsa http://timestamp.comodoca.com/rfc3161 -digestalg SHA-1 jacob.jar 1

I just set myself up as a certificate authority, installed it to my browser, created a signing certificate and signed it using that all with openssl.

Re: CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #657181 is a reply to message #650780] Fri, 28 October 2016 18:23 Go to previous message
nnigam
Messages: 12
Registered: May 2012
Location: Washington, DC
Junior Member
What error are you getting? My system is crashing on create_obj, but no error messages.
Previous Topic: how to center a window oracle forms relative to the computer's screen
Next Topic: oracle reports 10g running on browser
Goto Forum:
  


Current Time: Sun Jan 26 05:37:25 CST 2020