setting java classpath for Libre Office Base (used for JDBC)

[foampile]

i want to use Libre Office Base to connect to MySQL. when i set up the JDBC connection, it asks me for the driver, however, it cannot be loaded (because it doesn't see it in the classpath).

does anybody know how to set the classpath for Libre Office? is there like a config util tool for that?

e.g. my driver is com.mysql.jdbc.Driver situated in /usr/share/java/mysql-connector-java-5.1.17.jar. it works fine when i connect from other JDBC clients, like straight Java or Eclipse Quantum plugin. the problem is that Libre Office does not ask me for the (class)path of where it can find the driver and i do not know where and how to set it so that it becomes visible.

thanks

[george_toolan]

Try something like

export CLASSPATH=/usr/share/java/mysql-connector-java-5.1.17.jar
libreoffice

[RupertPupkin]

Originally Posted by foampile

does anybody know how to set the classpath for Libre Office?

It should be under Tools->Options->Java.