A ln -s /usr/share/jdbc-mysql/lib/jdbc-mysql.jar /opt/sun-jre-bin-1.5.0.06/jre/lib/ext/ solved all issues I had to connect to the mysql database with jdbc in ooffice-bin-2.0.3. B/c this is only a workaround is there a more general solution ?
eg, adding a file containing CLASSPATH=/usr/share/jdbc-mysql/lib/jdbc-mysql.jar into /etc/env.d ?
The first solution is probably better. It is really best to avoid putting stuff on the global CLASSPATH. Assigning to openoffice to handle it from here.
(In reply to comment #2) > The first solution is probably better. It is really best to avoid putting stuff > on the global CLASSPATH. > > Assigning to openoffice to handle it from here. > Actually this really does not look like something we should do in the openoffice-ebuild, don't think playing around in directories of other packages is a good idea
I used to add jdbc-mysql jar to Extras->Options->OpenOffice.org->Java->Class Path. Now I see this bugreport and had a look at my openoffice installation. There is a nice script from Petr Mladek to set the global openoffice Java classpath. /usr/lib/openoffice/program/java-set-classpath To add jdbc-mysql.jar to it you would do: /usr/lib/openoffice/program/java-set-classpath $(java-config --classpath=jdbc-mysql 2>/dev/null) >/dev/null
(In reply to comment #3) > Actually this really does not look like something we should do in the > openoffice-ebuild, don't think playing around in directories of other packages > is a good idea > To be clear, what I was suggesting was to update openoffice-bin to depend on jdbc-mysql, and symlink in the jdbc-mysql.jar. Hanno's idea does look cleaner though. Perhaps that could be done during the merge?
(In reply to comment #4) > I used to add jdbc-mysql jar to Extras->Options->OpenOffice.org->Java->Class > Path. Now I see this bugreport and had a look at my openoffice installation. > This works fine, should be mentioned in the ebuild. Closing this bug.
(In reply to comment #5) > (In reply to comment #3) > > Actually this really does not look like something we should do in the > > openoffice-ebuild, don't think playing around in directories of other packages > > is a good idea > > > > To be clear, what I was suggesting was to update openoffice-bin to depend on > jdbc-mysql, and symlink in the jdbc-mysql.jar. > > Hanno's idea does look cleaner though. Perhaps that could be done during the > merge? > Will take a look at it, anyway: This bug should not be closed
@Hanno: Do you have an idea which other jars we should add to the classpath? Cause it would be great to handle them all and not only just one
I do not know about others.
We do this in openoffice now, closing
