Re: Oracle JDBC driver loading with OpenOffice

From: Juergen Lueters <jlueters_at_intranet-engineering.de>
Date: Mon, 14 Apr 2003 16:58:35 +0200
Message-ID: <pan.2003.04.14.14.58.34.783027_at_intranet-engineering.de>


[Quoted] Am Mon, 14 Apr 2003 07:42:06 -0700 schrieb franco.pecoraro_at_cec.eu.int:

> Hi,
>
> I installed OpenOffice under Linux RedHat 7.3, specifiying the correct
> Java installation path.
> I enabled all Java "features" of OpenOffice (included plugins and
> applets) and specified the full path name of Oracle JDBC driver via
> the menu Tools -> Options -> Security.
> After I created a datasource using this Oracle JDBC driver specifying
> the JDBC driver type, the Datasource URL
> (jdbc:oracle:thin_at_machine_name:oracle_listener_port:Oracle_sid), I
> tried to acces the Oracle database and I received the following
> message "The specified driver could not be loaded".
> 
> Help will be appreciated.

Under openoffice.org
tools->options->security add the oracle jdbcdriver to the classpath. Restart openoffice.org.

Be aware that you only get red-only access to the oracle database. From 1.1 beta 2 openoffice.org enable a workaround to that problem. Juergen Received on Mon Apr 14 2003 - 16:58:35 CEST

Original text of this message