JDBC and Open Office..

Thread view:

Shane Trahan - 20 Jul 2006 13:30 GMT

Does anyone know what drivers to use for Open Office ? I am using MAC
OSX and do not have ODBC...

Class.forName("OpenOffice.Driver");
String url = "jdbc:OpenOfficexxxxxxxx";
Connection con = DriverManager.getConnection(url,
"USERNAME", "PASSWORD");

Thanx
Shane

Reply to this Message

Thomas Kellerer - 20 Jul 2006 13:33 GMT

On 20.07.2006 14:30 Shane Trahan wrote:

> Does anyone know what drivers to use for Open Office ? I am using MAC
> OSX and do not have ODBC...
[quoted text clipped - 3 lines]
> Connection con = DriverManager.getConnection(url,
> "USERNAME", "PASSWORD");

The built-in database for OOo is HSQL (www.hsqldb.org), so that would be
the driver to use. The problem is that the OOo file is not the database
as expected by HSQL. The OOo file is actually a ZIP file that contains
the HSQL database. So unless you unpack the database files from the OOo
archive, I don't think you can connect to the database with "plain" JDBC

Cheers
Thomas

Signature

It's not a RootKit - it's a Sony

Reply to this Message

IchBin - 20 Jul 2006 20:29 GMT

> On 20.07.2006 14:30 Shane Trahan wrote:
>> Does anyone know what drivers to use for Open Office ? I am using MAC
[quoted text clipped - 13 lines]
> Cheers
> Thomas

Yes, the driver class is: "org.hsqldb.jdbcDriver"

In memory url: jdbc:hsqldb:mem:.
Standalone url: jdbc:hsqldb:file:«database/path?»
Server url: jdbc:hsqldb:hsql://localhost/

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

JDBC and Open Office..

Free Magazines