OraFAQ Forum: Forms » CLIENT_OLE2 functions are not working in Oracle Forms 12c

Home » Developer & Programmer » Forms » CLIENT_OLE2 functions are not working in Oracle Forms 12c (Oracle Forms 12c,Windows 8.1 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CLIENT_OLE2 functions are not working in Oracle Forms 12c [message #649859]

Sun, 10 April 2016 01:20

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.

Report message to a moderator

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

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

Report message to a moderator

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

kalpataru
Messages: 72
Registered: January 2010
Location: INDIA

Member

Yes i have solved by signing the jacob.jar file. Laughing

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 08:16:58 CST 2025