Connect to OpenOffice

mercergeoinfo · April 25, 2017, 11:50am

I’m having problems connect JabRef to OpenOffice on Windows 7. I’ve tried manually connecting to

C:\Program Files (x86)\OpenOffice 4

which sets Java trying to connect but never getting anywhere because soffice.exe isn’t there, it’s in.

C:\Program Files (x86)\OpenOffice 4\program

If I try this then I instead get a file not found error message

C:\Program Files (x86)\OpenOffice 4\program\program\classes\unoil.jar

can’t be found, which isn’t surprising as there is no subfolder to “program” called “program”

stefan-kolb · April 25, 2017, 2:25pm

Hi,

which version of JabRef are you using?
We recently made some changes to fix the connection behavior (See https://github.com/JabRef/jabref/issues/2484).
This should be fixed in JabRef 3.8.2 and the most recent build from https://builds.jabref.org

Stefan

mercergeoinfo · April 26, 2017, 6:56am

I’ve just updated to 3.8.2 but am still having the same problem.I tried a
naive workaround, creating a shortcut in the “OpenOffice 4” folder to the
soffice.exe in “program”, but this didn’t help, the connection can’t be
made and Java just ticks away patiently.

mercergeoinfo · April 26, 2017, 7:01am

Hi Stefan,
I just tried putting the path into quotes (“C:\Program Files
(x86)\OpenOffice 4” which then lead to a similar unfound file error as
before but this time

“C:\Program Files (x86)\OpenOffice 4”\program\classes\unoil.tar

can’t be found, of course.

stefan-kolb · April 26, 2017, 7:31am

Hi,

please try the latest master build from https://builds.jabref.org. I forgot that the changes are not in 3.8.2 but only in master right now.

mercergeoinfo · April 26, 2017, 10:49am

I downloaded 4.0.0 beta. It seems that the connection is made, at least no
errors are shown when using both the automatic connect and manual connect.
Unfortunately the buttons for pushing cites to OpenOffice are still greyed
out and the select document and update library buttons are unresponsive.
Reading the online help, it suggests that there should be a “Push to
OpenOffice” tool in the Tools menu. This appears to be incorrect, under
this menu there can be found push to e.g. TexStudio (which works) and the
OpenOffice connection tool, but not a “push to Openoffice” tool.

mvh
Andrew

stefan-kolb · April 26, 2017, 11:09am

Hi,

ok this should not happen. Any errors inside the error console (Help - View Event Log)?

mercergeoinfo · April 26, 2017, 3:20pm

Here’s a copy of the whole log.
Sorry for the delay, I’ve been teaching until now.

Migrating old preferences.
Opening: C:\Users\anwmer.HIG-AD\Box
Sync\Geovetenskap\VT17\XQ_projekt\Litteraturlista\Geovetenskap.bib
Opening: C:\Users\anwmer.HIG-AD\Box
Sync\Geovetenskap\Literature\Search\GeovetProjekt.bib
Uncaught exception Occurred in Thread[AWT-EventQueue-0,6,main]
java.nio.file.InvalidPathException: Illegal char <"> at index 0:
"C:\Program Files (x86)\OpenOffice 4"
at sun.nio.fs.WindowsPathParser.normalize(Unknown Source)
at sun.nio.fs.WindowsPathParser.parse(Unknown Source)
at sun.nio.fs.WindowsPathParser.parse(Unknown Source)
at sun.nio.fs.WindowsPath.parse(Unknown Source)
at sun.nio.fs.WindowsFileSystem.getPath(Unknown Source)
at java.nio.file.Paths.get(Unknown Source)
at
org.jabref.gui.openoffice.OpenOfficePanel.connect(OpenOfficePanel.java:388)
at
org.jabref.gui.openoffice.OpenOfficePanel.lambda$initPanel$0(OpenOfficePanel.java:145)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.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.Window.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)

Uncaught exception Occurred in Thread[AWT-EventQueue-0,6,main]
java.nio.file.InvalidPathException: Illegal char <"> at index 0:
"C:\Program Files (x86)\OpenOffice 4"
at sun.nio.fs.WindowsPathParser.normalize(Unknown Source)
at sun.nio.fs.WindowsPathParser.parse(Unknown Source)
at sun.nio.fs.WindowsPathParser.parse(Unknown Source)
at sun.nio.fs.WindowsPath.parse(Unknown Source)
at sun.nio.fs.WindowsFileSystem.getPath(Unknown Source)
at java.nio.file.Paths.get(Unknown Source)
at
org.jabref.gui.openoffice.OpenOfficePanel.connect(OpenOfficePanel.java:388)
at
org.jabref.gui.openoffice.OpenOfficePanel.lambda$initPanel$0(OpenOfficePanel.java:145)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.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.Window.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)

Could not connect to running OpenOffice/LibreOffice
java.lang.UnsatisfiedLinkError: C:\Program Files (x86)\OpenOffice
4\program\jpipe.dll: Can’t load IA 32-bit .dll on a AMD 64-bit platform
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.load0(Unknown Source)
at java.lang.System.load(Unknown Source)
at
com.sun.star.lib.util.NativeLibraryLoader.loadLibrary(NativeLibraryLoader.java:67)
at
com.sun.star.lib.connections.pipe.PipeConnection.(PipeConnection.java:58)
at
com.sun.star.lib.connections.pipe.pipeConnector.connect(pipeConnector.java:115)
at com.sun.star.comp.connections.Connector.connect(Connector.java:119)
at
com.sun.star.comp.urlresolver.UrlResolver$_UrlResolver.resolve(UrlResolver.java:116)
at com.sun.star.comp.helper.Bootstrap.bootstrap(Bootstrap.java:278)
at org.jabref.gui.openoffice.OOBibBase.simpleBootstrap(OOBibBase.java:238)
at org.jabref.gui.openoffice.OOBibBase.(OOBibBase.java:154)
at org.jabref.gui.openoffice.OpenOfficePanel.run(OpenOfficePanel.java:452)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at spin.Invocation.evaluate(Invocation.java:175)
at spin.off.SpinOffEvaluator$1.run(SpinOffEvaluator.java:108)
at java.lang.Thread.run(Unknown Source)

Uncaught exception Occurred in Thread[AWT-EventQueue-0,6,main]
java.lang.NoClassDefFoundError: Could not initialize class
com.sun.star.lib.connections.pipe.PipeConnection
at
com.sun.star.lib.connections.pipe.pipeConnector.connect(pipeConnector.java:115)
at com.sun.star.comp.connections.Connector.connect(Connector.java:119)
at
com.sun.star.comp.urlresolver.UrlResolver$_UrlResolver.resolve(UrlResolver.java:116)
at com.sun.star.comp.helper.Bootstrap.bootstrap(Bootstrap.java:278)
at org.jabref.gui.openoffice.OOBibBase.simpleBootstrap(OOBibBase.java:238)
at org.jabref.gui.openoffice.OOBibBase.(OOBibBase.java:154)
at org.jabref.gui.openoffice.OpenOfficePanel.run(OpenOfficePanel.java:452)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at spin.Invocation.evaluate(Invocation.java:175)
at spin.off.SpinOffEvaluator$1.run(SpinOffEvaluator.java:108)
at java.lang.Thread.run(Unknown Source)

Uncaught exception Occurred in Thread[AWT-EventQueue-0,6,main]
java.lang.NoClassDefFoundError: Could not initialize class
com.sun.star.lib.connections.pipe.PipeConnection
at
com.sun.star.lib.connections.pipe.pipeConnector.connect(pipeConnector.java:115)
at com.sun.star.comp.connections.Connector.connect(Connector.java:119)
at
com.sun.star.comp.urlresolver.UrlResolver$_UrlResolver.resolve(UrlResolver.java:116)
at com.sun.star.comp.helper.Bootstrap.bootstrap(Bootstrap.java:278)
at org.jabref.gui.openoffice.OOBibBase.simpleBootstrap(OOBibBase.java:238)
at org.jabref.gui.openoffice.OOBibBase.(OOBibBase.java:154)
at org.jabref.gui.openoffice.OpenOfficePanel.run(OpenOfficePanel.java:452)
at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at spin.Invocation.evaluate(Invocation.java:175)
at spin.off.SpinOffEvaluator$1.run(SpinOffEvaluator.java:108)
at java.lang.Thread.run(Unknown Source)

stefan-kolb · April 26, 2017, 4:04pm

Maybe the problem is an old path String you entered manually in 3.8.2.
It should not start with " which it obviously is:

java.nio.file.InvalidPathException: Illegal char <"> at index 0:
"C:\Program Files (x86)\OpenOffice 4"

Can you try to click settings -> clear connection settings and redo the oo connection.
Hopefully it will work as expected then.

mercergeoinfo · April 27, 2017, 6:34am

I probably didn’t make myself clear, The quote mark variant is something I
tried after the problem arose, as an attempt to solve it. The problem
persists even after clearing the settings. I put the quote marks in because
I know from Unix-like systems that whitespace in a path is "a bad thing"
and “OpenOffice 4” contains whitespace. I’m not familiar with the Windows
command line (only some simple commands) and am not sure what would be
appropriate.

Just to make sure I tried clearing the settings and connecting again using
the automatic connection. The first time it tried it returned an
unspecified error, maybe Jabref and OO aren’t running in 64bit mode. There
is only one exe for Windows available for OO and the Jabref I downloaded is
the beta, which I’m assuming is also 64.
Subsequent connections don’t return an error but the cite buttons are still
greyed out and the select document and update bibliography buttons are
still unresponsive.

Andrew

stefan-kolb · April 27, 2017, 7:15am

If JabRef is the 64-bit version and OO the 32-bit version it will not work (as some error suggests?!). Both need to be in the same bit system. Also note that this system is determined by the Java JDK/JRE that is running JabRef and or OO.

mercergeoinfo · April 27, 2017, 7:42am

There is only one Windows exe for OO and the installer gives no option for
32 or 64

Andrew

mercergeoinfo · April 27, 2017, 8:10am

Hi Stefan,
I uninstalled OO, installed Java 64 offline, reinstalled OO but the problem
persists.
For myself it isn’t a problem as everything works fine on my Mac but I
would like to know that everything works as advertised on Windows so that I
can recommend Jabref and OO to my students (I can’t go as far LaTeX with
them, that would be too much to ask).

Andrew

stefan-kolb · April 27, 2017, 9:05am

Yeah I think OO is only available with 32-bit, so you can only work with it with 32-bit JabRef and 32-bit Java.

stefan-kolb · April 27, 2017, 9:10am

I think this is also documented under known issues on the help page (https://help.jabref.org/en/OpenOfficeIntegration). Does that help? I tested a lot of configurations during the PR, so I think this might be the problem here?!
See https://github.com/JabRef/jabref/pull/2644

mercergeoinfo · April 27, 2017, 10:29am

OK. I’ll look into it soon.
Thanks for the help

Topic		Replies	Views
Connection to OO finds more than one OO executable Help	5	719	July 2, 2018
Problem connecting JabRef to OpenOffice 4.1.15 Help	3	24	November 4, 2024
Failure to connect to LibreOffice Help	6	119	June 13, 2024
Connect to openoffice database fails Help	2	894	September 2, 2019
Connecting with LibreOffice Snap under Ubuntu 16.04 Help	10	4387	July 1, 2018

Connect to OpenOffice

Related topics