Using Java with OOo

SomeoneHere · Posted: Thu Mar 02, 2006 7:04 am Post subject: Using Java with OOo

Well first off let me say that I am a newbie when it comes to using java with OOo. And I don't know if this is where I should be posting this question but any information that anyone can give me would be very much appreciated. Let me start out with giving a thanks to Lars Behrmann for his link http://opendocument4all.com/content/view/70/1/ I used it to create my program using java. I have been fooling around with macros and learning more and more OOo Basic. But I am assuming that basic has it's limits. I would like to be able to take values from a spreadsheet and enter them to a website and then the user can enter another value and the result is emailed to me. I have already made the form in the webpage and a php file to email the results to me. I figure that using java I would be able to take the value out of the spreadsheet and insert it to the website (maybe I can't do it, it might not be possible). Now here is one of my problems it has been about 4 or 5 years since i took java programming in college. And when I did that all I used was some compiler program from microsoft. But maybe I am wrong but I could have sworn that the program created an executable file. The program that I wrote with the help of Lars Behrmann did not. Any pointers or help that you can give would be very much appreciated.

Jiml · General User Joined: 10 Feb 2006 Posts: 24

I only know a little about Java programming, and nothing about using it to take values off of a spreadsheet, but I believe the executable that you want to create is a JAR file. See the java documentation as to how to create one with the jar tool, or you may be able to use eclipse to do it, but I am not at all familiar with that.

SomeoneHere · Posted: Thu Mar 02, 2006 8:52 am Post subject:

Yes I can make a jar file but isn't that file just similar to a zip file? Is it just a compression file??

Jiml · General User Joined: 10 Feb 2006 Posts: 24

While a jar file is compressed, you can use it for more than that. see this extensive explanation from sun:

http://java.sun.com/j2se/1.5.0/docs/guide/jar/jar.html

I think you would just need to have a runtime installed, and then you can execute the jar file by just clicking on it. I have one that I made some time ago and it still works.

SomeoneHere · Posted: Thu Mar 02, 2006 11:43 am Post subject:

Well I looked on this website http://mindprod.com/jgloss/jar.html#EXECUTING and I followed the instructions step by step. But I could not find where to change the step 4 about the "MIME" when I click on the jar file I get the error message "Failed to load Main Class manifest attribute". Anyone have any ideas???

Jiml · General User Joined: 10 Feb 2006 Posts: 24

the proper mime type seems to be application/java-archive

fyi, Lots of stuff in my file types does not have a mime type.

I do not have jar in my file types, though, and I can still double click them to work them.

SomeoneHere · Posted: Mon Mar 06, 2006 6:06 am Post subject:

I do have a question now if I run the command java -jar "javaapplication1.jar" in the directory the jar file is in why would I get an error java.lang.noclassdeffoundererror:com/sun/star/comp/helper/Bootstrapexception

for this code:

hol.sten · Posted: Mon Mar 06, 2006 10:41 am Post subject:

SomeoneHere · Posted: Mon Mar 06, 2006 11:06 am Post subject:

hol.sten thank you very much for your idea but regretfully that wasn't it. I checked and the juh.jar, jurt.jar ,etc that you mentioned are all in my classpath both in netbeans and in the manifest file that the project created. That is one of the things that is weird to me that it works when I run in netbeans. But when I run it through the command line I get an exception. But please any more help or ideas that you or anyone have would be greatly appreciated.

hol.sten · Posted: Mon Mar 06, 2006 11:16 am Post subject:

SomeoneHere · Posted: Mon Mar 06, 2006 11:43 am Post subject:

hol.sten once again thanks for your suggestion but as far as I can tell everything is included in the classpath. All the classes from the OOo installation, and all Classes from the OOo SDK. I had read the instructions for netbeans when I first made the project and added them accordingly. I checking through everything again and they are in the classpath. But regretfully still the same error Crying or Very sad

hol.sten · Posted: Mon Mar 06, 2006 11:58 am Post subject:

I want to return to this question:

SomeoneHere · Posted: Mon Mar 06, 2006 12:06 pm Post subject:

First off you are almost right I do use start->run->cmd but we use windows 2000 (regretfully our work software that we run can only be used on this platform)
This is what the set command brought up:

C:\Testing\JavaApplication1\dist>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\mark\Application Data
CI_HOLOS_CLI=C:\Program Files\Seagate Software\Open OLAP
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SERVERX
ComSpec=C:\WINNT\system32\cmd.exe
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\mark
LOGONSERVER=\\SERVERX
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Os2LibPath=C:\WINNT\system32\os2\dll;
Path=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\ENVELOP\PROGRAM
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0209
ProgramFiles=C:\Program Files
PROMPT=$P$G
SystemDrive=C:
SystemRoot=C:\WINNT
TEMP=C:\DOCUME~1\mark\LOCALS~1\Temp
TMP=C:\DOCUME~1\mark\LOCALS~1\Temp
USERDOMAIN=SERVERX
USERNAME=mark
USERPROFILE=C:\Documents and Settings\mark
windir=C:\WINNT

hol.sten · Posted: Mon Mar 06, 2006 12:22 pm Post subject:

SomeoneHere · Posted: Mon Mar 06, 2006 12:33 pm Post subject:

hol.sten sorry to bother you again with my foolish questions but the code you gave me to make the bat file. Do I need to put each individual jar file in there or can I just put the directory that all the jar files are in. Secondly the . that you have after the = sign is that needed before each file?