Please don't answer. I was looking for the english version of mailing list.
Sorry.
Am 10.02.2010 13:13, schrieb Johannes Hoechstaedter:
Hi everybody,
I am a developer for the memoComp company in Germany. We are
supporting openoffice applications as well as other java technologies.
Now my major concern:
We developed a webservice, which transfers data from MS-Excel (xls)
type files into a custom template of openoffice calc. This webservice
is written in Java and is using the UNO-Api Interface. For its task
the service creates an calc file from our template (ots) for every
incoming xls file, and simply copies the content from the incoming xls
into the newly created file cell by cell. Nothing strange up here.
Everything is working in theory and reality.
Relevant code:
XCell newCell = xSpreadsheetOut.getCellByPosition(x, y);
newCell.setFormula("...");
The problem now is that the service throws runtime excptions for which
I have not found any useful documentation files till now. The stack
trace is the following:
com.sun.star.uno.RuntimeException: getInstance expected XInterface but
got com.sun.star.table.XCell
at
com.sun.star.lib.uno.environments.remote.Job.remoteUnoRequestRaisedException(Job.java:182)
at com.sun.star.lib.uno.environments.remote.Job.execute(Job.java:148)
at
com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:344)
at
com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:313)
at
com.sun.star.lib.uno.environments.remote.JavaThreadPool.enter(JavaThreadPool.java:101)
at
com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest(java_remote_bridge.java:652)
at
com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.request(ProxyFactory.java:154)
at
com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.invoke(ProxyFactory.java:136)
at $Proxy8.setFormula(Unknown Source)
at
de.xxx.ReportImporter.copyRangesIntoTemplateAndStoreDocument(Unknown
Source)
[...]
java.lang.NullPointerException
at de.memocomp.oo.OOManager.closeDocument(Unknown Source)
at
de.xxx.ReportImporter.copyRangesIntoTemplateAndStoreDocument(Unknown
Source)
[...]
What I am able to say is, that the service was designed to run
asynchronous. If we do so, the exception appears more often. If the
service runs queued or in a pipline it works quite well. The exception
above then appeard only once in ~30 runs, but it appeared.
Trying retries if the error occurs, even with 10sec wait in between
did not had any positive (or negative) effect on the issue. Testing
the cast of the XCell to XInterface before the call works fine, even
if the error occurs:
Code:
XCell newCell = xSpreadsheetOut.getCellByPosition(x, y);
XInterface x = newCell;
newCell.setFormula("...");
The environment were the webservice is installed is a windows server
where two tomcat instances are running managed by a load balancer.
Openoffice is in version 3.1 and is installed on the same server,
where the two instances (load balancing) of our webservice are
connecting to openoffice via socket.
The code to instanciate and connect to openoffice is the
Bootstrap-Connector from hol.sten. available under:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=44&t=2520
[...]
String hostAndPort = "host="+host+",port="+port;
// accept option
String oooAcceptOption = "-accept=socket,"+hostAndPort+";urp;";
// connection string
String unoConnectString =
"uno:socket,"+hostAndPort+";urp;StarOffice.ComponentContext";
[...]
Runtime.getRuntime().exec(oooCommand);
[...]
XComponentContext xLocalContext =
Bootstrap.createInitialComponentContext(null);
[...]
We re looking forward to any helpful response, helping to understand
and to solve this exception.
Thanks in advance.
--
Johannes Höchstädter
www.memocomp.de
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
